yes, i get this error
09:53:59,521 INFO C3P0ConnectionProvider : autocommit mode: false
Initializing c3p0 pool... [EMAIL PROTECTED] [ connectionPoolDataSource ->
[EMAIL PROTECTED] [ 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 -> [EMAIL PROTECTED] [ 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
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3926465#3926465
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3926465
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
