Martin I experienced the same issue with MySQL and Resin. Nobody seemed to be familiar with the problem and I couldn't track down the bug: http://www.mail-archive.com/[email protected]/msg01027. html
I eventually had to force Torque to use Resin's connection pooling. Tony > -----Original Message----- > From: Phee, Martin J (Jump Tech) [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 09, 2003 10:07 AM > To: Turbine Users List > Subject: Getting bad connections from Torque > > > I'm having a problem with torque and oracle. Maybe it's my > misunderstanding. Every once in a while I'm getting the > following error in > my turbine.log: > > [Tue Jan 07 08:52:13 CST 2003] -- ERROR -- Turbine.handleException: > ORA-02068: following severe error from xxxxxxx > ORA-03113: end-of-file on communication channel > > When torque returns a db connection isn't it supposed to check to see if > it's still a good connection? Below is my torque setup. Only seems to > happen after a weekend when no one has been using it for a while. What's > the purpose of the validationQuery? I'm currently using 3.0-rc1. > I'm about > to upgrade to the release version once I'm done with regression testing. > > torque.dsfactory.smrt_prod.factory=org.apache.torque.dsfactory.Jdb > c2PoolData > SourceFactory > torque.dsfactory.smrt_prod.pool.defaultMaxActive=10 > torque.dsfactory.smrt_prod.pool.testOnBorrow=true > torque.dsfactory.smrt_prod.pool.validationQuery=SELECT 1 from dual > torque.dsfactory.smrt_prod.connection.driver = > oracle.jdbc.driver.OracleDriver > torque.dsfactory.smrt_prod.connection.url = > jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=xxxxxx)(PROTOCOL=tcp > )(PORT=152 > 1))(CONNECT_DATA=(SID=xxxxx))) > torque.dsfactory.smrt_prod.connection.user = > torque.dsfactory.smrt_prod.connection.password = > > -- > 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]>
