Can I configure the MAX_LIMIT, MIN_LIMIT or maxActive, maxIdle property for Oracle datasource? I look at the oracle817 JDBC API docs, there is only one class "OracleOCIConnectionPool" with some properties like these but not sure I can set them within the data-sources element of my Struts-config.xml?
David --- "Raible, Matt" <[EMAIL PROTECTED]> wrote: > I'm assuming this will work for configuring a > context in Tomcat as well? > > http://www.mail-archive.com/struts-user@jakarta.apache.org/msg51842.html > > Thanks, > > Matt > > > > -----Original Message----- > > From: Bradley G Smith [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 21, 2003 9:29 AM > > To: Struts Users Mailing List > > Cc: david chan; Struts Users Mailing List > > Subject: Re: db connection pool question > > > > > > > > "select 1 from dual" is the standard way to "ping" > oracle for a valid > > connection. I would also recommend using Oracle's > connection > > pool. It will > > do this in the background. We have several tomcat > and struts > > applications > > running for weeks without problems. Even with > Oracle going > > off line for > > maintenance. > > > > I can supply and example struts configuration > using Oracle's driver > > connection pool driver. Or check the archives for > this > > mailing list, as I > > have posted it here. Search using my name or > Oracle. > > > > Brad > > > > > > > > > > > > > > Rick Reumann > > > > > > <maillist@reuman To: > > > "Struts Users Mailing List" > <[EMAIL PROTECTED]> > > n.net> cc: > david > > chan <[EMAIL PROTECTED]> > > > > Subject: Re: > > db connection pool question > > > 21-01-03 07:19 > > > > > > Please respond > > > > > > to "Struts Users > > > > > > Mailing List" > > > > > > > > > > > > > > > > > > > > > > > > > > On Tuesday, January 21, 2003, 9:56:09 AM, david > wrote: > > > > dc> Hi, I am using a connection pool from > > dc> org.apache.commons.dbcp.BasicDataSourceFactory > and the driver is > > dc> oracle.jdbc.driver.OracleDriver. It works > great until if the > > dc> server idle for a few days, then the > connection object seems > > dc> broken with this error: ==== begin error mesg > === > > dc> java.sql.SQLException: Io exception: Software > caused connection > > dc> abort: socket wr ite error at > > > > I believe I had similar problems here as well but > it usually only > > happened when the DBA would for some reason decide > to kill connections > > that were open. I went with configuring the > pooling with whatever > > comes packaged with Tomcat and configuring it in > the server.xml > > making sure to add the extra overhead of > performing a validation query > > > > <parameter> > > <name>validationQuery</name> > > <value>SELECT 'CRAP' FROM DUAL</value> > > </parameter> > > > > Not sure what app server you are running but maybe > somewhere you can > > set up a similar parameter to make sure it is > handing out a valid > > connection from the pool. I'm pretty clueless when > it comes to this > > stuff and just followed some examples I saw. Until > I added the above > > validationQuery I believe I got similar errors to > what you > > experienced. > > > > -- > > > > Rick > > mailto:[EMAIL PROTECTED] > > > > > > -- > > To unsubscribe, e-mail: < > > mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: < > > mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
