Hi Thamayanthi, SQLCode -954 is related to not enough memory available to process the statement. You can change the APPLHEAPSZ setting as detailed in the link below. Alternately you can review to see what you are trying to load/read and if you need all that data and if you can optimize it/
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.messages.sql.doc/doc/msql00954c.html thanks Mario > Date: Sat, 6 Dec 2008 11:45:25 -0400 > From: "Thamayanthi k" <[EMAIL PROTECTED]> > Subject: Re: [hibernate-dev] Interested in new development > To: hibernate-dev@lists.jboss.org > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="iso-8859-1" > > 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 > > On Thu, Dec 4, 2008 at 2:43 PM, Max Rydahl Andersen <[EMAIL PROTECTED] > > wrote: > > > http://hibernate.org/6.html > > > > has all the info or link to it. > > > > /max > > > > > > Hi > >> > >> I need some details reagrding the environment setup and all before > >> starting. where can i get the details about? > >> > >> Thanks > >> Thamayanthi > >> > >> On Thu, Dec 4, 2008 at 12:56 PM, John Mazzitelli <[EMAIL PROTECTED]> wrote: > >> > >> > Though I have less knowledge in Hibernate. I am interested in working > >>> > with new development and fixes > >>> > >>> Feel free to finish this for me :) > >>> > >>> http://opensource.atlassian.com/projects/hibernate/browse/HHH-3593 > >>> > >>> Read the full thread for background and what needs to be done: > >>> > >>> http://lists.jboss.org/pipermail/hibernate-dev/2008-November/003452.html > >>> > >>> Steve would like this refactored and moved over to the JMX module. This > >>> actually might be a good thing for someone new to do; someone that wants > >>> to > >>> get started - its fairly out of the way of the hard-core hibernate stuff, > >>> but it'll get your feet wet working in the hibernate dev environment. > >>> > >>> Just a thought ;} > >>> > >>> > > > > > > -- > > /max > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: http://lists.jboss.org/pipermail/hibernate- > dev/attachments/20081206/c3690c6c/attachment-0001.html > > ------------------------------ > _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
