小弟是想问关于Hibernate Annotations 用户自定义类型的问题,我在做插入操作的时候,数据就可以正确的插入到数据库中;但是执行查询操作的时候,就出现错误了,SQL语句可以出来的,也是可以在PL/SQL中正确执行,异常如下:
Hibernate: select customers_0_.id as id7_0_, customers_0_.COM_STREET as COM2_7_0_, customers_0_.COM_CITY as COM3_7_0_, customers_0_.COM_PROVINCE as COM4_7_0_, customers_0_.COM_ZIPCODE as COM5_7_0_, customers_0_.HOME_STREET as HOME6_7_0_, customers_0_.HOME_CITY as HOME7_7_0_, customers_0_.HOME_PROVINCE as HOME8_7_0_, customers_0_.HOME_ZIPCODE as HOME9_7_0_, customers_0_.sex as sex7_0_, customers_0_.phone as phone7_0_, customers_0_.FIRSTNAME as FIRSTNAME7_0_, customers_0_.LASTNAME as LASTNAME7_0_ from CUSTOMERS_USERTYPE customers_0_ where customers_0_.id=?
---------------------------SQL可以打出来了,可以在PL/SQL里面执行
10:41:23,125WARNJDBCExceptionReporter:71-SQLError:17024,SQLState:null
10:41:23,125ERRORJDBCExceptionReporter:72-未读取数据
10:41:23,140INFODefaultLoadEventListener:109-Errorperformingloadcommand
org.hibernate.exception.GenericJDBCException:couldnotloadanentity:[com.usertype.forms.Customers_UserType#7]
atorg.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
atorg.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
atorg.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
atorg.hibernate.loader.Loader.loadEntity(Loader.java:1798)
atorg.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
atorg.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
atorg.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2977)
atorg.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:393)
atorg.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374)
atorg.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
atorg.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
atorg.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
atorg.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
atorg.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
atorg.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
atorg.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:460)
atorg.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
atorg.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:454)
atorg.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:448)
atcom.usertype.dao.Customers_UserTypeImpDao.getCustomers_UserType(Customers_UserTypeImpDao.java:18)
atcom.hibernate.Customers_UserTypeServices.showCustomers_UserType(Customers_UserTypeServices.java:59)
atcom.hibernate.Main.main(Main.java:48)
Causedby:java.sql.SQLException:未读取数据
atoracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
atoracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
atoracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
atoracle.jdbc.driver.OracleStatement.wasNullValue(OracleStatement.java:3174)
atoracle.jdbc.driver.OracleResultSetImpl.wasNull(OracleResultSetImpl.java:127)
atcom.usertype.AddressUserType.nullSafeGet(AddressUserType.java:53)
atorg.hibernate.type.CustomType.nullSafeGet(CustomType.java:105)
atorg.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
atorg.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2031)
atorg.hibernate.loader.Loader.loadFromResultSet(Loader.java:1371)
atorg.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1299)
atorg.hibernate.loader.Loader.getRow(Loader.java:1197)
atorg.hibernate.loader.Loader.getRowFromResultSet(Loader.java:568)
atorg.hibernate.loader.Loader.doQuery(Loader.java:689)
atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
atorg.hibernate.loader.Loader.loadEntity(Loader.java:1784)
... 18 more
我的部分代码如下:
1.POJO
package com.usertype.forms;
import java.io.Serializable;
import javax.persistence.*;import org.hibernate.annotations.*;
/**
*@projectclustering
*@authorxuchao
*@create_date2008-3-6
*@description
*/
@SuppressWarnings("serial")
@Entity
@org.hibernate.annotations.Entity(dynamicUpdate=true)
@Table(name="CUSTOMERS_USERTYPE")
@SequenceGenerator(name="CUSTOMERS_USERTYPE_SEQ",sequencename="CUSTOMERS_USERTYPE_SEQ")
publicclassCustomers_UserTypeimplementsSerializable{
private Integer id;private Name name;
private Address homeAddress;
private Address comAddress;
private Gender gender;
private Integer phone;
/** full constructor */
publicCustomers_UserType(Namename,AddresshomeAddress,AddresscomAddress,Gendergender,Integerphone){
this.name=name;
this.homeAddress=homeAddress;
this.comAddress=comAddress;
this.gender=gender;
this.phone=phone;
}publicCustomers_UserType(){
}@Type(type="com.usertype.AddressUserType")
@Columns(columns={
@Column(name="COM_STREET",length=30),
@Column(name="COM_CITY",length=30),
@Column(name="COM_PROVINCE",length=30),
@Column(name="COM_ZIPCODE",length=30)
})
publicAddressgetComAddress(){
returncomAddress;
}publicvoidsetComAddress(AddresscomAddress){
this.comAddress=comAddress;
}@Type(type = "com.usertype.GenderUserType")
@Column(name="sex",length=1)
publicGendergetGender(){
returngender;
}publicvoidsetGender(Gendergender){
this.gender=gender;
}@Type(type="com.usertype.AddressUserType")
@Columns(columns={
@Column(name="HOME_STREET",length=30),
@Column(name="HOME_CITY",length=30),
@Column(name="HOME_PROVINCE",length=30),
@Column(name="HOME_ZIPCODE",length=30)
})
publicAddressgetHomeAddress(){
returnhomeAddress;
}publicvoidsetHomeAddress(AddresshomeAddress){
this.homeAddress=homeAddress;
}@Id
@GeneratedValue(generator="CUSTOMERS_USERTYPE_SEQ")
publicIntegergetId(){
returnid;
}publicvoidsetId(Integerid){
this.id=id;
}@Type(type="com.usertype.NameCompositeUserType")
@Columns(columns={
@Column(name="FIRSTNAME",length=30),
@Column(name="LASTNAME",length=30)
})
publicNamegetName(){
returnname;
}publicvoidsetName(Namename){
this.name=name;
}@Type(type = "com.usertype.PhoneUserType")
@Column(name="phone",length=20)
publicIntegergetPhone(){
returnphone;
}publicvoidsetPhone(Integerphone){
this.phone=phone;
}}
2. DAO
package com.usertype.dao;
import java.io.Serializable;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.usertype.forms.Customers_UserType;
/**
*@projectclustering
*@authorxuchao
*@create_date2008-3-6
*@description
*/
publicclassCustomers_UserTypeImpDaoextendsHibernateDaoSupportimplements
Customers_UserTypeDao{
/*错误就在这里,执行Get方法的时候,报错*/
publicCustomers_UserTypegetCustomers_UserType(Serializableid){
return(Customers_UserType)getHibernateTemplate().get(Customers_UserType.class,id);
}
/*在做插入操作的时候,就可以正常执行.*/
publicvoidinsertCustomers_UserType(Customers_UserTypecustomers_UserType){
getHibernateTemplate().save(customers_UserType);
}
}