JBoss Community

• If you're using the JBoss AS 5 server

• If you're using the JBoss AS 7 server

<datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" jta="true" use-java-context="true" use-ccm="true">

                    <connection-url>jdbc:oracle:thin:@localhost:1521:test</connection-url>

                    <driver>oracle</driver>

                    <pool>

                        <min-pool-size>1</min-pool-size>

                        <max-pool-size>4</max-pool-size>

                        <prefill>false</prefill>

                        <use-strict-min>false</use-strict-min>

                        <flush-strategy>FailingConnectionOnly</flush-strategy>

                    </pool>

                    <security>

                       <user-name>scott</user-name>

                       <password>scott</password>

                    </security>

                    <validation>

                       <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

                       <validate-on-match>false</validate-on-match>

                       <background-validation>false</background-validation>

                    </validation>

                </datasource>

                <drivers>

                    <driver name="oracle" module="com.oracle">

                        <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

                    </driver>

                </drivers>

            </datasources>