DBCP could not obtain an idle db connection pool exhausted

[Scott Power]

Hi folks,

Here's my situation, I am using tomcat(latest version) and
mysql,jdbc(mysql ..connector..jar) and struts for an application with
connection pooling.  I can not figure out why my connection stay around
once I close them, they are not sent back to the pool.

I create a connection then I 

                Connection myConnection = utilclass.getDbConnection();

the getDBconnetion() method is here:

        public Connection getDbConnection() {
                String contextString = "java:comp/env/jdbc/cms";
                Connection localConnection = null;
                DataSource myBasicDataSource = null;

                try {
                        Context myContext = new InitialContext();
                        myBasicDataSource = (DataSource)
myContext.lookup(contextString);
                        localConnection =
myBasicDataSource.getConnection();
                }
                   ..................return localConnection;


I use the connection for a statement and a result set.

I close the connection
                         myConnection .close();

I have also found out that you should be closing the result set and the
statement also, which I have tried but that did not resolve my problem. 
When I check out the DB I see the connections that are created during
the application but they remain there in sleep until tomcat is
shutdown.

I have added the following to my server.xml to clean up connections

              <name>removeAbandoned</name>
              <value>true</value>
            </parameter>
            <parameter>
              <name>removeAbandonedTimeout</name>
              <value>10</value>
            </parameter>
            <parameter>
              <name>logAbandoned</name>
              <value>true</value>
            </parameter>

but this does not seem to work, I added it in the jdbc resource params
section.  Is there a way to clean up these connections that are lying
around.  I connect many times to the db and I thought that in the end of
things I should only have one connection left, all the other connections
were closed but not reclaimed.

I could really use some help on this one.

Thanks 

Scott




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]