Re: tomcat oracle jdbc pooling

Bj Mon, 11 Oct 2004 23:59:52 -0700

No, I don't want to. I want to use an OracleDatasource object but to manipulate an simple Datasource in my code. So my OracleDatasource has to be pre-configured at the loading.

I thought Tomcat was giving a Map of parameters to the datasource and the datasource search in the Map for corresponding parameters. Obviously, it's not the case except for standard parameters like user,password, url,...

Thanks anyway

Bj

David Short a �crit :

Are you reading and setting the parameter values in your code before you
create the connection pool?

e.g. int MaxStatements =
Integer.parseInt(application.getInitParameter("maxStatements"));

-----Original Message-----
From: Bj [mailto:[EMAIL PROTECTED]
Sent: Monday, October 11, 2004 9:30 AM
To: Tomcat Users List
Subject: Re: tomcat oracle jdbc pooling

hi,

I'm using simple OracleDatasource and I want to activate
OracleDataSource.setMaxStatements() and
OracleDataSource.setImplicitCachingEnabled() through tomcat server.xml
or application web.xml.

For tomcat 5.0.19, when I add parameters in web.xml or server.xml it
doesn't work.

I've tried in web/xml :
<context-param>
     <param-name>implicitCachingEnabled</param-name>
     <param-value>true</param-value>
</context-param>
<context-param>
     <param-name>maxStatements</param-name>
     <param-value>8</param-value>
</context-param>

In server.xml I've tried :
<parameter>
        <name>implicitCachingEnabled</name>
        <value>true</value>
</parameter>
...

I'm not sure that it's possible to do this but it could be great.

Bj

David Short a �crit :

Take a look here to get the skinny on what's available


(http://www.exciton.cs.rice.edu/JavaResources/Oracle/oracle/jdbc/pool/Oracle

ConnectionCacheImpl.html). Also, I set the "Setters" in my web.xml file.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: tomcat oracle jdbc pooling

Reply via email to