I am not sure I understand your question. But in my trails, if my JNDI resource is in GlobalNamingResources, those connection won't be killed unless I shutdown tomcat. If my resource is in my own context, I have to kill them when I stop my application.
-----Original Message----- From: Ruth, Brice [mailto:[EMAIL PROTECTED] Sent: December 6, 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.ja >>>>v >>>> >>>> >a( > > >>>> >>>> >>>Comp >>> >>> >>> >>> >>>>iled >>>>Code)) >>>> at >>>>com.ibm.as400.access.AS400JDBCConnection.send(AS400JDBCConnection.ja >>>>v >>>> >>>> >a( > > >>>> >>>> >>>Inli >>> >>> >>> >>> >>>>ned >>>>Compiled Code)) >>>> at >>>>com.ibm.as400.access.AS400JDBCStatement.syncRPB(AS400JDBCStatement.j >>>>a >>>> >>>> >va > > >>>> >>>> >>>(Com >>> >>> >>> >>> >>>>piled >>>>Code)) >>>> at >>>>com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCState >>>>m >>>> >>>> >en > > >>>> >>>> >>>t.ja >>> >>> >>> >>> >>>>va(Compiled >>>>Code)) >>>> at >>>>com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPrep >>>>a >>>> >>>> >re > > >>>> >>>> >>>dSta >>> >>> >>> >>> >>>>tement.java(Compiled >>>>Code)) >>>> at >>>>com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCC >>>>o >>>> >>>> >nn > > >>>> >>>> >>>ecti >>> >>> >>> >>> >>>>on.java(Compiled >>>>Code)) >>>> at >>>>com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCC >>>>o >>>> >>>> >nn > > >>>> >>>> >>>ecti >>> >>> >>> >>> >>>>on.java(Compiled >>>>Code)) >>>> at >>>>org.apache.commons.dbcp.DelegatingConnection.prepareStatement(Delega >>>>t >>>> >>>> >in > > >>>> >>>> >>>gCon >>> >>> >>> >>> >>>>nection.java(Compiled >>>>Code)) >>>> at >>>>org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper >>>>. >>>> >>>> >pr > > >>>> >>>> >>>epar >>> >>> >>> >>> >>>>eStatement(PoolingDataSource.java(Compiled >>>>Code)) >>>> at >>>>org.apache.catalina.realm.DataSourceRealm.credentials(DataSourceReal >>>>m >>>> >>>> >.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(PoolingDataS >>>>o >>>> >>>> >ur > > >>>> >>>> >>>ce.j >>> >>> >>> >>> >>>>ava(Compiled >>>>Code)) >>>> at >>>>org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSourc >>>>e >>>> >>>> >.j > > >>>> >>>> >>>ava( >>> >>> >>> >>> >>>>Compiled >>>>Code)) >>>> at >>>>org.apache.catalina.realm.DataSourceRealm.open(DataSourceRealm.java: >>>>4 >>>> >>>> >38 > > >>>> >>>> >>>) >>> >>> >>> >>> >>>> at >>>>org.apache.catalina.realm.DataSourceRealm.authenticate(DataSourceRea >>>>l >>>> >>>> >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</value> >>>> </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] !DSPAM:41b4ce4a209601339211145!
