This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JBoss/WildFly and the fly likes Datasource connection timeouts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Datasource connection timeouts" Watch "Datasource connection timeouts" New topic
Author

Datasource connection timeouts

Ben Johnson
Greenhorn

Joined: Aug 15, 2006
Posts: 4
Hi,

We're using pooled database connections through JBoss 4 connecting to an Ingres database. Everything works fine when the system first starts up, connections successfully contact the database and get reused via the connection pool. However...

...when the system is left alone for a reasonable length of time (e.g. 4-5 hours) the next use of a database connection times out, leaving a broken connection which is then returned to the pool. We've changed the datasource configuration to validate connections it gets out of the pool so that the system can continue to run, but we can't work out why the time-outs occur. We've also connected from a stand alone application using the same jdbc driver class to our database (i.e. bypassing JBoss) and the connections can be used and left alone with no problems at all, which leads us to think it's a datasource configuration problem.

Has anyone got any ideas?

Thanks

Ben


Datasource configuration:

[ August 15, 2006: Message edited by: Ben Johnson ]
Ben Johnson
Greenhorn

Joined: Aug 15, 2006
Posts: 4
Found the solution.

The transaction-isolation setting MUST match whatever the database is set to, otherwise you'll end up with problems like I've described.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Datasource connection timeouts
 
Similar Threads
Using DOM to set the value of a tag.
Problem with DataSource
Jboss, connection problem
connection pool with jboss
JBOSS startup error