# org.hibernate.exception.SQLGrammarException: could not extract ResultSet"

**URL:** <https://community.ofelia.com/t/org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/9291>\
**Category:** Q&A\
**Created:** [8 October 2018 21:43 UTC](https://community.ofelia.com/t/org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/9291 "2018-10-08T21:43:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mehdimir](https://avatars.discourse-cdn.com/v4/letter/m/b77776/32.png) [@mehdimir](https://community.ofelia.com/u/mehdimir)\
**Post date:** [8 October 2018 21:43 UTC](https://community.ofelia.com/t/org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/9291/1 "2018-10-08T21:43:35Z")

</div>

hi  
I have used the likes as follows in JPQL query

```
SELECT c
FROM CarProperties c
WHERE
(c.pDateTime = :pDateTime or :pDateTime is NULL)
and (c.driverName like '%'||:driverName||'%' or :driverName is NULL) 
ORDER BY c.persistenceId ASC

```

this work in BonitaStudioTomcat and H2 DB  
But dont work in Tomcat bundle and PostgreSQL and raise Error :  
org.bonitasoft.engine.commons.exceptions.SRetryableException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

-----Tomcat log  
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying ~~ bytea  
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.  
Position: 744  
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)  
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)  
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)  
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)  
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)  
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)  
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)  
at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.lang.reflect.Method.invoke(Unknown Source)  
at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)  
at com.sun.proxy.$Proxy3.executeQuery(Unknown Source)  
at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.lang.reflect.Method.invoke(Unknown Source)  
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)  
at com.sun.proxy.$Proxy43.executeQuery(Unknown Source)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)  
… 142 more

2018-10-09 00:11:45.698 +0330 WARN: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 0, SQLState: 42883  
2018-10-09 00:11:45.699 +0330 ERROR: org.hibernate.engine.jdbc.spi.SqlExceptionHelper ERROR: operator does not exist: character varying ~~ bytea  
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.  
Position: 872  
2018-10-09 00:11:45.743 +0330 SEVERE: org.restlet.Component.BonitaRestletApplication Exception or error caught in server resource  
org.bonitasoft.engine.exception.BonitaRuntimeException: USERNAME=m.mousavi | org.bonitasoft.engine.commons.exceptions.SRetryableException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.wrapThrowable(ServerAPIImpl.java:148)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:136)  
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)  
at com.sun.proxy.$Proxy81.execute(Unknown Source)  
at org.bonitasoft.web.rest.server.api.bdm.BusinessDataQueryResource.getProcessBusinessDataQuery(BusinessDataQueryResource.java:64)  
at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.lang.reflect.Method.invoke(Unknown Source)  
at org.restlet.resource.ServerResource.doHandle(ServerResource.java:511)  
at org.restlet.resource.ServerResource.get(ServerResource.java:692)  
at org.restlet.resource.ServerResource.doHandle(ServerResource.java:439)  
at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:666)  
at org.restlet.resource.ServerResource.handle(ServerResource.java:1022)  
at org.restlet.resource.Finder.handle(Finder.java:236)  
at org.restlet.routing.Filter.doHandle(Filter.java:150)  
at org.restlet.routing.Filter.handle(Filter.java:197)  
at org.restlet.routing.Router.doHandle(Router.java:422)  
at org.restlet.routing.Router.handle(Router.java:641)  
at org.restlet.routing.Filter.doHandle(Filter.java:150)  
at org.restlet.routing.Filter.handle(Filter.java:197)  
at org.restlet.routing.Filter.doHandle(Filter.java:150)  
at org.restlet.routing.Filter.handle(Filter.java:197)  
at org.restlet.routing.Filter.doHandle(Filter.java:150)  
at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)  
at org.restlet.routing.Filter.handle(Filter.java:197)  
at org.restlet.routing.Filter.doHandle(Filter.java:150)  
at org.restlet.routing.Filter.handle(Filter.java:197)  
at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)  
at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:77)  
at org.restlet.Application.handle(Application.java:385)  
at org.bonitasoft.web.rest.server.BonitaRestletApplication.handle(BonitaRestletApplication.java:185)  
at org.restlet.routing.Filter.doHandle(Filter.java:150)  
at org.restlet.routing.Filter.handle(Filter.java:197)  
at org.restlet.routing.Router.doHandle(Router.java:422)  
at org.restlet.routing.Router.handle(Router.java:641)  
at org.restlet.routing.Filter.doHandle(Filter.java:150)  
at org.restlet.routing.Filter.handle(Filter.java:197)  
at org.restlet.routing.Router.doHandle(Router.java:422)  
at org.restlet.routing.Router.handle(Router.java:641)  
at org.restlet.routing.Filter.doHandle(Filter.java:150)  
at org.restlet.routing.Filter.handle(Filter.java:197)  
at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)  
at org.restlet.Component.handle(Component.java:408)  
at org.restlet.Server.handle(Server.java:507)  
at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63)  
at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143)  
at org.restlet.ext.servlet.ServerServlet.service(ServerServlet.java:1117)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)  
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)  
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)  
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:61)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.filter.NoCacheFilter.doFilter(NoCacheFilter.java:51)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:728)  
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470)  
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)  
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316)  
at org.bonitasoft.livingapps.LivingApplicationPageServlet.service(LivingApplicationPageServlet.java:70)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)  
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)  
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)  
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.filter.CacheFilter.proceedWithFiltering(CacheFilter.java:74)  
at org.bonitasoft.console.common.server.filter.ExcludingPatternFilter.doFilter(ExcludingPatternFilter.java:48)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.filter.ExcludingPatternFilter.excludePatternFiltering(ExcludingPatternFilter.java:53)  
at org.bonitasoft.console.common.server.filter.ExcludingPatternFilter.doFilter(ExcludingPatternFilter.java:46)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:61)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)  
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)  
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)  
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)  
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)  
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1468)  
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
at java.lang.Thread.run(Unknown Source)  
Caused by: org.bonitasoft.engine.commons.exceptions.SRetryableException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet  
at org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.findListByNamedQuery(JPABusinessDataRepositoryImpl.java:298)  
at org.bonitasoft.engine.business.data.impl.BusinessDataServiceImpl.getJsonQueryEntities(BusinessDataServiceImpl.java:303)  
at org.bonitasoft.engine.business.data.impl.BusinessDataServiceImpl.getJsonQueryEntities(BusinessDataServiceImpl.java:58)  
at org.bonitasoft.engine.command.GetBusinessDataByQueryCommand.execute(GetBusinessDataByQueryCommand.java:48)  
at org.bonitasoft.engine.command.GetBusinessDataByQueryCommand.execute(GetBusinessDataByQueryCommand.java:1)  
at org.bonitasoft.engine.api.impl.CommandAPIImpl.executeCommand(CommandAPIImpl.java:195)  
at org.bonitasoft.engine.api.impl.CommandAPIImpl.execute(CommandAPIImpl.java:167)  
at org.bonitasoft.engine.api.impl.CommandAPIImpl.execute(CommandAPIImpl.java:156)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.lang.reflect.Method.invoke(Unknown Source)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:462)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:431)  
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)  
… 107 more  
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet  
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)  
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)  
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458)  
at org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.findList(JPABusinessDataRepositoryImpl.java:319)  
at org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.findListByNamedQuery(JPABusinessDataRepositoryImpl.java:295)  
… 124 more  
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet  
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)  
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)  
at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)  
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)  
at org.hibernate.loader.Loader.doQuery(Loader.java:910)  
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)  
at org.hibernate.loader.Loader.doList(Loader.java:2554)  
at org.hibernate.loader.Loader.doList(Loader.java:2540)  
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)  
at org.hibernate.loader.Loader.list(Loader.java:2365)  
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)  
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)  
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)  
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)  
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)  
at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)  
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)  
… 126 more

---

<div class="post-metadata">

**Author:** ![claudia.avila\_141690](https://avatars.discourse-cdn.com/v4/letter/c/bc79bd/32.png) [@claudia.avila\_141690](https://community.ofelia.com/u/claudia.avila_141690)\
**Post date:** [11 March 2020 14:58 UTC](https://community.ofelia.com/t/org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/9291/2 "2020-03-11T14:58:40Z")

</div>

From what the log shows, the problem is more in Postgres also you must use the query directly in the database and verify that it works and that it returns the information you are requesting.

---

<div class="post-metadata">

**Author:** ![jacek\_grzelaczyk\_140](https://avatars.discourse-cdn.com/v4/letter/j/2acd7d/32.png) [@jacek\_grzelaczyk\_140](https://community.ofelia.com/u/jacek_grzelaczyk_140)\
**Post date:** [11 March 2020 11:58 UTC](https://community.ofelia.com/t/org-hibernate-exception-sqlgrammarexception-could-not-extract-resultset/9291/3 "2020-03-11T11:58:36Z")

</div>

I have the same problem. Bonita, could you answer or dou you need two extra years to answer to this?