Author: alex.guizar(a)jboss.com Date: 2009-07-27 21:00:04 -0400 (Mon, 27 Jul 2009) New Revision: 5354 Modified: jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-db2-ds.xml jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-hsqldb-ds.xml jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-mysql-ds.xml jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-oracle-ds.xml jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-sybase-ds.xml Log: switch to DB2 type 4 driver Modified: jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-db2-ds.xml =================================================================== --- jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-db2-ds.xml 2009-07-28 00:26:08 UTC (rev 5353) +++ jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-db2-ds.xml 2009-07-28 01:00:04 UTC (rev 5354) @@ -8,10 +8,14 @@ <xa-datasource-property name="ServerName">${jdbc.db2.server}</xa-datasource-property> <xa-datasource-property name="PortNumber">${jdbc.db2.port}</xa-datasource-property> <xa-datasource-property name="DatabaseName">${jdbc.db2.database}</xa-datasource-property> + <!-- DriverType can be 2 or 4; type 4 does not require a DB2 client --> + <xa-datasource-property name="DriverType">4</xa-datasource-property> <user-name>${jdbc.db2.username}</user-name> <password>${jdbc.db2.password}</password> - <!-- Must be set if using multiple DB2 XA resources in same transaction --> + <!-- disable transaction interleaving --> + <track-connection-by-tx /> + <!-- force XAResource.isSameRM(XAResource) to return false --> <isSameRM-override-value>false</isSameRM-override-value> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml --> Modified: jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-hsqldb-ds.xml =================================================================== --- jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-hsqldb-ds.xml 2009-07-28 00:26:08 UTC (rev 5353) +++ jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-hsqldb-ds.xml 2009-07-28 01:00:04 UTC (rev 5354) @@ -15,8 +15,6 @@ <!-- disable idle connection removal, hsqldb does not reap threads on closed connections --> <idle-timeout-minutes>0</idle-timeout-minutes> - <!-- check all statements are closed when the connection is returned to the pool --> - <track-statements /> <!-- hsqldb benefits from prepared statement caching --> <prepared-statement-cache-size>32</prepared-statement-cache-size> Modified: jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-mysql-ds.xml =================================================================== --- jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-mysql-ds.xml 2009-07-28 00:26:08 UTC (rev 5353) +++ jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-mysql-ds.xml 2009-07-28 01:00:04 UTC (rev 5354) @@ -13,8 +13,6 @@ <!-- reduce isolation from the default level (repeatable read) --> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> - <!-- separate connections used inside and outside a JTA transaction --> - <no-tx-separate-pools /> <!-- disable transaction interleaving --> <track-connection-by-tx /> Modified: jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-oracle-ds.xml =================================================================== --- jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-oracle-ds.xml 2009-07-28 00:26:08 UTC (rev 5353) +++ jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-oracle-ds.xml 2009-07-28 01:00:04 UTC (rev 5354) @@ -9,11 +9,11 @@ <user-name>${jdbc.oracle.username}</user-name> <password>${jdbc.oracle.password}</password> - <!-- separate connections used inside and outside a JTA transaction --> + <!-- isolate connections used with JTA from those used without JTA --> <no-tx-separate-pools /> <!-- disable transaction interleaving --> <track-connection-by-tx /> - + <!-- force XAResource.isSameRM(XAResource) to return false --> <isSameRM-override-value>false</isSameRM-override-value> <!-- check oracle error codes and messages for fatal errors --> Modified: jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-sybase-ds.xml =================================================================== --- jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-sybase-ds.xml 2009-07-28 00:26:08 UTC (rev 5353) +++ jbpm3/branches/jbpm-3.2-soa/modules/core/src/main/resources/jbpm-sybase-ds.xml 2009-07-28 01:00:04 UTC (rev 5354) @@ -11,11 +11,12 @@ <user-name>${jdbc.sybase.username}</user-name> <password>${jdbc.sybase.password}</password> - <!-- separate connections used inside and outside a JTA transaction --> + <!-- isolate connections used with JTA from those used without JTA --> <no-tx-separate-pools /> <!-- disable transaction interleaving --> <track-connection-by-tx /> + <!-- check sybase error codes and messages for fatal errors --> <exception-sorter-class-name> org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter </exception-sorter-class-name>