Jump to content
We've recently updated our Privacy Statement, available here ×

Jasper Server mysql connections issue


msaibalwar

Recommended Posts

I am testing performance of jasper server(6.2.0) using jmeter. I have created test plan by hitting some urls of jasper reports(using bean data source to fill the reports by fetching data from mysql using hibernate 3.3.2) in jasper server(running on my local machine).

After starting or restarting jasper server and running my test plan in jmeter then mysql(running on my local machine) is giving error of too many connections and all max possible connections of mysql are going in a sleep mode and jmeter is giving error of jasper server can not open connection to mysql and all these connections in sleep mode can not be used.
Jmeter is giving same error can not open connection by running jmeter test plan whatever number of times until I restart mysql.
I am using hibernate(3.3.2) with c3p0 connection pool still number of mysql connections are exceeding the max pool size.

After restarting mysql everything working as normal, c3p0 pool is getting configured properly, number of mysql connections are as per the max pool size property of c3p0, jasper server now can obtain mysql connections and jmeter test plan is returning result with 100% success rate.

What could be the issue of jasper server and mysql connections when running the jmeter test plan for first time after restarting jasper server? Why all max possible connections are going in sleep mode? And why all these connections can not be re-used until restarting mysql?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...