<datasources>
<local-tx-datasource>
<!-- remove this depends tag if you are not using the tcp connection url -->
<!-- <depends>jboss:service=ORACLEDB</depends> -->
<jndi-name>ORACLEDS</jndi-name>
<!-- for tcp connection, allowing other processes to use the hsqldb database -->
<connection-url>jdbc:oracle:thin:@192.168.0.107:1521:test</connection-url>
<!-- for totally in-memory db, not saved when jboss stops. hsql mbean is unnecessary-->
<!--connection-url>jdbc:hsqldb:.</connection-url-->
<!-- for in-process db, saved when jboss stops. hsql mbean is unnecessary-->
<!--connection-url>jdbc:hsqldb:default-db-name</connection-url-->
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>ram</user-name>
<password>ram1</password>
<!--example of how to specify class that determines if exception means connection should be destroyed-->
<!--exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorter</exception-sorter-class-name-->
<min-pool-size>50</min-pool-size>
<!-- <security-domain>ORACLEDbRealm</security-domain> -->
</local-tx-datasource>
<!-- this mbean should be used only when using tcp connections -->
<!-- <mbean code="org.jboss.jdbc.HypersonicDatabase"
name="jboss:service=ORACLEDB">
<attribute name="Port">1701</attribute>
<attribute name="Silent">true</attribute>
<attribute name="Database">default</attribute>
<attribute name="Trace">false</attribute>
<attribute name="No_system_exit">true</attribute>
</mbean> -->
</datasources>