Tomcat-7 and Oracle Universal Connection Pool (UCP)

[Martin Knoblauch <kn...@knobisoft.de>]

Hi,

 short question. I am in the process of moving an application from using
the Oracle JDBC pool to using UCP. I have some problems understanding the
relations between the resource definition in the context and what to put
into web.xml.

So, the context includes:

  <Resource name="jdbc/myDataSource"
        auth="Container"
        factory="oracle.ucp.jdbc.PoolDataSourceImpl"
        type="oracle.ucp.jdbc.PoolDataSource"
        description="Oracle datasource using UCP"
        connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource"

        initialPoolSize="25"
        minPoolSize="15"
        maxPoolSize="210"
        maxStatements="100"
        connectionWaitInterval="200"
        timeoutCheckInterval="600"
        inactiveConnectionTimeout="100"
        abandonConnectionTimeout="600"
        validateConnectionOnBorrow="true"
        sqlForValidateConnection="select 1 from DUAL"
        connectionPoolName="MyUCPPool"
        connectionProperties="(defaultRowPrefetch=200)"

        url="jdbc:oracle:thin:@connect_info"
        user="user"
        password="passwd"
   />

What is not clear to my, what I have to put into the resource-ref in
web.xml. For the old JDBC configuration we had:

        <resource-ref>
                <description>My Data Source</description>
                <res-ref-name>jdbc/myDataSource</res-ref-name>
                <res-type>oracle.jdbc.pool.OracleDataSource</res-type>
                <res-auth>Container</res-auth>
        </resource-ref>

The "res-type" matched the "type=" from the resource definition.
Unfortunately, I never found an explanation/documentation of what the
"res-type" actually relates to. So now I see three possibilities:

1) match "type=" from the resource

     <res-type>oracle.ucp.jdbc.PoolDataSource</res-type>

2) match "connectionFactoryClassName=" from the resource

    <res-type>oracle.jdbc.pool.OracleDataSource</res-type>

3) just put in "javax.sql.DataSource" as someone suggested to me off-line

     <res-type>javax.sql.DataSource</res-type>


Now I know that I could just experiment with that. But time is scarce and
maybe someone knows the correct (or at least working :-) solution.

Thanks in advance
Martin
-- 
------------------------------------------------------
Martin Knoblauch
email: k n o b i AT knobisoft DOT de
www: http://www.knobisoft.de