This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Jboss connection pooling  timeout Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Jboss connection pooling  timeout" Watch "Jboss connection pooling  timeout" New topic
Author

Jboss connection pooling timeout

Aravind Bhat
Ranch Hand

Joined: Jun 16, 2006
Posts: 32
In the JSF project I'm working on, after an unspecific amount of time[normally within 2-3 hours...] , I get the following eror

ERROR [org.hibernate.util.JDBCExceptionReporter] No ManagedConnections available within configured blocking timeout ( 30000 [ms] )

I'm using Hibernate 3.0 and MySql 5.0 .

Please help .

Regards ,

Av~
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"Smoking gun",
Welcome to the JavaRanch.

We're a friendly group, but we do require members to have valid display names.

Display names must be two words: your first name, a space, then your last name. Fictitious names are not allowed.

Please edit your profile and correct your display name since accounts with invalid display names get deleted, often without warning

thanks,
Dave
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10141
    
165

Have a look at:
What does the message No Managed Connections Available mean


[My Blog] [JavaRanch Journal]
Aravind Bhat
Ranch Hand

Joined: Jun 16, 2006
Posts: 32
Thanks for the suggestion but increasing max-pool-size is not helping me in any way .

Is there some other way out ?

Regards ,

Aravind
pascal betz
Ranch Hand

Joined: Jun 19, 2001
Posts: 547
- Do you close the Session ?
- Do you execute native SQL statemenents (creaeteSQL query) and have some lingering connections ?
- Do you use more connections at once than are availble in the Pool and have long running operations (e.g. reporting)
- Do the connections "die" in the Pool (e.g. they become invalid trough timeout) ? I once had problems with an older version of MySQL where i had to sepcify special parameters in the JDBC)


Pascal
Aravind Bhat
Ranch Hand

Joined: Jun 16, 2006
Posts: 32
we are using ThreadLocal class to hold hibernate sessions . In this scenario , is it necessary to close the session ? .

Thanks ,
Aravind~
pascal betz
Ranch Hand

Joined: Jun 19, 2001
Posts: 547
It is always required to close the session! This does not depend on where you hold the Session. It rather depends who manages it.

Usualy the one who opens it is also responsible for closing it. So who opens it ? OpenSessionInView Filter ? Spring ? You ?

Pascal
Aravind Bhat
Ranch Hand

Joined: Jun 16, 2006
Posts: 32
We are Using a Seperate Helper Class with ThreadLocal to get the Sesssion Object. So is it in each dao implementation we have to explicitly manage the transaction and close the session
pascal betz
Ranch Hand

Joined: Jun 19, 2001
Posts: 547
Well if nobody closes the session....then you have to do it.

Take a look at Springframework TX/Session management, read a book on hibernate and make sure someone closes the session...

pascal
Aravind Bhat
Ranch Hand

Joined: Jun 16, 2006
Posts: 32
Thank you for the same pascal - I'll give it a try
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61309
    
  66

"Aravind A", you have previously been warned on one or more occasions regarding adjusting your display name to meet JavaRanch standards. This is not optional. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it prior to your next post.

Be aware that accounts with invalid display names are removed.

bear
JavaRanch Sheriff


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Aravind Bhat
Ranch Hand

Joined: Jun 16, 2006
Posts: 32
Sheriff ,
Pity you're making such a big fuss when I've given my name according to your naming policy quoted below .

"All JavaRanch users are asked to use a real name as their display name, with a first and last name, and maybe more, separated by spaces"

There's no mention of anything contrary in your Naming Policy -

Hence please enlighten me -

Regards ,
Aravind
pascal betz
Ranch Hand

Joined: Jun 19, 2001
Posts: 547
if "Aravind A" is your real name... then there is no problem; i think.
but your last name "A" seems a bit short...

pascal
Aravind Bhat
Ranch Hand

Joined: Jun 16, 2006
Posts: 32
Dear Pascal ,
I don't know how possibly I could prove this to you . I'm carrying this name from the time I was in lower primary . If the forum still needs a change , I'm open to it .

Regards ,
Aravind~
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61309
    
  66

An initial as your last name is not acceptable. This is your final warning.

bear
JavaRanch Sheriff
Aravind Bhat
Ranch Hand

Joined: Jun 16, 2006
Posts: 32
Now you tell me !!! . Quite a friendly group indeed... Intimidating the rest .

Please change your naming policy to be more precise instead of beating 'round the bush over a non-existent rule which states that the last name cannot be of a single letter .

Regards ,

Aravind~
 
GeeCON Prague 2014
 
subject: Jboss connection pooling timeout