dcsimg
Loop in connections ? (org.apache.struts.legacy.GenericDataSource getConnection Check for timeout)
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Monday, July 11, 2005 07:27 AM

Hi all, I have an error I don't understand. I made an application using Struts, Tomcat and an Oracle database. Sometimes, after some requests, my application doesn't respond and the stderr.log file get a lot of trace like this : 11-juil.-2005 13:29:54 org.apache.struts.legacy.GenericDataSource getConnection INFO: getConnection() 11-juil.-2005 13:29:54 org.apache.struts.legacy.GenericDataSource getConnection INFO: Check for timeout, activeCount=1, useCount=0 11-juil.-2005 13:29:54 org.apache.struts.legacy.GenericDataSource getConnection INFO: Found available connection 11-juil.-2005 13:29:54 org.apache.struts.legacy.GenericDataSource getConnection INFO:    More>>

Hi all,



I have an error I don't understand. I made an application using Struts, Tomcat and an Oracle database. Sometimes, after some requests, my application doesn't respond and the stderr.log file get a lot of trace like this :

			
11-juil.-2005 13:29:54 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
11-juil.-2005 13:29:54 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=1, useCount=0
11-juil.-2005 13:29:54 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Found available connection
11-juil.-2005 13:29:54 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return allocated connection, activeCount=1, useCount=1
11-juil.-2005 13:29:56 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
11-juil.-2005 13:29:56 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=1, useCount=1
11-juil.-2005 13:29:56 org.apache.struts.legacy.GenericDataSource createConnection
INFO: createConnection()
11-juil.-2005 13:29:56 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return new connection, activeCount=2, useCount=2
11-juil.-2005 13:29:58 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
11-juil.-2005 13:29:58 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=2
11-juil.-2005 13:29:58 org.apache.struts.legacy.GenericDataSource createConnection
INFO: createConnection()
11-juil.-2005 13:29:58 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return new connection, activeCount=3, useCount=3
11-juil.-2005 13:30:01 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
11-juil.-2005 13:30:01 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=3, useCount=3
11-juil.-2005 13:30:01 org.apache.struts.legacy.GenericDataSource createConnection
INFO: createConnection()
11-juil.-2005 13:30:02 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return new connection, activeCount=4, useCount=4
11-juil.-2005 13:30:08 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
11-juil.-2005 13:30:08 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=4, useCount=4
11-juil.-2005 13:30:08 org.apache.struts.legacy.GenericDataSource createConnection
INFO: createConnection()
11-juil.-2005 13:30:08 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Return new connection, activeCount=5, useCount=5
11-juil.-2005 13:30:12 org.apache.struts.legacy.GenericDataSource getConnection
INFO: getConnection()
11-juil.-2005 13:30:12 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=5, useCount=5
11-juil.-2005 13:30:12 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Sleep until next test
11-juil.-2005 13:30:13 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=5, useCount=5
11-juil.-2005 13:30:13 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Sleep until next test
11-juil.-2005 13:30:14 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=5, useCount=5
11-juil.-2005 13:30:14 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Sleep until next test
11-juil.-2005 13:30:15 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=5, useCount=5
11-juil.-2005 13:30:15 org.apache.struts.legacy.GenericDataSource getConnection
INFO: Sleep until next test
...and continuing like this.................


Why am I getting this and how can I do to don't have request or connection problems ?



Thanks in advance,

Regards,    <<Less

Re: Loop in connections ? (org.apache.struts.legacy.GenericDataSource getConnection Check for timeout)

Posted By:   Christopher_Koenigsberg  
Posted On:   Saturday, July 16, 2005 08:10 PM

Your DataSource is testing the connections in the connection pool, I think, to make sure they have not gone bad. There should be config options to control this, for whatever implementation you are using.
About | Sitemap | Contact