1 Reply Latest reply on Apr 12, 2013 2:09 AM by Wolf-Dieter Fink

    need help with configuration for setting up oracle connection pool

    Morten Steffensen Newbie



      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>





      Any tips ?