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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...