Author: heiko.braun(a)jboss.com Date: 2009-11-24 11:20:55 -0500 (Tue, 24 Nov 2009) New Revision: 319 Modified: trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml Log: Best H2 settings I could figure out Modified: trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml =================================================================== --- trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml 2009-11-24 15:35:01 UTC (rev 318) +++ trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml 2009-11-24 16:20:55 UTC (rev 319) @@ -2,23 +2,24 @@ <datasources> - <local-tx-datasource> - <jndi-name>BPELDB</jndi-name> - <connection-url&gt;@connection.url(a)&lt;/connection-url&gt; - <driver-class>@driver@</driver-class> - <user-name>@username@</user-name> - <password>@password@</password> - <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> - <min-pool-size>5</min-pool-size> - <max-pool-size>20</max-pool-size> - <idle-timeout-minutes>0</idle-timeout-minutes> - <prepared-statement-cache-size>32</prepared-statement-cache-size> - <depends>jboss:service=h2,database=BPELDB</depends> - </local-tx-datasource> - <mbean code="org.jboss.soa.bpel.runtime.db.H2Database" - name="jboss:service=h2,database=BPELDB"> - <attribute name="Database">BPELDB</attribute> - <attribute name="DataDir">${jboss.server.data.dir}</attribute> - </mbean> + <local-tx-datasource> + <jndi-name>BPELDB</jndi-name> + <connection-url&gt;@connection.url(a)&lt;/connection-url&gt; + <driver-class>@driver@</driver-class> + <user-name>@username@</user-name> + <password>@password@</password> + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + <min-pool-size>5</min-pool-size> + <max-pool-size>20</max-pool-size> + <idle-timeout-minutes>0</idle-timeout-minutes> + <prepared-statement-cache-size>32</prepared-statement-cache-size> + <depends>jboss:service=h2,database=BPELDB</depends> + </local-tx-datasource> + <mbean code="org.jboss.soa.bpel.runtime.db.H2Database" + 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</attribute> + </mbean> </datasources>