need help with configuration for setting up oracle connection pool

[msteff]

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 ?

[wdfink]

Hello Morten,

welcome to the forum.

To define connection pools you need to add the driver and the datasource definition to the standalone.xml or domain.xml (depend on the mode you use).

See the description here.

Feel free to ask if you have still questions.