[hibernate-dev] Interested in new development

[Mario Ds Briggs]

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" <thamayanthi.g at gmail.com>
> Subject: Re: [hibernate-dev] Interested in new development
> To: hibernate-dev at lists.jboss.org
> Message-ID:
>    <4ea1f6fa0812060745v5c147369x6ccba9589b01b7b6 at 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 at 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 at 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
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.jboss.org/pipermail/hibernate-
> dev/attachments/20081206/c3690c6c/attachment-0001.html
>
> ------------------------------
>