[pravin]

Hi,

I am trying to create sample application with oracle. I am using ojdbc6.jar as oracle driver in my application. Server is starting sussfully butafter access pages it is giving following error. I dont have any blob column in my tables.

2010-10-07 09:02:46,421 WARN [http-8080-3] JDBCExceptionReporter – SQL Error: 17004, SQLState: 99999
2010-10-07 09:02:46,421 ERROR [http-8080-3] JDBCExceptionReporter – Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CTimestampAccessor
Oct 7, 2010 9:02:46 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet MIDMAPPING Servlet threw exception
java.sql.SQLException: Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CTimestampAccessor
at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:412)
at oracle.jdbc.driver.Accessor.getBLOB(Accessor.java:1270)
at oracle.jdbc.driver.OracleResultSetImpl.getBLOB(OracleResultSetImpl.java:1591)
at oracle.jdbc.driver.OracleResultSetImpl.getBlob(OracleResultSetImpl.java:553)
at oracle.jdbc.driver.OracleResultSet.getBlob(OracleResultSet.java:380)
at org.hibernate.type.ByteArrayBlobType.get(ByteArrayBlobType.java:87)
at org.hibernate.type.AbstractLobType.nullSafeGet(AbstractLobType.java:46)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2091)
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:2217)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108)
at org.hibernate.loader.Loader.list(Loader.java:2103)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:340)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1122)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)
at com.mid.dao.ChromeMakeDAOImpl.findAllChromeMakes(ChromeMakeDAOImpl.java:199)
at com.mid.dao.ChromeMakeDAOImpl.findAllChromeMakes(ChromeMakeDAOImpl.java:187)

[davemeurer]

Hello,

We do have an open bug report with this error. This is due to timestamp data types in oracle and how hibernate treats them when they are reverse engineered into java.

One possible workaround is to remove the LOB annotation that is in the domain object for that field.

Another workaround is described in this thread: https://forum.hibernate.org/viewtopic.php?p=2398745

HTH,
Dave

[Author]

Posts