Could not read the data

[Gundeti Reddy]

HI All,
I am getting below ClassCastException only for particular data.It is working fine with other data.I could not able to understand whats wrong with my mapping files.If anyone cameacrross these types of problems please help me.I am using Hibernate 2.1.1

1.The Mapping for that coloumn in my hbm file is like below
<property
name="assetNum"
type="long"
column="ASSET_NUM"
not-null="true"
length="15"
/>

2. The Exception that i am getting is,
java.lang.ClassCastException: java.lang.Long incompatible with java.lang.Short
at net.sf.hibernate.type.ShortType.set(ShortType.java:30)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:48)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:35)
at net.sf.hibernate.loader.Loader.bindPositionalParameters(Loader.java:673)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:712)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:184)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:132)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:830)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:850)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:57)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:49)
at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:420)
at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2044)
at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1918)
at net.sf.hibernate.impl.SessionImpl.internalLoadOneToOne(SessionImpl.java:1872)
at net.sf.hibernate.type.OneToOneType.resolveIdentifier



Thnaks,
Gundeti.

[Carl Sayres]

We'd need to see your Java object to be sure, but most likely you declared assetNum as a Short (or short). Change it to a Long (or change your xml mapping to a short). The xml mapping needs to be consistent with the actual data type.

Carl

[Gundeti Reddy]

asset_num filed is delcared as required. But i am getting this exception only for particula data.
Please see the below code which says how i am using,

 
public List loadAutoPayAssetsByAssetNumber(long assetNumber) 
                throws BusinessException { 
 
                logger.info( 
                        "Entering loadAssetHoldersByAssetNumber(long assetNumber)" 
                                + " with asset num : " 
                                + assetNumber 
                                + "asset domain code = " 
                                + EpayCommonConstants.DOMAIN_CD_AP); 
 
                AssetHolder asset = null; 
                List assets = new ArrayList(); 
                Type types[] = { Hibernate.LONG, Hibernate.STRING }; 
                Object values[] = 
                        { new Long(assetNumber), EpayCommonConstants.DOMAIN_CD_AP }; 
 
                List assetList = 
                        getObjs( 
                                "select {asset} from AssetHolder {asset}" 
                                        + " where ({asset}.assetNum = ? )" 
                                        + " and {asset}.assetDomainCd = ?" 
                                        + " order by {asset}.assetId desc", 
                                values, 
                                types); 
 
                if (assetList == null 
                        || assetList.isEmpty() 
                        || (assetList.get(0) == null)) { 
 
                        logger.debug( 
                                "Result list is null*** . No Asset found " + assetNumber); 
 
                        assets = null; 
                } else { 
                        logger.debug("Result set found for Asset Number:" + assetNumber); 
 
                        for (int i = 0; i < assetList.size(); i++) { 
                                assets.add(assetList.get(i)); 
                        } 
                } 
 
                logger.info("Exiting loadAssetHoldersByAssetNumber(long assetNumber)"); 
 
                return assets; 
        }

[ Edited to use code tags - Paul Sturrock ]
[ September 25, 2008: Message edited by: Paul Sturrock ]

[Carl Sayres]

Perhaps you are getting the exception only when the value is too wide to fit in a short.

Post your POJO (java class) and complete XML mapping.

Carl

[Gundeti Reddy]

We are passing only long values to assetNum filed but somehow hibernate is converting it into short type.Thats why i am getting this exception. This problem occuring only for few valuses.For example if pass the value 10000970 for assetNum field, the hibernate is trying to convert it to short type.

1.For your reference the POJO class is

 
/** persistent field */
private long _assetNum;
 
/** persistent field */
private java.lang.String _assetTypeCd;
 
/** nullable persistent field */
private String _quoteId;
 
/** persistent field - Billing Enhancement */
private String _policyNum;
 
/** persistent field - LRP */
private short _compId;
 
/** nullable persistent field */
private int _partitionId;
 
/** persistent field */
private Date _createTs;
 
/** nullable persistent field */
private Date _updateTs;

/** persistent field */
private Set _financialAccts;
 
/** persistent field */
private Set _autopayMemberHistory;
 
/** persistent field */
private Set _assetDiaries;
 
/** persistent field */
private Set _autoPayAgreement;
 
/** persistent field */
private Set _enrollmentInfo;
 
/** nullable persistent field */
private com.i21.epay.model.AssetLock _assetLock;
 
/** persistent field */
private Set _noticeWaivers;

2. The hbm file is,

 
<<AssetHolder.hbm.xml.txt>> <?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
     
<hibernate-mapping>
<meta
attribute="extends">com.insurance21.framework.service.BusinessObject</me
ta>
 
