Hi, Your DBAs should be able to help you here: they should definitely be able to kill connections. If it's a test database, they can simply bring it down for a few minutes, then back up, while you keep your Tomcat running.
Yoav Shapira http://www.yoavshapira.com >-----Original Message----- >From: Ruth, Brice [mailto:[EMAIL PROTECTED] >Sent: Monday, December 06, 2004 4:22 PM >To: Tomcat Users List >Subject: Re: DBCP/JNDI/Realms > >OK, so short of waiting for this to fail again, how might I go about >testing this works? Should I see if the database folks can kill the JDBC >connections manually? > >Shapira, Yoav wrote: > >>Hi, >>The DBCP parameters are for DBCP. DBCP won't magically set various >>properties on your IBM driver, so if you want those set you have to do >>it yourself. >> >>If you use IBM's pooling, as opposed to IBM's driver with DBCP's >>pooling, you can set those properties in your Tomcat xml configuration, >>as long as the factory provided by IBM supports that approach. >> >>Yoav Shapira http://www.yoavshapira.com >> >> >> >> >>>-----Original Message----- >>>From: Ruth, Brice [mailto:[EMAIL PROTECTED] >>>Sent: Monday, December 06, 2004 3:31 PM >>>To: Tomcat Users List >>>Subject: Re: DBCP/JNDI/Realms >>> >>>Follow-up question. Should I or should I not use the ConnectionPool >>>implementation provided by IBM in their JDBC driver? And if I should, >>> >>> >>do >> >> >>>the parameters provided by DBCP still apply? I have to admit, I'm a bit >>>fuzzy on what role which component is playing in this game! >>> >>>Thanks!! >>> >>>Shapira, Yoav wrote: >>> >>> >>> >>>>Hi, >>>>DBCP will NOT gracefully recover by itself. You need to configure it >>>>according to your desired behavior. Specifically, check out the >>>>testOnBorrow, testOnReturn, and testWhileIdle properties at >>>>http://jakarta.apache.org/commons/dbcp/configuration.html. >>>> >>>>Yoav Shapira http://www.yoavshapira.com >>>> >>>> >>>> >>>> >>>> >>>> >>>>>-----Original Message----- >>>>>From: Ruth, Brice [mailto:[EMAIL PROTECTED] >>>>>Sent: Monday, December 06, 2004 11:32 AM >>>>>To: Tomcat Users List >>>>>Subject: DBCP/JNDI/Realms >>>>> >>>>>Good morning! >>>>> >>>>>I've been running into an intermittent problem with my database >>>>>connections for authentication. It appears that periodically, the >>>>>iSeries (DB2/400) that I connect to terminates all incoming ODBC/JDBC >>>>>connections (one a week, apparently). What happens in my application >>>>> >>>>> >>is >> >> >>>>>that users can no longer login after the connections have been >>>>> >>>>> >>dropped. >> >> >>>>>The connection pool apparently doesn't try to re-initiate the >>>>>connections after they've been dropped. >>>>> >>>>>I see an exception in my logs regarding the connection being reset, >>>>> >>>>> >>>>> >>>>> >>>>then >>>> >>>> >>>> >>>> >>>>>I see an exception relating to the pool being exhausted. I'm not >>>>>entirely sure what the root cause of the problem here is - in theory, >>>>>DBCP should recover gracefully when a connection is reset/dropped, >>>>> >>>>> >>>>> >>>>> >>>>right? >>>> >>>> >>>> >>>> >>>>>Here's the initial exception: >>>>>java.sql.SQLException: Communication link failure.(Connection was >>>>>dropped unexpectedly.) >>>>> at >>>>> >>>>> >>>>> >>>>> >>>>com.ibm.as400.access.JDError.throwSQLException(JDError.java:365) >>>> >>>> >>>> >>>> >>>>> at >>>>>com.ibm.as400.access.AS400JDBCConnection.send(AS400JDBCConnection.j av >>>>> >>>>> >>a( >> >> >>>>> >>>>> >>>>Comp >>>> >>>> >>>> >>>> >>>>>iled >>>>>Code)) >>>>> at >>>>>com.ibm.as400.access.AS400JDBCConnection.send(AS400JDBCConnection.j av >>>>> >>>>> >>a( >> >> >>>>> >>>>> >>>>Inli >>>> >>>> >>>> >>>> >>>>>ned >>>>>Compiled Code)) >>>>> at >>>>>com.ibm.as400.access.AS400JDBCStatement.syncRPB(AS400JDBCStatement. ja >>>>> >>>>> >>va >> >> >>>>> >>>>> >>>>(Com >>>> >>>> >>>> >>>> >>>>>piled >>>>>Code)) >>>>> at >>>>>com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStat em >>>>> >>>>> >>en >> >> >>>>> >>>>> >>>>t.ja >>>> >>>> >>>> >>>> >>>>>va(Compiled >>>>>Code)) >>>>> at >>>>>com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPre pa >>>>> >>>>> >>re >> >> >>>>> >>>>> >>>>dSta >>>> >>>> >>>> >>>> >>>>>tement.java(Compiled >>>>>Code)) >>>>> at >>>>>com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBC Co >>>>> >>>>> >>nn >> >> >>>>> >>>>> >>>>ecti >>>> >>>> >>>> >>>> >>>>>on.java(Compiled >>>>>Code)) >>>>> at >>>>>com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBC Co >>>>> >>>>> >>nn >> >> >>>>> >>>>> >>>>ecti >>>> >>>> >>>> >>>> >>>>>on.java(Compiled >>>>>Code)) >>>>> at >>>>>org.apache.commons.dbcp.DelegatingConnection.prepareStatement(Deleg at >>>>> >>>>> >>in >> >> >>>>> >>>>> >>>>gCon >>>> >>>> >>>> >>>> >>>>>nection.java(Compiled >>>>>Code)) >>>>> at >>>>>org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrappe r. >>>>> >>>>> >>pr >> >> >>>>> >>>>> >>>>epar >>>> >>>> >>>> >>>> >>>>>eStatement(PoolingDataSource.java(Compiled >>>>>Code)) >>>>> at >>>>>org.apache.catalina.realm.DataSourceRealm.credentials(DataSourceRea lm >>>>> >>>>> >>.j >> >> >>>>> >>>>> >>>>ava: >>>> >>>> >>>> >>>> >>>>>460) >>>>>[snip] >>>>> >>>>>Here's the next one: >>>>>2004-12-06 04:39:21 DataSourceRealm[]: Exception performing >>>>> >>>>> >>>>> >>>>> >>>>authentication >>>> >>>> >>>> >>>> >>>>>org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, >>>>>pool exhausted >>>>> at >>>>>org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingData So >>>>> >>>>> >>ur >> >> >>>>> >>>>> >>>>ce.j >>>> >>>> >>>> >>>> >>>>>ava(Compiled >>>>>Code)) >>>>> at >>>>>org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSour ce >>>>> >>>>> >>.j >> >> >>>>> >>>>> >>>>ava( >>>> >>>> >>>> >>>> >>>>>Compiled >>>>>Code)) >>>>> at >>>>>org.apache.catalina.realm.DataSourceRealm.open(DataSourceRealm.java :4 >>>>> >>>>> >>38 >> >> >>>>> >>>>> >>>>) >>>> >>>> >>>> >>>> >>>>> at >>>>>org.apache.catalina.realm.DataSourceRealm.authenticate(DataSourceRe al >>>>> >>>>> >>m. >> >> >>>>> >>>>> >>>>java >>>> >>>> >>>> >>>> >>>>>:277) >>>>>[snip] >>>>> >>>>>So, what I've done now to see if it helps matters any, is specify the >>>>>AS400's own connection pool factory in my JNDI definition, like so: >>>>> >>>>> <parameter> >>>>> <name>factory></name> >>>>> >>>>><value>com.ibm.as400.access.AS400JDBCConnectionPoolDataSource</valu e> >>>>> </parameter> >>>>> >>>>>Both Tomcat's form authentication as well as my application (through >>>>>iBATiS) use this JNDI DataSource for connections. >>>>> >>>>>Can anyone shed more light on what the root cause of the problem is >>>>>here? Should DBCP gracefully recover? >>>>> >>>>>Regards, >>>>>Brice Ruth >>>>> >>>>>-- >>>>>Brice Ruth, Sr. IT Analyst >>>>>Fiskars Brands Inc >>>>>http://www.fiskarsbrands.com/ >>>>> >>>>> >>>>>------------------------------------------------------------------- -- >>>>>To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>>For additional commands, e-mail: [EMAIL PROTECTED] >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>>This e-mail, including any attachments, is a confidential business >>>> >>>> >>>communication, and may contain information that is confidential, >>>proprietary and/or privileged. This e-mail is intended only for the >>>individual(s) to whom it is addressed, and may not be saved, copied, >>>printed, disclosed or used by anyone else. If you are not the(an) >>> >>> >>intended >> >> >>>recipient, please immediately delete this e-mail from your computer >>> >>> >>system >> >> >>>and notify the sender. Thank you. >>> >>> >>>>-------------------------------------------------------------------- - >>>>To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>For additional commands, e-mail: [EMAIL PROTECTED] >>>> >>>> >>>> >>>> >>>> >>>> >>>-- >>>Brice Ruth, Sr. IT Analyst >>>Fiskars Brands Inc >>>http://www.fiskarsbrands.com/ >>> >>>--------------------------------------------------------------------- >>>To unsubscribe, e-mail: [EMAIL PROTECTED] >>>For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >> >> >> >> >>This e-mail, including any attachments, is a confidential business >communication, and may contain information that is confidential, >proprietary and/or privileged. This e-mail is intended only for the >individual(s) to whom it is addressed, and may not be saved, copied, >printed, disclosed or used by anyone else. If you are not the(an) intended >recipient, please immediately delete this e-mail from your computer system >and notify the sender. Thank you. >> >> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> > > >-- >Brice Ruth, Sr. IT Analyst >Fiskars Brands Inc >http://www.fiskarsbrands.com/ > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
