Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():

try
{
hibernateTx = hsession.beginTransaction();
Query q = hsession.getNamedQuery(GET_WORKFLOW_GROUPS_FOR_MEMBER);

q.setInteger("memberid", memberId.intValue());
List workFlowGroupIds = null;
try
{
System.out.println(q.getQueryString());
workFlowGroupIds = q.list(); //**** BLOWS UP HERE ***
}
catch(Exception e)
{
e.printStackTrace();
return null;
}


Iterator iter = workFlowGroupIds.iterator();

q = hsession.getNamedQuery(GET_CHANGEDOCS_ASSIGNED_TO_GROUP);

while(iter.hasNext())
{
Integer groupId = (Integer)iter.next();
q.setInteger("workflowGroupId", groupId.intValue());
List results = q.list();

Iterator resultIter = results.iterator();

while(resultIter.hasNext())
{
ChangeDocs currentDoc = (ChangeDocs)resultIter.next();
Integer changeDocId = currentDoc.getChangedocid();
String reasonChange = currentDoc.getReasonchg();
assignedChangeDocs.put(changeDocId, reasonChange);
}


}

hibernateTx.commit();
hsession.close();
}
catch(Exception e)
{
hibernateTx.rollback();
e.printStackTrace();
}




Full stack trace of any exception that occurs:
15:15:39,656 INFO [STDOUT] java.lang.NullPointerException
15:15:39,656 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
15:15:39,656 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
15:15:39,656 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
15:15:39,656 INFO [STDOUT] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
15:15:39,656 INFO [STDOUT] at org.hibernate.loader.Loader.doQuery(Loader.java:661)
15:15:39,656 INFO [STDOUT] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
15:15:39,656 INFO [STDOUT] at org.hibernate.loader.Loader.doList(Loader.java:2147)
15:15:39,656 INFO [STDOUT] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
15:15:39,656 INFO [STDOUT] at org.hibernate.loader.Loader.list(Loader.java:2021)
15:15:39,656 INFO [STDOUT] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
15:15:39,656 INFO [STDOUT] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
15:15:39,656 INFO [STDOUT] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:137)
15:15:39,656 INFO [STDOUT] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1014)
15:15:39,656 INFO [STDOUT] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
15:15:39,656 INFO [STDOUT] at com.synesis7.i3.workflow.ejb.WorkflowBean.entry(WorkflowBean.java:142)
15:15:39,656 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:15:39,656 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
15:15:39,656 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:15:39,656 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585)
15:15:39,656 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
15:15:39,656 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:
149)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java
:154)
15:15:39,656 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
15:15:39,656 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:873)
15:15:39,656 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
15:15:39,656 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:15:39,656 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585)
15:15:39,671 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
15:15:39,671 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
15:15:39,671 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
15:15:39,671 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
15:15:39,671 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
15:15:39,671 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)
15:15:39,671 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
15:15:39,671 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
15:15:39,671 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:15:39,671 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585)
15:15:39,671 INFO [STDOUT] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
15:15:39,671 INFO [STDOUT] at sun.rmi.transport.Transport$1.run(Transport.java:153)
15:15:39,671 INFO [STDOUT] at java.security.AccessController.doPrivileged(Native Method)
15:15:39,671 INFO [STDOUT] at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
15:15:39,671 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
15:15:39,671 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
15:15:39,671 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)


Name and version of the database you are using: Oracle 9i

I am using JBoss 4.0.3, the above code is in a SessionBean (EJB 2.1).

Anyone have any ideas?

Thank you,
Bill

I am also getting the same exception on a call to hsession.get(Class, Serializable);

my session is not null, so it's not that.

Any ideas what I am missing?

Are you using an Interceptor?

Hey,

I'm having this problem now, Has anyone found a solution to this?

Thank you,


Steve.