4 Replies Latest reply on Dec 12, 2005 3:03 PM by Alejandro Guizar

    BEPL : jBpm persistance error while deploying HelloWorldBepl

    rserg rfesgrfgeqs Newbie

      Hi,


      I downloaded jBpm 3.0.2 starters kit, created the mySql database
      with the scripts included (even re-builded them), but while deploying
      my par archive (the HelloWolrdBepl par) I have the following error :


      [deploypar] 11:46:35,842 DEBUG ProcessArchiveDeployer : starting transaction to deploy process BpelDefinition(a07440)
      [deploypar] Hibernate: insert into JBPM_PROCESSDEFINITION (NAME_, VERSION_, ISTERMINATIONIMPLICIT_, STARTSTATE_, TARGETNAMESPACE_, ENABLECOMPENSATION_, EXPRESSIONLANG_, QUERYLANG_, ABSTRACT_, CLASS_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, 'B')
      [deploypar] 11:46:36,283 WARN JDBCExceptionReporter : SQL Error: 1054, SQLState: 42S22
      [deploypar] 11:46:36,283 ERROR JDBCExceptionReporter : Unknown column 'TARGETNAMESPACE_' in 'field list'
      [deploypar] 11:46:36,293 ERROR GraphSession : org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.bpel.def.BpelDefinition]


      I had a quick look at the db script and here's what I got :

      create table JBPM_PROCESSDEFINITION (ID_ number(19,0) not null, NAME_ varchar2(255 char), VERSION_ number(10,0), ISTERMINATIONIMPLICIT_ number(1,0), STARTSTATE_ number(19,0), primary key (ID_));

      Am I using a wrong version of the script or any other package ?

      Thanks in advance,

        • 1. Re: BEPL : jBpm persistance error while deploying HelloWorld
          Elmo Novice

          I have successfully run MySQL. you need to change hibernate.cfg.xml properties to the following:

          hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect hibernate.connection.driver_class=com.mysql.jdbc.Driver
          hibernate.connection.url=jdbc:mysql://:3306/
          hibernate.connection.username=<your user name>
          hibernate.connection.password=

          assuming your tables are InnoDB type. Your MySQL driver must also be referenced. I think im using the mysql connector downloaded in the mysql site. You also need to create the blank database beforehand which was my case. I ran the jbpm 3.01 version but I think this should do bec. this is a hibernate issue. You can check also under the jbpm-db folder of the starter's kit for the specific db configuration.

          Regards,

          Elmo

          • 2. Re: BEPL : jBpm persistance error while deploying HelloWorld
            Elmo Novice

            Sorry the connection url should be jdbc:mysql://localhost:3306/databasename where localhost can be changed with your host so is the databsename.

            Regards,

            Elmo

            • 3. Re: BEPL : jBpm persistance error while deploying HelloWorld
              rserg rfesgrfgeqs Newbie


              Hi and thanks for answering :)


              I did create the database and run the scripts. I changed
              the hibernate .properties file (i had same as yours except for
              the port in the url) but I still have the same problem as hibernate
              seems to want to save an unknown Column.

              Could you deploy the HelloWorldBepl tutorial ?

              Would you mind to check your JBPM_PROCESSDEFINITION table
              description and see if the followings columns are defined ?
              NAME_, VERSION_, ISTERMINATIONIMPLICIT_, STARTSTATE_, TARGETNAMESPACE_, ENABLECOMPENSATION_, EXPRESSIONLANG_, QUERYLANG_, ABSTRACT_, CLASS_

              If so, would you please send me your .sql files for creating the database ?

              thanks

              • 4. Re: BEPL : jBpm persistance error while deploying HelloWorld
                Alejandro Guizar Master

                The starters kit doesn't include BPEL support due to licensing issues. Also, the BPEL extension requires additional columns in existing jBPM tables and some tables of its own. We made sure jBPM and BPEL processes can coexist in the same database, tough.

                To build the proper scripts, use the Hibernate configuration file from the jBPM BPEL distribution rather than the starters kit. It is located in directory src/resources.