This week's book giveaway is in the Reactive Progamming forum.
We're giving away four copies of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams and have Adam Davis on-line!
See this thread for details.
Win a copy of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams this week in the Reactive Progamming forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

GenericJDBCException: Cannot open connection

 
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi I am updating MySQL database from Swing Client and jboss-5.1.0.GA as a server. The bean which I want to update is EJB3 enity bean.
While updating i am getting following exception. When I update less no of rows I did not get it, but if no of rows increase I get this exception. Please anyone have any clue about how to get rid this exception.
I am sorry as I dont know which tag should use to copy stack trace, I am using code tag..
 
Ranch Hand
Posts: 85
MySQL Database Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

There is some hard limit on the database server about the maximum number of concurrent connections. You've reaching this limit, when you try and get another connection it fails.

Please check your Configuration File (Ex - mysql-ds.xml) file for the maximum and Minimum number of Concurrent Connections to the Database.



 
Sham Phadtale
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you want to say pool size? Following is my *-ds.xml file.


Do I need to add some annotations like TransactionType(?) to my code which is updating database? What should I do to fix the issue?
 
The human mind is a dangerous plaything. This tiny ad is pretty safe:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!