This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JBoss/WildFly and the fly likes Jboss-MySql Connection Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Jboss-MySql Connection Problem" Watch "Jboss-MySql Connection Problem" New topic
Author

Jboss-MySql Connection Problem

bala kiran
Ranch Hand

Joined: Jun 11, 2004
Posts: 34
I am losing mysql connection from jboss very frequently. Mysql db is in the same network, but on a different IP. After researching thru jboss documentation, I added this line to my mysql db xml file,
<connection-property name="autoReconnect">true</connection-property>

still its losing connection after 6-7 hrs of not using. The connection re-establishes if i restart jboss.

Any help is greatly appreciated.
bala kiran
Ranch Hand

Joined: Jun 11, 2004
Posts: 34
Nobody has a clue on this? In that case, I guess I have to buy jboss support.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10069
    
163

Similar issue was reported some time back here:

Connection timeouts


[My Blog] [JavaRanch Journal]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Jboss-MySql Connection Problem