| Joined: Thu Oct 04, 2007 5:00 am
 Posts: 13
 | 
				
					| Thanks Satish. But the code is throwing TypeMisMatchException.
I am using:-
 Hibernate 3.2
 Struts 1.2.9
 Sun Java System Application Server 9
 jdk 1.6
 JavaDB 10.2.2 as backend
 
 the code is:-
 
 session=factory.openSession();
 
 String queryString = "from hibernate.pojo.Users";
 
 Query query = session.createQuery ( queryString );
 
 
 List<Users> list = ( List<Users> ) query.list();
 
 The exception is thrown at line marked bold:-
 Hibernate: select users0_.EMAILID as EMAILID1_ from USERS users0_
 
 Runtime server log is:-
 org.hibernate.TypeMismatchException: Provided id of the wrong type. Expected: class java.lang.Long, got class java.lang.String
 at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:86)
 at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
 at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
 at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:557)
 at org.hibernate.type.EntityType.resolve(EntityType.java:379)
 at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
 at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
 at org.hibernate.loader.Loader.doQuery(Loader.java:729)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
 at org.hibernate.loader.Loader.doList(Loader.java:2220)
 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 helpers.DuplicateUserCheck.isDuplicateUser(DuplicateUserCheck.java:37)
 at struts.action.AbstractUserRegistrationAction.execute(AbstractUserRegistrationAction.java:196)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
 at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:278)
 at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
 at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
 at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
 at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
 at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
 at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
 at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
 at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
 at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
 at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
 at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
 at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
 at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
 at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
 at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
 
 users.hbm.xml
 <class name="hibernate.pojo.Users" table="USERS">
 <id name="emailid"  column="EMAILID">
 <generator class="assigned"/>
 </id>
 
 <!--unidirectional one-to-one mappings from User to Name-->
 <one-to-one name="name" class="hibernate.pojo.Name"  foreign-key="nameid" fetch="join"/>
 </class>
 
 
 |  |