2 Replies Latest reply on Aug 17, 2005 10:20 AM by fuck off

    Data Storing Problem

    Yue Ni Newbie

      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.

        • 1. Re: Data Storing Problem
          Yue Ni Newbie

          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


          • 2. Re: Data Storing Problem
            fuck off Newbie

            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