Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Maximum Number of Connections in JBOSS

 
s rakesh
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all

I am using JBOSS 4.2 and SQLServer 2005 for my application.
I am getting No Managed connections exception on load testing the application.

I changed the value of <max-pool-size> tag in mssql-ds.xml to 100 the load testing passes without any exceptions.

Is it advisable to keep max connections to 100?

I know JBOSS default maximum size is just 20.


Thanks
Rakesh
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Rakesh"

Please check your private message for a message from JavaRanch.
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by rakesh:

Is it advisable to keep max connections to 100?



It depends on your application and the database server. If your application requires a maximum of 100 connections to be open at a given time and if your database server allows that, then you can set that value.
 
s rakesh
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jaikiran
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic