小弟是想问关于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);

}

}