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...
thanks
Mario
Date: Sat, 6 Dec 2008 11:45:25 -0400
From: "Thamayanthi k" <thamayanthi.g(a)gmail.com>
Subject: Re: [hibernate-dev] Interested in new development
To: hibernate-dev(a)lists.jboss.org
Message-ID:
<4ea1f6fa0812060745v5c147369x6ccba9589b01b7b6(a)mail.gmail.com>
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
<max.andersen(a)redhat.com
> 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 <mazz(a)redhat.com>
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
> >
>