4 Replies Latest reply on Nov 10, 2005 10:26 AM by Michael Holtzman

    Need help with jbpm java app using sybase

    Michael Holtzman Newbie

      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

        • 1. Re: Need help with jbpm java app using sybase
          Ronald van Kuijk Master

          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?

          • 2. Re: Need help with jbpm java app using sybase
            sateesh kumar Newbie

            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

            • 3. Re: Need help with jbpm java app using sybase
              Ronald van Kuijk Master

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

              • 4. Re: Need help with jbpm java app using sybase
                Michael Holtzman Newbie

                 

                "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?