Need help with jbpm java app using sybase

[michaelholtzman]

Greetings. I am trying to set up a sybase database for jbpm. However, the generated sql scripts do not work. (Syntax errors). Any suggestions? This is jbpm 3.0.1 and sybase 12.5

Thanx

[kukeltje]

there is an issue with generated scripts. Can you check out the latest cvs of the 3.0 branche (which will become 3.02 in a week or so) and see if the script that is generated then works?

[klsateesh]

Hi,

Is it the case with Oracle Scripts as well..

When i generated the scripts the columns are having type bigint, bit etc which doesn't exists in Oracle. I changed them to NUMBER(19) and CHAR(1) and the Column Names have trailing _ Char which Oracle complains...

Thanks
Sateesh

[kukeltje]

Could be, I tought I gave a similar reply in on one of your earlier questions

[michaelholtzman]

"kukeltje" wrote:
there is an issue with generated scripts. Can you check out the latest cvs of the 3.0 branche (which will become 3.02 in a week or so) and see if the script that is generated then works?

I retrieved jbpm-db 3.0.2 and regenerated the sql scripts. They are close, but not quite correct. To make them work, you must:
-- delete the trailing semicolon from each line
-- add a "GO" command at the end of the file (may not be necessary)

Now that these scripts are working, I tried to run sybase.test, and got a number of errors (28) and failures (5). The errors are all the same:

couldn't commit transaction

java.lang.RuntimeException: couldn't commit transaction at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:107) at org.jbpm.db.AbstractDbTestCase.commitAndCloseSession(AbstractDbTestCase.java:90) at org.jbpm.db.AbstractDbTestCase.tearDown(AbstractDbTestCase.java:76)Caused by: java.lang.NullPointerException at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:102) ... 12 more

Any suggestions?