• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Jboss connection pooling timeout

 
Aravind Bhat
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
 
Aravind Bhat
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 547
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
- 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
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 547
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 547
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for the same pascal - I'll give it a try
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65229
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
 
Aravind Bhat
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 547
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 65229
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
An initial as your last name is not acceptable. This is your final warning.

bear
JavaRanch Sheriff
 
Aravind Bhat
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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~
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic