javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query


Solutions on the web

Solution icon of web
org.hibernate.exception.GenericJDBCException: could not execute query

Solution icon of googlegroups
via Google Groups by Steve McLeod, 9 months ago
org.hibernate.exception.GenericJDBCException: could not execute query

Solution icon of web
via gmane.org by Unknown author, 1 year ago
org.hibernate.exception.GenericJDBCException: could not execute query

Solution icon of coderanch
via Coderanch by Emmanuel Garcia, 10 months ago
org.hibernate.exception.GenericJDBCException: could not execute query

Solution icon of hibernate
via Hibernate JIRA by Rachit, 1 year ago
org.hibernate.exception.GenericJDBCException: could not execute query

Solution icon of hibernate
via Hibernate JIRA by Rachit, 1 year ago
org.hibernate.exception.GenericJDBCException: could not execute query

Solution icon of oraclecommunity
via Oracle Community by 707610, 1 year ago
org.hibernate.exception.GenericJDBCException: could not execute query

Solution icon of web
org.hibernate.exception.GenericJDBCException: could not execute query

Solution icon of web
via com.br by Unknown author, 1 year ago
org.hibernate.exception.GenericJDBCException: could not execute query

Stack trace

javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
	at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
	at com.j2anywhere.addressbookserver.SyncService.fetchRecords(SyncService.java:203)
	at com.j2anywhere.addressbookserver.CentralAddressBook.fetchRecords(CentralAddressBook.java:79)
	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:597)
	at com.sun.xml.ws.server.PeptTie._invoke(PeptTie.java:58)
	at com.sun.xml.ws.protocol.soap.server.SOAPMessageDispatcher.invokeEndpoint(SOAPMessageDispatcher.java:278)
	at com.sun.xml.ws.protocol.soap.server.SOAPMessageDispatcher$SoapInvoker.invoke(SOAPMessageDispatcher.java:586)
	at com.sun.xml.ws.protocol.soap.server.SOAPMessageDispatcher.receive(SOAPMessageDispatcher.java:141)
	at com.sun.xml.ws.server.Tie.handle(Tie.java:88)
	at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.handle(WSServletDelegate.java:333)
	at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:288)
	at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:77)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:637)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2235)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
	at org.hibernate.loader.Loader.list(Loader.java:2124)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
	... 30 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:

select emailaddre0_.identifier as identifier3_, emailaddre0_.changeType as changeType3_, emailaddre0_.updatedOn as updatedOn3_, emailaddre0_.CONTACTIDENTIFIER as CONTACTI7_3_, emailaddre0_.label as label3_, emailaddre0_.type as type3_, emailaddre0_.value as value3_ from EmailAddresses emailaddre0_ where emailaddre0_.updatedOn>? and emailaddre0_.changeType<>? [50000-128]
	at org.h2.message.Message.getSQLException(Message.java:110)
	at org.h2.message.Message.convert(Message.java:287)
	at org.h2.message.Message.convert(Message.java:248)
	at org.h2.command.Command.executeQuery(Command.java:134)
	at org.h2.server.TcpServerThread.process(TcpServerThread.java:283)
	at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
	... 1 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
	at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:310)
	at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:103)
	at org.h2.index.PageDataCursor.next(PageDataCursor.java:55)
	at org.h2.index.IndexCursor.next(IndexCursor.java:184)
	at org.h2.table.TableFilter.next(TableFilter.java:279)
	at org.h2.command.dml.Select.queryFlat(Select.java:491)
	at org.h2.command.dml.Select.queryWithoutCache(Select.java:558)
	at org.h2.command.dml.Query.query(Query.java:243)
	at org.h2.command.CommandContainer.query(CommandContainer.java:81)
	at org.h2.command.Command.executeQuery(Command.java:132)
	... 3 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 1 year ago