-
1. Re: integrating JBPM with DB2.
joshuayip Nov 24, 2005 10:49 PM (in response to anil.saraswat)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 Nov 25, 2005 3:18 AM (in response to anil.saraswat)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