無線&移動互聯(lián)網(wǎng)技術(shù)研發(fā)

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)

    at oracle.jdbc.driver.CharCommonAccessor.getLong(CharCommonAccessor.java:239)

    at oracle.jdbc.driver.OracleResultSetImpl.getLong(OracleResultSetImpl.java:514)

    at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1617)

    at org.hibernate.type.LongType.get(LongType.java:28)

    at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)

    at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)

    at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)

    at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2096)

    at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)

    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308)

    at org.hibernate.loader.Loader.getRow(Loader.java:1206)

    at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)

    at org.hibernate.loader.Loader.doQuery(Loader.java:701)

    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)

 

從異常中我們明確的能看到 org.hibernate.type.LongType.get(LongType.java:28)，這個(gè)表明了是LongType的異常。此時(shí)我們鎖定的目標(biāo)就是實(shí)體類的Long類型。

1. 檢查實(shí)體類的Long類型參數(shù)與數(shù)據(jù)庫中對應(yīng)的字段是否匹配

2. 如果檢查O-R對應(yīng)的字段類型沒問題，則考慮DB中數(shù)據(jù)是否有問題，Hibernate中，String類型的數(shù)據(jù)可以插入到Long類型中，可是在查詢時(shí)候?qū)o法轉(zhuǎn)型（詳細(xì)請了解Oracle的Long類型數(shù)據(jù)）