Author: jeff.yuchang Date: 2010-01-15 05:08:03 -0500 (Fri, 15 Jan 2010) New Revision: 461 Modified: trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql Log: * RIFTSAW-152 update blob to varbinary for hsqldb * set LOG=1 in the hsql-ds Modified: trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml =================================================================== --- trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml 2010-01-14 05:29:40 UTC (rev 460) +++ trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml 2010-01-15 10:08:03 UTC (rev 461) @@ -19,7 +19,7 @@ name="jboss:service=h2,database=BPELDB"> <attribute name="Database">BPELDB</attribute> <attribute name="DataDir">${jboss.server.data.dir}</attribute> - <attribute name="Flags">;MVCC=true;LOCK_MODE=3;LOG=2;DB_CLOSE_ON_EXIT=FALSE</attribute> + <attribute name="Flags">;MVCC=true;LOCK_MODE=3;LOG=1;DB_CLOSE_ON_EXIT=FALSE</attribute> </mbean> </datasources> Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-01-14 05:29:40 UTC (rev 460) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-01-15 10:08:03 UTC (rev 461) @@ -12,7 +12,7 @@ nodeid char(64), scheduled int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, - details blob(4096), + details varbinary, PRIMARY KEY(jobid)); CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts);