GenericJDBCException « Query « JPA Q&A

  1. JPA Q&A
  2. Query
  3. GenericJDBCException




1. Hibernate 2 - joins - net.sf.hibernate.exception.GenericJDBCException: Could not execute query    coderanch.com

2. org.hibernate.exception.GenericJDBCException: could not execute query    coderanch.com

Hi, below are our environment details: jdk1.5.0_14, Hibernate-3.2.6, WebLogic Server- 9.2.2.0 DB2 v9.1.6 we have an issue where we get org.hibernate.exception.GenericJDBCException: could not execute query when we try to execute query using either org.hibernate.Criteria.list() or org.hibernate.Query.list() its weird that this doesn't happen always, any suggestion would be appreciated. stack trace FATAL - caught HibernateException during user search [org.hibernate.exception.GenericJDBCException: could not execute ...

3.  error GenericJDBCException    forum.hibernate.org

Using I get this error .Any idea? net.sf.hibernate.exception.GenericJDBCException: error performing findBySQL at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30) at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4110) at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3858) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) at rt11000.printdocument.dao.PrintableDataDAO.findPrintableData(PrintableDataDAO.java:52) at rt11000.printdocument.PrintManagerHibernateImpl.retrievePrintableData(PrintManagerHibernateImpl.java:38) at rt11000.printdocument.Transformer.main(Transformer.java:231) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78) Caused by: java.sql.SQLException: Token SQL92 non supportato nella posizione: 43: dpd at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130) at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java:202) at ...

4. Hibernate2.0 - GenericJDBCException: Could not execute query    forum.hibernate.org

The following code returns a list & will be used in a JSP, If the same JSP page is refreshed or if I use pagination which gets the lookup data, the above query returns an error: (for 2 or 3 times no error occurs) code:: Query query = session.createQuery("from LookupsDTO l order by l.lookupsPK.codeGroup, l.m_seq"); List lookups = query.list(); LOOKUP mapping ...

5. GenericJDBCException: could not execute query    forum.hibernate.org

Hi, I am using Hibernate with MySQL database on tomcat. If application kept ideal for some time, then I get following exception. " org.hibernate.exception.GenericJDBCException: could not execute query " And then all data access fails and this continues until I restart Tomcat. Is it caused by timeout? Is there any parameter which control this? Thanks Sameer

6. GenericJDBCException: could not execute query??? add_months    forum.hibernate.org

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) ...

7. org.hibernate.exception.GenericJDBCException: could not execute query    forums.oracle.com

Hi All, I am developing a web service using Java 1.6 , Hibernate 3.0 , Axis 1.4 and Tomcat Apache 5.5. My issue is that when i work with the "createCriteria" queries they works fine. But when i use "createSQLQuery" it raise the following exception "org.hibernate.exception.GenericJDBCException: could not execute query" and also some times without doing anyting code starts working but ...