Hello,
I have unsuccessfully tried to figure out how to configure oracle connection pool on a jboss 7 AS so that I can use datasources/jndi
I need this for using xmltypes/clob..
If I use spring configuration it looks like this (working):
<bean id="herkDataSource" class="oracle.jdbc.pool.OracleDataSource" destroy-method="close">
<property name="URL" value="jdbc:oracle:thin:@myhost:1572:myservicename"/>
<property name="user" value="myuser"/>
<property name="password" value="mypassword"/>
<property name="connectionCacheProperties">
<props merge="default">
<prop key="MinLimit">3</prop>
<prop key="MaxLimit">20</prop>
</props>
</property>
</bean>
Any tips ?