This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
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 126.96.36.199 is my Master DB and 188.8.131.52 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
subject: Mysql Nested Exception Problem in the DB Cluster Environment