Using the following in my DBCP Connection Pool solved my problem:
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.pool.OracleConnectionPoolDataSource</value>
</parameter>
However, for the JDBCRealm, I still have to use:
driverName="oracle.jdbc.driver.OracleDriver"
Thanks,
Matt
> -----Original Message-----
> From: mech [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 22, 2003 12:10 PM
> To: 'Struts Users Mailing List'
> Subject: RE: db connection pool question
>
>
> I can't tell for Oracle, but for MySQL and the Struts Connection Pool
> you have to set some kind of "autoReconnect=true" for your connection
> url setup. Otherwise your connection pool will contain only stale
> connections after a certain timeout.
> MySQL kicked me out after 8 hours of inactivity.
> Without autoreconnect you will just pick a "dead" connection
> out of this
> pool, get an exception, most likely even close the broken
> connection in
> your finally-block and put it back into the pool. Next time you grab
> another dead connection and so on and forth.
>
> By the way... Are the certain pro and cons for the struts connection
> pool vs. the tomcat datasource connection pool?
> As far as I know the tomcat connection pool works only via jndi setup
> whereas struts utilized the "oldfashioned" way. And moreover
> you have to
> set it up in struts-config.xml which is a bit tricky for deployment.
>
> Michael
>
> > -----Original Message-----
> > From: Raible, Matt [mailto:[EMAIL PROTECTED]]
> > Sent: Mittwoch, 22. Januar 2003 17:18
> > To: 'Struts Users Mailing List'
> > Subject: RE: db connection pool question
> >
> >
> > After waiting 24 hours, I'm still experiencing the same
> > problem with Oracle and a connection pool (DBCP) in Tomcat.
> > I guess I'll try configuring Oracle's connection pool??
> >
> > Matt
> >
> > > -----Original Message-----
> > > From: Raible, Matt
> > > Sent: Tuesday, January 21, 2003 8:22 AM
> > > To: 'Struts Users Mailing List'
> > > Subject: RE: db connection pool question
> > >
> > >
> > > Actually, the solution that I had only works for MySQL. I'm
> > > having the same problem with Oracle. Funny - I just posted a
> > > message to the commons-user group asking this same question.
> > > I'll try adding the validationQuery parameter:
> > >
> > > <parameter>
> > > <name>validationQuery</name>
> > > <value>SELECT 'CRAP' FROM DUAL</value> </parameter>
> > >
> > > Thanks,
> > >
> > > Matt
> > >
> > > > -----Original Message-----
> > > > From: Pani, Gourav [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, January 21, 2003 7:58 AM
> > > > To: 'Struts Users Mailing List'
> > > > Subject: RE: db connection pool question
> > > >
> > > >
> > > > please look at the thread with subject "Problem with JDBC
> > & Struts
> > > > Connection Pool (possible to recon nect?)". Matt Raible had a
> > > > solution to that by setting autoReconnect=true
> > > >
> > > > -----Original Message-----
> > > > From: david chan [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, January 21, 2003 9:56 AM
> > > > To: Struts Users Mailing List
> > > > Subject: db connection pool question
> > > >
> > > >
> > > > Hi,
> > > > I am using a connection pool from
> > > > org.apache.commons.dbcp.BasicDataSourceFactory and the
> driver is
> > > > oracle.jdbc.driver.OracleDriver. It works great until if
> > the server
> > > > idle for a few days, then the connection object seems
> broken with
> > > > this error: ==== begin error mesg ===
> > > > java.sql.SQLException: Io exception: Software caused
> > > > connection abort: socket wr
> > > > ite error at
> > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> > > > at
> > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
> > > > at
> > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
> > > > at
> > > >
> > oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:417)
> > > > at
> > > >
> > oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)
> > > > at
> > > >
> > >
> >
> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedState
> > > > ment.java:182) at
> > > >
> > >
> >
> oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleCon
> > > > nection.java:602) at
> > > >
> > >
> >
> oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection
> > > > .java:538) at
> > > > org.apache.commons.dbcp.DelegatingConnection.prepareStatement(
> > > > DelegatingConn
> > > > ection.java:197)
> > > > ...
> > > > ===== end of error mesg ====
> > > >
> > > > What happen and how can I prevent this?
> > > > Thanks.
> > > > David
> > > >
> > > >
> > > >
> > > > __________________________________________________
> > > > 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]>
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > <mailto:[EMAIL PROTECTED]>
> > > For additional commands, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <mailto:struts-user-> [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]>
