[jboss-user] [JBoss jBPM] - Re: Error setup with both MySQL and Hypersonic

[dthibau@opencs.net]

I have exactly the same error and as Florent I started to install with MySQL then go back to HSQL. 

I had to edit hibernate.cfg.xml to change the dialect to org.hibernate.dialect.HSQLDialect 

and my -ds.xml is as follows : 
<?xml version="1.0" encoding="UTF-8"?>
  | <datasources>
  | 
  |   <local-tx-datasource>
  |     <jndi-name>JbpmDS</jndi-name>
  | 
  |     <connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB</connection-url>
  |     <driver-class>org.hsqldb.jdbcDriver</driver-class>
  |     <user-name>sa</user-name>
  |     <password></password>
  | 
  |     <!-- connection pool parameters -->
  |     <min-pool-size>1</min-pool-size>
  |     <max-pool-size>5</max-pool-size>
  | 
  |     <!-- disable idle connection removal, hsqldb does not reap threads on closed connections -->
  |     <idle-timeout-minutes>0</idle-timeout-minutes>
  |     <!-- check all statements are closed when the connection is returned to the pool -->
  |     <track-statements />
  |     <!-- hsqldb benefits from prepared statement caching -->
  |     <prepared-statement-cache-size>32</prepared-statement-cache-size>
  | 
  |     <!-- corresponding type-mapping in conf/standardjbosscmp-jdbc.xml -->
  |     <metadata>
  |       <type-mapping>Hypersonic SQL</type-mapping>
  |     </metadata>
  | 
  |     <!-- ensure the datasource is not initialized before the database itself -->
  |     <depends>jboss:service=Hypersonic,database=jbpmDB</depends>
  |   </local-tx-datasource>
  | 
  |   <mbean code="org.jboss.jdbc.HypersonicDatabase" name="jboss:service=Hypersonic,database=jbpmDB">
  |     <attribute name="Database">jbpmDB</attribute>
  |     <attribute name="InProcessMode">true</attribute>
  |   </mbean>
  | 
  | </datasources>
  | 

Anything else to do ?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4200505#4200505

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4200505