<!--
    Created by Middlegen Hibernate plugin
 
    <a href="http://boss.bekk.no/boss/middlegen/" target="_blank" rel="nofollow">http://boss.bekk.no/boss/middlegen/</a>
    <a href="http://hibernate.sourceforge.net/" target="_blank" rel="nofollow">http://hibernate.sourceforge.net/</a>
-->
 
<class
    name="com.i21.epay.model.AssetHolder"
    table="EFDEV1.TEFME01"
>
    <id
        name="assetId"
        type="long"
        column="ASSET_ID"
    >
    <generator class="assigned" />
    </id>
 
    <property
        name="assetNum"
        type="long"
        column="ASSET_NUM"
        not-null="true"
        length="15"
    />
    <property
        name="assetTypeCd"
        type="java.lang.String"
        column="ASSET_TYPE_CD"
        not-null="true"
        length="3"
    />
    <property
        name="assetDomainCd"
        type="java.lang.String"
        column="ASSET_DOMAIN_CD"
        length="3"
    />
    <property
        name="quoteId"
        type="java.lang.String"
        column="QUOTE_ID"
        length="16"
       
    />
    <property
        name="partitionId"
        type="int"
        column="PARTITION_ID"
        length="4"
    />
    <property
        name="createTs"
        type="java.sql.Timestamp"
        column="CREATE_TS"
        not-null="true"
        length="10"
    />
    <property
        name="updateTs"
        type="java.sql.Timestamp"
        column="UPDATE_TS"
        length="10"
    />
 
      <property
        name="state"
        type="java.lang.String"
        column="STATE_CD"
        not-null="true"
        length="3"
    />
   <!-- Added by Ratna Billing Enhancement -->
    <property
        name="policyNum"
        type="java.lang.String"
        column="POLICY_NUMBER"
        length="16"
    />
   
     <property
        name="compId"
        type="short"
        column="COMP_ID"
        not-null="true"
    />
 <property
        name="affinityAcctCD"
        type="java.lang.String"
        column="AFFINITY_ACCT_CD"
                length="4"
    />
    <!-- associations -->
    <!-- bi-directional one-to-many association to Financial Accts -->
    <set name="financialAccts" lazy="true" inverse="true" cascade="all"
sort="com.i21.epay.model.BOComparator">
        <key> <column name="ASSET_ID"/> </key>
        <one-to-many  class="com.i21.epay.model.FinancialAccountInfo" />
    </set>
 
        <!-- bi-directional one-to-many association to Member History
-->
    <set name="autopayMemberHistory" lazy="true" inverse="true"
cascade="all" sort="com.i21.epay.model.BOComparator" >
        <key> <column name="ASSET_ID"/> </key>
        <one-to-many  class="com.i21.epay.model.AutoPayMemberHistory" />
    </set>
 
        <!-- bi-directional one-to-many association to Asset Diary -->
    <set name="assetDiaries" lazy="true" inverse="true" cascade="all"
sort="com.i21.epay.model.BOComparator">
        <key> <column name="ASSET_ID"/> </key>
        <one-to-many  class="com.i21.epay.model.AssetDiary" />
    </set>
 
        <!-- bi-directional one-to-many association to Agreement -->
    <set name="autoPayAgreement" lazy="true" inverse="true"
cascade="all" sort="com.i21.epay.model.BOComparator">
        <key> <column name="ASSET_ID"/> </key>
        <one-to-many  class="com.i21.epay.model.AutoPayAgreement" />
    </set>
 
 
        <!-- associations one-to-many with Missing Enrollment Info -->
    <set name="enrollmentInfo" lazy="true" inverse="true" cascade="all"
sort="com.i21.epay.model.BOComparator">
        <key> <column name="ASSET_ID"/> </key>
        <one-to-many  class="com.i21.epay.model.EnrollmentInfo" />
    </set>
 
    <!-- bi-directional one-to-many association to Financial Accts -->
    <set name="noticeWaivers" lazy="true" inverse="true" cascade="all"
sort="com.i21.epay.model.BOComparator">
        <key> <column name="ASSET_ID"/> </key>
        <one-to-many  class="com.i21.epay.model.NoticeWaiver" />
    </set>
 
    <!-- associations one-to-one with AssetLock -->
        <one-to-one name="assetLock"
class="com.i21.epay.model.AssetLock" cascade="save-update"/>
       
        <!-- associations one-to-one with CompanyInfo -->
        <one-to-one name="companyInfo"
class="com.i21.epay.model.CompanyInfo"/>
       
       
</class>
</hibernate-mapping>

[ Edited to use code tags - Paul Sturrock ]
[ September 25, 2008: Message edited by: Paul Sturrock ]

[Gundeti Reddy]

Its urgent.any help on this.