• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Mysql Nested Exception Problem in the DB Cluster Environment

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic