These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 
  Previous topic | Next topic 
Author Message
klejaus
 Post subject: HQL Query Help
PostPosted: Fri Sep 02, 2005 4:41 am 
Newbie

Joined: Mon Apr 25, 2005 2:37 am
Posts: 5
Hibernate version:
Hibernate 2.1.8

Mapping documents:

Code between sessionFactory.openSession() and session.close():
protected void expandDepot(Depot depot, Item[] items) {
Session s= HibernateUtil.getSession();
try {
HibernateUtil.beginTransaction();
Query q= s.createQuery("from DepotItem as depotItem " +
"where depotItem.item in (:items) ");
q.setParameter("items", items);
q.list();
HibernateUtil.commitTransaction();
}
catch (HibernateException e) {
HibernateUtil.rollbackTransaction();
throw new InfrastructureException(e);
}
finally {
HibernateUtil.closeSession();
}
}

Full stack trace of any exception that occurs:
[9/2/05 11:32:06:616 EEST] 0000003a jsf E com.sun.faces.lifecycle.InvokeApplicationPhase execute #{pc_Deneme3.doTestBtnAction}: javax.faces.el.EvaluationException: com.xxx.yyy.exception.InfrastructureException: net.sf.hibernate.type.SerializationException: could not serialize
javax.faces.FacesException: #{pc_Deneme3.doTestBtnAction}: javax.faces.el.EvaluationException: com.xxx.yyy.exception.InfrastructureException: net.sf.hibernate.type.SerializationException: could not serialize
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:79)
at javax.faces.component.UICommand.broadcast(UICommand.java:312)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:302)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:416)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:77)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:201)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:91)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1173)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:92)
at com.xxx.yyy.db.hibernate.HiberTranFilter.doFilter(HiberTranFilter.java:25)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:626)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: javax.faces.el.EvaluationException: com.xxx.yyy.exception.InfrastructureException: net.sf.hibernate.type.SerializationException: could not serialize
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:131)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:73)
... 25 more
Caused by: com.xxx.yyy.exception.InfrastructureException: net.sf.hibernate.type.SerializationException: could not serialize
at pagecode.deneme.Deneme2.expandDepot(Deneme2.java:74)
at pagecode.deneme.Deneme2.doTestBtnAction(Deneme2.java:24)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:127)
... 26 more
Caused by: net.sf.hibernate.type.SerializationException: could not serialize
at net.sf.hibernate.util.SerializationHelper.serialize(SerializationHelper.java:152)
at net.sf.hibernate.util.SerializationHelper.serialize(SerializationHelper.java:172)
at net.sf.hibernate.type.SerializableType.toBytes(SerializableType.java:69)
at net.sf.hibernate.type.SerializableType.set(SerializableType.java:28)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:48)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:35)
at net.sf.hibernate.hql.QueryTranslator.bindNamedParameters(QueryTranslator.java:840)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:794)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at pagecode.deneme.Deneme2.expandDepot(Deneme2.java:69)
... 33 more
Caused by: java.io.NotSerializableException: com.xxx.yyy.model.Item
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java(Compiled Code))
at java.io.ObjectOutputStream.writeArray(ObjectOutputStream.java:1315)
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java(Compiled Code))
at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java(Compiled Code))
at net.sf.hibernate.util.SerializationHelper.serialize(SerializationHelper.java:148)
... 48 more

[9/2/05 11:32:06:736 EEST] 0000003a ServletWrappe E SRVE0068E: Could not invoke the service() method on servlet Faces Servlet. Exception thrown : javax.servlet.ServletException: #{pc_Deneme3.doTestBtnAction}: javax.faces.el.EvaluationException: com.xxx.yyy.exception.InfrastructureException: net.sf.hibernate.type.SerializationException: could not serialize
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:209)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1173)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:92)
at com.xxx.yyyk.db.hibernate.HiberTranFilter.doFilter(HiberTranFilter.java:25)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:626)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
---- Begin backtrace for Nested Throwables
javax.faces.FacesException: #{pc_Deneme3.doTestBtnAction}: javax.faces.el.EvaluationException: com.xxx.yyy.exception.InfrastructureException: net.sf.hibernate.type.SerializationException: could not serialize
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:79)
at javax.faces.component.UICommand.broadcast(UICommand.java:312)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:302)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:416)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:77)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:201)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:91)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1173)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:92)
at com.xxx.yyy.db.hibernate.HiberTranFilter.doFilter(HiberTranFilter.java:25)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:626)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: javax.faces.el.EvaluationException: com.xxx.yyy.exception.InfrastructureException: net.sf.hibernate.type.SerializationException: could not serialize
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:131)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:73)
... 25 more
Caused by: com.xxx.yyy.exception.InfrastructureException: net.sf.hibernate.type.SerializationException: could not serialize
at pagecode.deneme.Deneme2.expandDepot(Deneme2.java:74)
at pagecode.deneme.Deneme2.doTestBtnAction(Deneme2.java:24)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:127)
... 26 more
Caused by: net.sf.hibernate.type.SerializationException: could not serialize
at net.sf.hibernate.util.SerializationHelper.serialize(SerializationHelper.java:152)
at net.sf.hibernate.util.SerializationHelper.serialize(SerializationHelper.java:172)
at net.sf.hibernate.type.SerializableType.toBytes(SerializableType.java:69)
at net.sf.hibernate.type.SerializableType.set(SerializableType.java:28)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:48)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:35)
at net.sf.hibernate.hql.QueryTranslator.bindNamedParameters(QueryTranslator.java:840)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:794)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
at pagecode.deneme.Deneme2.expandDepot(Deneme2.java:69)
... 33 more
Caused by: java.io.NotSerializableException: com.xxx.yyy.model.Item
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java(Compiled Code))
at java.io.ObjectOutputStream.writeArray(ObjectOutputStream.java:1315)
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java(Compiled Code))
at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java(Compiled Code))
at net.sf.hibernate.util.SerializationHelper.serialize(SerializationHelper.java:148)
... 48 more


Name and version of the database you are using:
IBM DB2 8.2

The generated SQL (show_sql=true):
select depotitem0_.ID as ID, depotitem0_.DEPOT as DEPOT, depotitem0_.ITEM as ITEM, depotitem0_.QTY as QTY from DEPOTITEM depotitem0_ where (depotitem0_.ITEM in(?))

Problem:
My query throws net.sf.hibernate.type.SerializationException.
what's the problem?

by the way my item, depot, and depot item classes don't implement serializable interface.

thanks for advance.
Top
 Profile  
 
alesj
 Post subject:
PostPosted: Fri Sep 02, 2005 5:13 am 
Expert
Expert

Joined: Sat Oct 25, 2003 8:49 am
Posts: 490
Location: Vrhnika, Slovenia
q.setParameter("items", items);

should be:

q.setParameterList("items", Arrays.asList(items));
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.