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.
<resource-ref> is set in either your server.xml or your /tomcat/conf/catalina/localhost/webapp.xml file, depending on the version of Tomcat you're using. web.xml <?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com//dtd/web-app_2_3.dtd";> <web-app> <!-- Context parameters for the application --> <!-- thin driver = <param-value>jdbc:oracle:thin:@ServerNameHere:1521:SIDNameHere</param-value> OCI driver = <param-value>jdbc:oracle:oci8:@SIDNameHere</param-value> --> <context-param> <param-name>jdbcURL</param-name> <param-value>jdbc:oracle:oci8:@SIDNameHere</param-value> </context-param> <!-- ****************************************** Application Account Information Here. ****************************************** --> <!-- Username --> <context-param> <param-name>user</param-name> <param-value>UserNameHere</param-value> </context-param> <!-- Password --> <context-param> <param-name>password</param-name> <param-value>PasswordHere</param-value> </context-param> <!-- Minimum number of database connections to pool --> <context-param> <param-name>minLimit</param-name> <param-value>2</param-value> </context-param> <!-- Maximum number of database connections to pool --> <context-param> <param-name>maxLimit</param-name> <param-value>50</param-value> </context-param> <resource-ref> <res-ref-name>jdbc/WEBAPPNameHere</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </web-app> -----Original Message----- From: Bj [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 6:49 AM To: Tomcat Users List Subject: Re: tomcat oracle jdbc pooling I've tried but I didn't manage to set these parameters in the server.xml tomcat file. I can do this in the java code but it increases oracle dependancy and I would like to avoid that. Bj David Smith a �crit : > I'll go on a limb here. I just started actually reading the fantastic > docs on JDBC. Been using databases essentially by example for a couple > years now. It looks like you're replacing the DBCP datasource with the > Oracle pooling datasource. In that case you should take a look at the > setters for the OracleDataSourceFactory to see what parameters are > available. > > --David > > Bj wrote: > >> Hi, >> >> I'm using tomcat jdbc connection pooling through dbcp >> datasourceFactory and it works well. >> Now, I want to use oracle.jdbc.pool.OracleDataSourceFactory to >> instanciate oracle.jdbc.pool.OracleDataSource. >> >> It seems to work, but I'm wondering is there's some specific >> parameters to add ? >> I also want to manage MaxStatements and ExplicitCachingEnabled >> parameters in the Tomcat server XML but it doesn't work with these >> parameter names. Does someone know how to do this ? >> >> I would like my java code to only use standard jdbc classes and to >> have the benefit of Oracle jdbc statement pooling. Is there a way to >> do this ? >> >> best regards, >> >> Bj >> >> --------------------------------------------------------------------- >> 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
