GenericJDBCException: could not execute query??? add_months

lalith · **Posted:** Fri Sep 22, 2006 7:36 am

Hi,

Code:

List lst = session.createQuery("select add_months(ep.meetingDate,12)-1  from EpPmsPtlDtls ep where ep.ptlDtlsId="+ptlDtlsId).list();

I got the following exception with the above code.

Code:

at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateC
onverter.java:91)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43
)
        at org.hibernate.loader.Loader.doList(Loader.java:2150)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
        at org.hibernate.loader.Loader.list(Loader.java:2021)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:137)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1014)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at com.ksi.ep.dao.pms.persistence.hibernate.ProtocolReviewDAOImpl.getExpireDate(Pr
otocolReviewDAOImpl.java:477)
        ... 23 more
Caused by: java.sql.SQLException: Invalid column type: getInt not implemented for class or
acle.jdbc.driver.T4CDateAccessor
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:358)

Can any one look into it once and tell me the problem & solution.?

I am using hibernate 3.1 version.But i am able to get the result in hibernate ide tools.

Thanks in Advance,
LALITH

[/quote]

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

Code:

SQLQuery query = session.createSQLQuery("select add_months(ep.meetingDate,12)-1  from EpPmsPtlDtls ep where ep.ptlDtlsId= :ptlDtlsId");

query.setString("ptlDtlsId", ptlDtlsId);
query.list();

lalith · **Posted:** Mon Sep 25, 2006 3:57 am

Hi Pasha,

It is working fine with to_char(..). See the following query:

Code:

protocolList =session.createQuery("select to_char(add_months(ep.meetingDate,12)-1,'MM/dd/yyyy')  " +
               " from EpPmsPtlDtls ep where ep.ptlDtlsId="+ptlDtlsId).list();

Thanks,
LALITH