Hi All,
I am getting the below error on executing a list() method on Query object.

org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2231)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
org.hibernate.loader.Loader.list(Loader.java:2120)
org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:935)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

The same code was working fine till last week. After getting this error, we restarted the server and it started working fine again.

Any help is greatly appreciated.
Thnx.

Just wanted to update my question ...

We are currently using Hibernate 3.0 and DB2 9.1.
When checked the hibernate jars....
the exception is coming from the following code..

try {
result = doQueryAndInitializeNonLazyCollections( session, queryParameters, true );
}
catch ( SQLException sqle ) {
throw JDBCExceptionHelper.convert(
factory.getSQLExceptionConverter(),
sqle, "could not execute query",
getSQLString() );
}

Thnx...