1 Reply Latest reply on Jan 31, 2006 1:06 AM by aguizar

    Error creating database schema

    dharraj

      Hello,

      I have hsql db running on localhost at default port (1701). While trying to create schema (

      jbpmConfiguration.createSchema();
      ) I am getting following exception:
      Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1aae94f [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@dc67e [ 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@149d886 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:hsqldb:hsql://localhost:1701, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> 1aae94f ]
      Exception in thread "main" java.lang.ExceptionInInitializerError
       at org.hsqldb.jdbc.Util.<clinit>(Util.java:77)
       at org.hsqldb.jdbc.jdbcStatement.fetchResult(jdbcStatement.java:1580)
       at org.hsqldb.jdbc.jdbcStatement.executeUpdate(jdbcStatement.java:224)
       at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:63)
       at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:298)
       at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:281)
       at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:192)
       at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:135)
       at org.jbpm.persistence.db.DbPersistenceServiceFactory.createSchema(DbPersistenceServiceFactory.java:110)
       at org.jbpm.JbpmConfiguration.createSchema(JbpmConfiguration.java:383)
       at org.jbpm.JbpmConfiguration.createSchema(JbpmConfiguration.java:375)
       at jpl.mipl.pgs.test.HelloWorldDbTest.setUp(HelloWorldDbTest.java:81)
       at jpl.mipl.pgs.test.HelloWorldDbTest.<init>(HelloWorldDbTest.java:72)
       at jpl.mipl.pgs.test.HelloWorldDbTest.main(HelloWorldDbTest.java:273)
      Caused by: java.lang.RuntimeException
       at org.hsqldb.Trace.<clinit>(Trace.java:385)
       ... 14 more
      


      Any idea. Any one.

      Thanks
      Raj