Barry, that's a normal console message when using the DataSource. :) Alright. I have a question. I've finished up the ConnectionPool wrapper class that I found and is being used. I don't need it to run, but I figured it's there why not modify it to handle EVERYTHING dealing with connections. While I have a getConnection(), I have also created many recycleConnection methods that close abandoned Statements, Connections, ResultSets, and DatabaseMetaData's.
So my ConnectionPool class is here http://www.realissuesforrealpeople.com/ConnectionPool.java and my DatabaseTransaction class is here http://www.realissuesforrealpeople.com/DatabaseTransaction.java - Thanks for the template for the Transaction Mr. Schultz btw. I haven't worked on the filter as of yet, however, I am being told that the ConnectionPool wrapper is a horrible idea and that I will end up with problems with it. As well as the DatabaseTransaction class. Can anyone forsee any issues with either that I am not forseeing? My ability to use the force is broken at the moment. I"m looking at the filter as of right now. I"ve never implemented one however. On Thu, Nov 5, 2009 at 4:03 PM, Propes, Barry L <barry.l.pro...@citi.com>wrote: > Oh yeah....good point..I likely don't have many (I have a few) DB errors > printing tighto the console. > > Fortunately, I've shored that area up greatly. > > > > -----Original Message----- > From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com] > Sent: Thursday, November 05, 2009 2:52 PM > To: Tomcat Users List > Subject: RE: ConnectionPool question > > > From: Propes, Barry L [mailto:barry.l.pro...@citi.com] > > Subject: RE: ConnectionPool question > > > > When I FIRST make a DB query through one of my JSPs/servlets, I get > > this msg printed to the console. > > > > AbandonedObjectPool is used > > (org.apache.commons.dbcp.abandonedobjectp...@b32627) > > LogAbandoned: true > > RemoveAbandoned: true > > RemoveAbandonedTimeout: 30 > > The above message is displayed by the constructor for the pool, directly to > System.out, when the DataSource is being instantiated. It simply says that > your config is using the abandoned pool mechanism, and not an indication > that you actually have any abandoned connections at this time. > > - Chuck > > > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY > MATERIAL and is thus for use only by the intended recipient. If you received > this in error, please contact the sender and delete the e-mail and its > attachments from all computers. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
