3 Replies Latest reply on Mar 7, 2006 5:53 AM by Koen Aers

    jbpm database name

    Aymen MASMOUDI Newbie

      hi,
      I have an othre database name and i would like to connect to it, i have changed hibernate.properties :
      hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:es41
      but it seam not sufficient
      i need help, thinks

        • 1. Re: jbpm database name
          Ronald van Kuijk Master

          why does it not seam sufficient? Do you get errors?

          This is the way I did it too, locally, and it works (although with mysql). Another option is to use jndi and configure a datasource.

          Ronald

          • 2. Re: jbpm database name
            Aymen MASMOUDI Newbie

            yes, i get this error

            09:53:59,521 INFO C3P0ConnectionProvider : autocommit mode: false
            Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@10c6cfc [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@155d3a3 [ 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@1217e67 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:oracle:thin:@localhost:1521:es41, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> 10c6cfc ]
            09:54:00,553 DEBUG JbpmSchema : create table JBPM_ACTION (ID_ number(19,0) not null, class char(1 char) not null, NAME_ varchar2(255 char), ISPROPAGATIONALLOWED_ number(1,0), REFERENCEDACTION_ number(19,0), ACTIONDELEGATION_ number(19,0), EVENT_ number(19,0), PROCESSDEFINITION_ number(19,0), EXPRESSION_ varchar2(4000 char), TIMERNAME_ varchar2(255 char), DUEDATE_ varchar2(255 char), REPEAT_ varchar2(255 char), TRANSITIONNAME_ varchar2(255 char), TIMERACTION_ number(19,0), EVENTINDEX_ number(10,0), EXCEPTIONHANDLER_ number(19,0), EXCEPTIONHANDLERINDEX_ number(10,0), primary key (ID_))
            java.sql.SQLException: ORA-00907: Parenthèse de droite absente

            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
            at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
            at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
            at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
            at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
            at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1602)
            at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1527)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2045)
            at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:752)
            at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:63)
            at org.jbpm.db.JbpmSchema.execute(JbpmSchema.java:230)
            at org.jbpm.db.JbpmSchema.createSchema(JbpmSchema.java:149)
            at org.jbpm.tutorial.db.HelloWorldDbTest.(HelloWorldDbTest.java:27)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
            at java.lang.reflect.Constructor.newInstance(Unknown Source)
            at junit.framework.TestSuite.createTest(TestSuite.java:131)
            at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)
            at junit.framework.TestSuite.(TestSuite.java:75)
            at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.getTest(RemoteTestRunner.java:360)
            at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:398)
            at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
            at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)
            java.lang.ExceptionInInitializerError
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
            at java.lang.reflect.Constructor.newInstance(Unknown Source)
            at junit.framework.TestSuite.createTest(TestSuite.java:131)
            at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)
            at junit.framework.TestSuite.(TestSuite.java:75)
            at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.getTest(RemoteTestRunner.java:360)
            at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:398)
            at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
            at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)
            Caused by: java.lang.RuntimeException: couldn't execute sql 'create table JBPM_ACTION (ID_ number(19,0) not null, class char(1 char) not null, NAME_ varchar2(255 char), ISPROPAGATIONALLOWED_ number(1,0), REFERENCEDACTION_ number(19,0), ACTIONDELEGATION_ number(19,0), EVENT_ number(19,0), PROCESSDEFINITION_ number(19,0), EXPRESSION_ varchar2(4000 char), TIMERNAME_ varchar2(255 char), DUEDATE_ varchar2(255 char), REPEAT_ varchar2(255 char), TRANSITIONNAME_ varchar2(255 char), TIMERACTION_ number(19,0), EVENTINDEX_ number(10,0), EXCEPTIONHANDLER_ number(19,0), EXCEPTIONHANDLERINDEX_ number(10,0), primary key (ID_))'
            at org.jbpm.db.JbpmSchema.execute(JbpmSchema.java:235)
            at org.jbpm.db.JbpmSchema.createSchema(JbpmSchema.java:149)
            at org.jbpm.tutorial.db.HelloWorldDbTest.(HelloWorldDbTest.java:27)
            ... 11 more
            Caused by: java.sql.SQLException: ORA-00907: Parenthèse de droite absente

            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
            at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
            at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
            at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
            at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
            at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1602)
            at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1527)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2045)
            at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:752)
            at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:63)
            at org.jbpm.db.JbpmSchema.execute(JbpmSchema.java:230)
            ... 13 more

            it seam that the sql generated was wrong. i have copied the JDBC driver jar file (classes12) into the folder for the currently used jars

            • 3. Re: jbpm database name
              Koen Aers Master

              Did you use the correct Hibernate dialect?

              Regards,
              Koen