If "select 1 from dual" is the standard way to "ping" oracle
Is there a standard for MySQL ??? I have seen "SELECT 1 + 1" used ? Mike ---------------------------------------- ----- Original Message ----- From: "Bradley G Smith" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Cc: "david chan" <[EMAIL PROTECTED]>; "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 9:29 AM 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]>
