sri rao
asked on
java.sql.SQLException: ORA-00997: illegal use of LONG datatype + Hibernate
While running a Hibernate's Update query ex, i'm getting the following exception.....
org.hibernate.exception.SQ LGrammarEx ception: could not load an entity: [Contact#2]
at org.hibernate.exception.SQ LStateConv erter.conv ert(SQLSta teConverte r.java:67)
at org.hibernate.exception.JD BCExceptio nHelper.co nvert(JDBC ExceptionH elper.java :43)
at org.hibernate.loader.Loade r.loadEnti ty(Loader. java:1874)
at org.hibernate.loader.entit y.Abstract EntityLoad er.load(Ab stractEnti tyLoader.j ava:48)
at org.hibernate.loader.entit y.Abstract EntityLoad er.load(Ab stractEnti tyLoader.j ava:42)
at org.hibernate.persister.en tity.Abstr actEntityP ersister.l oad(Abstra ctEntityPe rsister.ja va:3044)
at org.hibernate.event.def.De faultLoadE ventListen er.loadFro mDatasourc e(DefaultL oadEventLi stener.jav a:395)
at org.hibernate.event.def.De faultLoadE ventListen er.doLoad( DefaultLoa dEventList ener.java: 375)
at org.hibernate.event.def.De faultLoadE ventListen er.load(De faultLoadE ventListen er.java:13 9)
at org.hibernate.event.def.De faultLoadE ventListen er.proxyOr Load(Defau ltLoadEven tListener. java:195)
at org.hibernate.event.def.De faultLoadE ventListen er.onLoad( DefaultLoa dEventList ener.java: 103)
at org.hibernate.impl.Session Impl.fireL oad(Sessio nImpl.java :878)
at org.hibernate.impl.Session Impl.get(S essionImpl .java:815)
at org.hibernate.impl.Session Impl.get(S essionImpl .java:808)
at UpdateQuery_Hib.main(Updat eQuery_Hib .java:35)
Caused by: java.sql.SQLException: ORA-00997: illegal use of LONG datatype
at oracle.jdbc.dbaccess.DBErr or.throwSq lException (DBError.j ava:134)
at oracle.jdbc.ttc7.TTIoer.pr ocessError (TTIoer.ja va:289)
at oracle.jdbc.ttc7.Oall7.rec eive(Oall7 .java:573)
at oracle.jdbc.ttc7.TTC7Proto col.doOall 7(TTC7Prot ocol.java: 1891)
at oracle.jdbc.ttc7.TTC7Proto col.parseE xecuteDesc ribe(TTC7P rotocol.ja va:830)
at oracle.jdbc.driver.OracleS tatement.d oExecuteQu ery(Oracle Statement. java:2391)
at oracle.jdbc.driver.OracleS tatement.d oExecuteWi thTimeout( OracleStat ement.java :2672)
at oracle.jdbc.driver.OracleP reparedSta tement.exe cuteUpdate (OraclePre paredState ment.java: 589)
at oracle.jdbc.driver.OracleP reparedSta tement.exe cuteQuery( OraclePrep aredStatem ent.java:5 27)
at org.hibernate.jdbc.Abstrac tBatcher.g etResultSe t(Abstract Batcher.ja va:186)
at org.hibernate.loader.Loade r.getResul tSet(Loade r.java:178 7)
at org.hibernate.loader.Loade r.doQuery( Loader.jav a:674)
at org.hibernate.loader.Loade r.doQueryA ndInitiali zeNonLazyC ollections (Loader.ja va:236)
at org.hibernate.loader.Loade r.loadEnti ty(Loader. java:1860)
org.hibernate.exception.SQ
at org.hibernate.exception.SQ
at org.hibernate.exception.JD
at org.hibernate.loader.Loade
at org.hibernate.loader.entit
at org.hibernate.loader.entit
at org.hibernate.persister.en
at org.hibernate.event.def.De
at org.hibernate.event.def.De
at org.hibernate.event.def.De
at org.hibernate.event.def.De
at org.hibernate.event.def.De
at org.hibernate.impl.Session
at org.hibernate.impl.Session
at org.hibernate.impl.Session
at UpdateQuery_Hib.main(Updat
Caused by: java.sql.SQLException: ORA-00997: illegal use of LONG datatype
at oracle.jdbc.dbaccess.DBErr
at oracle.jdbc.ttc7.TTIoer.pr
at oracle.jdbc.ttc7.Oall7.rec
at oracle.jdbc.ttc7.TTC7Proto
at oracle.jdbc.ttc7.TTC7Proto
at oracle.jdbc.driver.OracleS
at oracle.jdbc.driver.OracleS
at oracle.jdbc.driver.OracleP
at oracle.jdbc.driver.OracleP
at org.hibernate.jdbc.Abstrac
at org.hibernate.loader.Loade
at org.hibernate.loader.Loade
at org.hibernate.loader.Loade
at org.hibernate.loader.Loade
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.