Hi,

 

I need help on hibernate;

 

Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2223)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at com.gtech.video.persistence.hibernate.HibernateUtils.getById(HibernateUtils.java:84)
        ... 94 more
Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -954, SQLSTATE: 57011, SQLERRMC: null
        at com.ibm.db2.jcc.c.wf.b(wf.java:2952)
        at com.ibm.db2.jcc.c.wf.a(wf.java:2935)
        at com.ibm.db2.jcc.b.gb.a(gb.java:709)
        at com.ibm.db2.jcc.b.gb.m(gb.java:698)
        at com.ibm.db2.jcc.b.gb.i(gb.java:242)
        at com.ibm.db2.jcc.b.gb.c(gb.java:53)
        at com.ibm.db2.jcc.b.w.c(w.java:46)
        at com.ibm.db2.jcc.b.vb.h(vb.java:151)
        at com.ibm.db2.jcc.c.fg.p(fg.java:1220)
        at com.ibm.db2.jcc.c.gg.d(gg.java:2349)
        at com.ibm.db2.jcc.c.gg.V(gg.java:424)
        at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407)
        at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)

What could be the issue?. Even though i have proper database connection and everything. And sometimes I am getting could n't load entity. Is the db configuration issue?. or I am missing something.

 

Can any one help me on this?

 

Thanks

Thamayanthi