2 Replies Latest reply on Nov 25, 2005 3:18 AM by joshuayip

    integrating JBPM with DB2.

    anil.saraswat

      Hi all,
      I am trying to integrate JBPm with db2 database.can u please suggest me db2 driver required to establise connection.

      I tryed jbpm.db packaged shiped by jboss for database testing.Scripts generated by that application have semicolon at the end of each query, which db2 doesn't accept.
      is there any way sort this out.
      thanks,
      Anil

        • 1. Re: integrating JBPM with DB2.
          joshuayip

          I am also having similar problem. DB2 failed to execute some of the sql statement generated by the jbpm package.

          here is one example :

          ------------------------------ Commands Entered ------------------------------
          create table JBPM_ACTION (ID_ bigint generated by default as identity, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_));
          ------------------------------------------------------------------------------
          create table JBPM_ACTION (ID_ bigint generated by default as identity, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
          DB21034E The command was processed as an SQL statement because it was not a
          valid Command Line Processor command. During SQL processing it returned:
          SQL0286N A default table space could not be found with a page size of at
          least "8192" that authorization ID "SYSTEM" is authorized to use.
          SQLSTATE=42727

          SQL0286N A default table space could not be found with a page size of at least "8192" that authorization ID "SYSTEM " is authorized to use.

          Explanation:

          The CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement did
          not specify a table space, and a table space of the right type
          (USER TEMPORARY for declared temporary table) with sufficient
          page size (at least ""), over which authorization ID
          "<user-name>" has USE privilege, could not be found.

          Sufficient page size for a table is determined by either the
          byte count of the row or the number of columns.

          User Response:

          Ensure the existence of a table space of the correct type
          (REGULAR or USER TEMPORARY) with a page size of at least
          "" and that authorization ID "<user-name>" has USE
          privilege on this table space.

          sqlcode : -286

          sqlstate : 42727


          ---------------

          So some of the tables in the script failed to create and some was successfully created.

          Anyone tried this before?

          I am using Db2 8.1.7.445 Enterprise Edition

          • 2. Re: integrating JBPM with DB2.
            joshuayip

            Hello, I solved this problem in my last post. Something to do with the page size.

            If you are putting in the scripts into db2 , remember to create a higher page size after you have created the database. So when the sql (to create tables) is executed, it will not complain that the pagesize is not big enough.

            Joshua