Data Storing Problem

[nybon]

Here's my jbpm.properties file:

jbpm.hibernate.properties=hibernate.properties
jbpm.hibernate.cfg.xml=hibernate.cfg.xml
jbpm.task.instance.class=org.jbpm.taskmgmt.exe.TaskInstance

Here's my hibernate.properties file:

hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/jbpm
hibernate.connection.username=jbpm
hibernate.connection.password=jbpm

hibernate.show_sql=true
hibernate.query.substitutions=true 1, false 0
hibernate.c3p0.min_size=1
hibernate.c3p0.max_size=3

It seems that those missing data are stored in memory(hsql database?), but I config the database as mysql here and the process definition is deployed in mysql database.

[nybon]

Here's the log4j info:

INFO [main] - C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/jbpm
INFO [main] - Connection properties: {user=jbpm, password=****}
INFO [main] - autocommit mode: false
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1938039 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@1eec35 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 3, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@81b1fb [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:mysql://localhost:3306/jbpm, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> 1938039 ]
INFO [main] - RDBMS: MySQL, version: 4.1.10-nt
INFO [main] - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.7 ( $Date: 2005/01/25 19:11:41 $, $Revision: 1.27.4.54 $ )
INFO [main] - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect

[russelldb]

I had the same problem.

This post
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=67431

solved the issue for me.

Regards

Russell