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

      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 ?