aspose file tools*
The moose likes JDBC and the fly likes Mysql Nested Exception Problem in the DB Cluster Environment Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mysql Nested Exception Problem in the DB Cluster Environment" Watch "Mysql Nested Exception Problem in the DB Cluster Environment" New topic
Author

Mysql Nested Exception Problem in the DB Cluster Environment

Sreekanth Kalakanti
Greenhorn

Joined: Sep 09, 2009
Posts: 12
Hi all,


I am using mysql5.0 version and its in cluster environment as defined in mysql-ds.xml file data source definition,
When an API call is made from the java application to the clustered DB we are receiving the nested exception error problem
for every alternate call to the API(getEmployees()), i.e

when the first call is made to the Api from one system its giving correctly the list of employees but
when second call is made to same API we are getting the list of employees but we are getting the

Nested Exception as mentioned below, so this is happening every alternate call to the API.

As because of in the ds file we are able to retrieve the result correctly but
exception in log is printing for every alternate call




In the below XMl(mysql-ds.xml) file(datasources) the 100.168.120.121 is my Master DB and 100.168.120.122 is the Slave DB



The log file prints the below nested exception log



So please try to help me to resolve this problem
as the log file is unnecessarly getting filled with this nested exception content
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mysql Nested Exception Problem in the DB Cluster Environment