You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Alexey Yastremskiy <le...@omldc-rnd.ru> on 2003/02/20 06:04:03 UTC

Oracle connection pooling + Tomcat 4.1.12

Hi.

I've got a problem: I tried to setup oracle connection pooling in my
tomcat configuration, but didn't succeed. I checked Tomcat docs and Oracle
docs to produce this, but nothing helped :(
Does anyone have in production such a configuration, using
Oracle-implemented connection pooling? Please, help me to do the
same...

Here is my configs....

[server.xml]
    ....
        <Resource auth="Container" name="jdbc/DB" scope="Shareable" type="javax.sql.ConnectionPoolDataSource"/>
        <ResourceParams name="jdbc/DB">
                <parameter>
                        <name>factory</name>
                        <value>oracle.jdbc.pool.OracleDataSourceFactory</value>
                </parameter>
                <parameter>
                        <name>dataSourceName</name>
                        <value>oracle.jdbc.pool.OracleConnectionPoolDataSource</value>
                </parameter>
                <parameter>
                        <name>url</name>
                        <value>jdbc:oracle:thin:@dbserver:1521:SID</value>
                </parameter>
                <parameter>
                        <name>description</name>
                        <value>my datasource</value>
                </parameter>
                <parameter>
                        <name>user</name>
                        <value>...</value>
                </parameter>
                <parameter>
                        <name>password</name>
                        <value>...</value>
                </parameter>
        </ResourceParams>
        ...
[end server.xml]

[web.xml]
         ...
        <resource-env-ref>
                <description>my db</description>
                <resource-env-ref-name>jdbc/DB</resource-env-ref-name>
                <resource-env-ref-type>javax.sql.ConnectionPoolDataSource</resource-env-ref-type>
        </resource-env-ref>
        ...
[end web.xml]


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


RE: Oracle connection pooling + Tomcat 4.1.12

Posted by Mike Jackson <mj...@cdi-hq.com>.
I had problems using oracle connection pooling when I was using
transactions.  So I scrapped that and went back to poolman.  There is/was
something funny in the way it was doing things, I'd commit the transaction,
but it'd still be dirty or something.  As I explicitly set the isolation
mode prior to starting work I'd be getting these "commit prior to changing
transaction mode" exceptions back from oracle (don't remember exactly the
wording or the ora error code, but you get the idea).  I tried putting a
rollback or commit into the connection setup logic, but then I had other
strange results.

Sorry, I can't answer your question about your config, it could be ok, it
might not be.

--mikej
-=-----
mike jackson
mjackson@cdi-hq.com

> -----Original Message-----
> From: Alexey Yastremskiy [mailto:lehd@omldc-rnd.ru]
> Sent: Wednesday, February 19, 2003 9:04 PM
> To: Tomcat Users List
> Subject: Oracle connection pooling + Tomcat 4.1.12
>
>
> Hi.
>
> I've got a problem: I tried to setup oracle connection pooling in my
> tomcat configuration, but didn't succeed. I checked Tomcat docs and Oracle
> docs to produce this, but nothing helped :(
> Does anyone have in production such a configuration, using
> Oracle-implemented connection pooling? Please, help me to do the
> same...
>
> Here is my configs....
>
> [server.xml]
>     ....
>         <Resource auth="Container" name="jdbc/DB"
> scope="Shareable" type="javax.sql.ConnectionPoolDataSource"/>
>         <ResourceParams name="jdbc/DB">
>                 <parameter>
>                         <name>factory</name>
>
> <value>oracle.jdbc.pool.OracleDataSourceFactory</value>
>                 </parameter>
>                 <parameter>
>                         <name>dataSourceName</name>
>
> <value>oracle.jdbc.pool.OracleConnectionPoolDataSource</value>
>                 </parameter>
>                 <parameter>
>                         <name>url</name>
>                         <value>jdbc:oracle:thin:@dbserver:1521:SID</value>
>                 </parameter>
>                 <parameter>
>                         <name>description</name>
>                         <value>my datasource</value>
>                 </parameter>
>                 <parameter>
>                         <name>user</name>
>                         <value>...</value>
>                 </parameter>
>                 <parameter>
>                         <name>password</name>
>                         <value>...</value>
>                 </parameter>
>         </ResourceParams>
>         ...
> [end server.xml]
>
> [web.xml]
>          ...
>         <resource-env-ref>
>                 <description>my db</description>
>                 <resource-env-ref-name>jdbc/DB</resource-env-ref-name>
>
> <resource-env-ref-type>javax.sql.ConnectionPoolDataSource</resourc
> e-env-ref-type>
>         </resource-env-ref>
>         ...
> [end web.xml]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org