今天在做Hibernate多对一查询时,一方查询正常,但多方查询出错.出错的异常信息为:
javax.servlet.ServletException: java.lang.NullPointerException
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.oaweb.filter.EncodingFilter.doFilter(EncodingFilter.java:23)
root cause
java.lang.NullPointerException
org.hibernate.tuple.AbstractEntityTuplizer.createProxy(AbstractEntityTuplizer.java:372)
org.hibernate.persister.entity.AbstractEntityPersister.createProxy(AbstractEntityPersister.java:3121)
org.hibernate.event.def.DefaultLoadEventListener.createProxyIfNecessary(DefaultLoadEventListener.java:232)
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:173)
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)
org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:862)
org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:830)
org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
org.hibernate.type.EntityType.resolve(EntityType.java:303)
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
org.hibernate.loader.Loader.doQuery(Loader.java:717)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2145)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
com.oaweb.dao.impl.UserDAO.findPassword(UserDAO.java:26)
com.oaweb.service.impl.UserService.findPassword(UserService.java:29)
com.oaweb.struts.action.UserAction.register(UserAction.java:59)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:589)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.oaweb.filter.EncodingFilter.doFilter(EncodingFilter.java:23)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.
Hibernate中Userinfo实体映射文件:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="com.oaweb.bo.Userinfo" table="USERINFO" schema="OAWEB">
<id name="userid" type="java.lang.Long">
<column name="USERID" precision="10" scale="0" />
<generator class="sequence" >
<param name="sequence">seq1</param>
</generator>
</id>
<many-to-one name="role" class="com.oaweb.bo.Role" fetch="select" >
<column name="ROLEID" precision="10" scale="0" />
</many-to-one>
<many-to-one name="duty" class="com.oaweb.bo.Duty" fetch="select" >
<column name="DUTYID" precision="10" scale="0" />
</many-to-one>
<many-to-one name="department" class="com.oaweb.bo.Department" fetch="select" >
<column name="DEPTID" precision="10" scale="0" />
</many-to-one>
<property name="username" type="java.lang.String">
<column name="USERNAME" length="20" not-null="true" />
</property>
<property name="realname" type="java.lang.String">
<column name="REALNAME" length="20" not-null="true" />
</property>
<property name="userpassword" type="java.lang.String">
<column name="USERPASSWORD" length="32" not-null="true" />
</property>
<property name="question" type="java.lang.String">
<column name="QUESTION" length="50" not-null="true" />
</property>
<property name="answer" type="java.lang.String">
<column name="ANSWER" length="50" not-null="true" />
</property>
<property name="usersex" type="java.lang.String">
<column name="USERSEX" length="4" not-null="true" />
</property>
<property name="userage" type="java.lang.Long">
<column name="USERAGE" precision="2" scale="0" />
</property>
<property name="usernation" type="java.lang.String">
<column name="USERNATION" length="20" />
</property>
<property name="userstature" type="java.lang.String">
<column name="USERSTATURE" length="5" />
</property>
<property name="bornaddress" type="java.lang.String">
<column name="BORNADDRESS" length="60" />
</property>
<property name="borndate" type="java.util.Date">
<column name="BORNDATE" length="7" />
</property>
<property name="mobiltel" type="java.lang.String">
<column name="MOBILTEL" length="20" />
</property>
<property name="worktel" type="java.lang.String">
<column name="WORKTEL" length="20" />
</property>
<property name="address" type="java.lang.String">
<column name="ADDRESS" length="100" />
</property>
<property name="mailno" type="java.lang.String">
<column name="MAILNO" length="6" />
</property>
<property name="email" type="java.lang.String">
<column name="EMAIL" length="30" />
</property>
<property name="hometel" type="java.lang.String">
<column name="HOMETEL" length="20" />
</property>
<property name="workdate" type="java.util.Date">
<column name="WORKDATE" length="7" />
</property>
<property name="userstatus" type="java.lang.String">
<column name="USERSTATUS" length="10" />
</property>
<property name="politician" type="java.lang.String">
<column name="POLITICIAN" length="10" />
</property>
<property name="college" type="java.lang.String">
<column name="COLLEGE" length="60" />
</property>
<property name="speciality" type="java.lang.String">
<column name="SPECIALITY" length="60" />
</property>
<property name="collegegrade" type="java.lang.String">
<column name="COLLEGEGRADE" length="16" />
</property>
<property name="englishgrade" type="java.lang.String">
<column name="ENGLISHGRADE" length="40" />
</property>
<property name="itgrade" type="java.lang.String">
<column name="ITGRADE" length="40" />
</property>
</class>
</hibernate-mapping>
在查询Department,Duty,Role时均正常.查询Userinfo时,报
java.lang.NullPointerException
org.hibernate.tuple.AbstractEntityTuplizer.createProxy(AbstractEntityTuplizer.java:372)
在网上搜索答案时,给出的解决方案是:
1.导入cglib-2.2并替换掉cglib-2.13
2.将其关联的对象设置成lazy="false"
我采用的是第二种:即将 <many-to-one name="role" class="com.oaweb.bo.Role" fetch="select" >
<column name="ROLEID" precision="10" scale="0" />
</many-to-one>
<many-to-one name="duty" class="com.oaweb.bo.Duty" fetch="select" >
<column name="DUTYID" precision="10" scale="0" />
</many-to-one>
<many-to-one name="department" class="com.oaweb.bo.Department" fetch="select" >
<column name="DEPTID" precision="10" scale="0" />
</many-to-one>
改为:
<many-to-one name="role" class="com.oaweb.bo.Role" fetch="select" lazy="false">
<column name="ROLEID" precision="10" scale="0" />
</many-to-one>
<many-to-one name="duty" class="com.oaweb.bo.Duty" fetch="select" lazy="false">
<column name="DUTYID" precision="10" scale="0" />
</many-to-one>
<many-to-one name="department" class="com.oaweb.bo.Department" fetch="select" lazy="false">
<column name="DEPTID" precision="10" scale="0" />
</many-to-one>
即可正常运行.