Hibernate version:3.2.4
Websphere 6.1
JDK 5
Sun Solaris OS
Name and version of the database you are using:IBM DB2 version 8

When we try to invoke a DB2 storedProc using:

CallableStatement cs = conn.prepareCall(proc);

We receive this error. Although this error is not happening always. It suddenly props up. This error resolves as soon as the app server (IBM Websphere v6.1) is restarted. Any thoughts on how to isolate the issue would be really helpful?

Full stack trace of any exception that occurs:

Caused by: java.lang.NoClassDefFoundError: sun/reflect/GeneratedMethodAccessor100
at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
at $Proxy4.prepareCall(Unknown Source)

The same issue started popping up when the app tries to execute SQL query also. While performing load testing this problem could be repeatable. Although there are no patterns about when will this issue occur.

Based on the stack trace what i am getting is that BorrowedConnectionProxy is trying to load a class and at that point the classnotfoundexception is being thrown. Could this be related to classloader settings on the app server ?

We can repeat the problem, but not with any regularity, so it is difficult to troubleshoot.

We would really appreciate it if anyone who has seen such a problem before or for suggestions about what to look for outside of hibernate that might cause hibernate to have such behavior can respond to this post ASAP.