[jboss-user] [Datasource Configuration] - need help with configuration for setting up oracle connection pool

[Morten Steffensen]

Morten Steffensen [https://community.jboss.org/people/msteff] created the discussion

"need help with configuration for setting up oracle connection pool"

To view the discussion, visit: https://community.jboss.org/message/807851#807851

--------------------------------------------------------------
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 ?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/807851#807851]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130411/ac539fca/attachment.html