2 Replies Latest reply on Mar 23, 2006 12:29 PM by tperrigo

    error running database test (PostgreSQL)

    tperrigo Newbie

      I'm trying to set up jbpm to use a local PostgreSQL database, following the instructions in the readme file (jbpm-db/readme.html). I'm stuck at step 10, though-- all of the tests executed by running ant postgresql.test error out. The error I'm getting (when I check the build results) is listed below. Can anyone tell me what I'm missing?

      Thanks in advance for any assistance!

      Tim

      Error message:

      com/mchange/v2/c3p0/PoolConfig

      java.lang.NoClassDefFoundError: com/mchange/v2/c3p0/PoolConfig at org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:84) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56) at org.hibernate.tool.hbm2ddl.SchemaExport$ProviderConnectionHelper.getConnection(SchemaExport.java:466) at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:183) at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:135) at org.jbpm.persistence.db.DbPersistenceServiceFactory.createSchema(DbPersistenceServiceFactory.java:107) at org.jbpm.JbpmConfiguration.createSchema(JbpmConfiguration.java:383) at org.jbpm.JbpmConfiguration.createSchema(JbpmConfiguration.java:375) at org.jbpm.db.AbstractDbTestCase.createSchema(AbstractDbTestCase.java:121) at org.jbpm.db.AbstractDbTestCase.setUp(AbstractDbTestCase.java:55)

        • 1. Re: error running database test (PostgreSQL)
          Alejandro Guizar Master

          The hibernate.properties file used in the PostgreSQL test contains settings for C3P0, a JDBC connection pool you can use with Hibernate. You can either include c3p0-[version].jar in the classpath or comment out the c3p0 settings:

          hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
          hibernate.connection.driver_class=org.postgresql.Driver
          hibernate.connection.url=jdbc:postgresql://localhost:5432/jbpmtest
          hibernate.connection.username=postgres
          hibernate.connection.password=postgres
          
          hibernate.show_sql=true
          # comment these out
          #hibernate.c3p0.min_size=1
          #hibernate.c3p0.max_size=3


          • 2. Re: error running database test (PostgreSQL)
            tperrigo Newbie

            Thanks Alex; commenting out the c3p0 lines worked. If the appropriate jar is not included by default, does it make sense to have these as default settings? Or do I have something amiss with my setup?

            Thanks again for your speedy reply!
            Tim