org.hibernate.exception.GenericJDBCException: could not execute query

hyperic.net | 5 months ago
  1. 0

    ConvertPermissionAlgorithm SQL syntax error

    GitHub | 3 years ago | zhurandy
    com.liferay.portal.convert.ConvertException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "Myportlet_WAR_Myportlet" Position: 361
  2. 0

    How use different postgresql schemas for EPP-SP 5.1 - Red Hat Customer Portal

    redhat.com | 7 months ago
    java.lang.RuntimeException: org.exoplatform.services.jcr.config.RepositoryConfigurationException: Database exception. org.postgresql.util.PSQLException: ERROR: relation "jcr_config" does not exist Position: 22
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Have documents for deploying steps?

    runawfe | 10 years ago | nobody
    ru.runa.af.InternalApplicationException: net.sf.hibernate.exception.GenericJDBCException: Unable to perform find
  5. 0

    A Question related to ocsp

    ejbca | 9 years ago | mzulqar
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: invalid regular expression: quantifier operand invalid

    at org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage(QueryExecutorImpl.java:557)
    2. org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:480)
    3. org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:364)
    4. org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:258)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
    7. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
    7 frames
  3. JBoss Application Server Connector
    WrappedPreparedStatement.executeQuery
    1. org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:76)
    2. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
    2 frames
  4. Hibernate
    CustomLoader.list
    1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:674)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    5. org.hibernate.loader.Loader.doList(Loader.java:2213)
    6. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    7. org.hibernate.loader.Loader.list(Loader.java:2099)
    8. org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
    8 frames
  5. Hibernate
    SQLQueryImpl.list
    1. org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
    2. org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
    3. org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
    3 frames
  6. org.hyperic.hq
    AppdefBossEJBImpl.search
    1. org.hyperic.hq.grouping.CritterTranslator.translate(CritterTranslator.java:56)
    2. org.hyperic.hq.bizapp.server.session.AppdefBossEJBImpl.findInventoryFromCBG(AppdefBossEJBImpl.java:2613)
    3. org.hyperic.hq.bizapp.server.session.AppdefBossEJBImpl.search(AppdefBossEJBImpl.java:2593)
    3 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1006.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    3. java.lang.reflect.Method.invoke(Unknown Source)
    3 frames
  8. JBoss Application Server Server
    StatelessSessionContainer$ContainerInterceptor.invoke
    1. org.jboss.invocation.Invocation.performCall(Invocation.java:345)
    2. org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
    2 frames
  9. JBoss Application Server Connector
    CachedConnectionInterceptor.invoke
    1. org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)
    1 frame
  10. JBoss Application Server Server
    StatelessSessionInstanceInterceptor.invoke
    1. org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)
    1 frame
  11. org.jboss.webservice
    ServiceEndpointInterceptor.invoke
    1. org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)
    1 frame
  12. JBoss Application Server Server
    CallValidationInterceptor.invoke
    1. org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
    1 frame
  13. org.hyperic.hq
    HQApp$Snatcher.invokeNext
    1. org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:510)
    2. org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:564)
    2 frames
  14. org.hyperic.txsnatch
    TxSnatch.invoke
    1. org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)
    1 frame
  15. JBoss Application Server Server
    TxInterceptorCMT.invoke
    1. org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
    2. org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
    3. org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
    3 frames
  16. org.hyperic.hq
    HQApp$Snatcher.invokeNext
    1. org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:510)
    2. org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:564)
    2 frames
  17. org.hyperic.txsnatch
    TxSnatch.invoke
    1. org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)
    1 frame
  18. JBoss Application Server Server
    Container.invoke
    1. org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
    2. org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
    3. org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
    4. org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
    5. org.jboss.ejb.Container.invoke(Container.java:873)
    5 frames
  19. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor476.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    3. java.lang.reflect.Method.invoke(Unknown Source)
    3 frames
  20. org.jboss.mx
    ReflectedDispatcher.invoke
    1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
    1 frame
  21. JBoss Application Server J2SE
    MBeanServerImpl.invoke
    1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
    2. org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
    3. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
    4. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
    4 frames
  22. JBoss Application Server Server
    InvokerInterceptor.invoke
    1. org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155)
    2. org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
    3. org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:179)
    4. org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:165)
    4 frames
  23. org.hyperic.hq
    HQApp$Snatcher.invokeProxyNext
    1. org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:506)
    2. org.hyperic.hq.application.HQApp$Snatcher.invokeProxyNext(HQApp.java:557)
    2 frames
  24. org.hyperic.txsnatch
    ProxySnatch.invoke
    1. org.hyperic.txsnatch.ProxySnatch.invoke(ProxySnatch.java:37)
    1 frame
  25. JBoss Application Server Server
    TransactionInterceptor.invoke
    1. org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
    1 frame
  26. org.hyperic.hq
    HQApp$Snatcher.invokeProxyNext
    1. org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:506)
    2. org.hyperic.hq.application.HQApp$Snatcher.invokeProxyNext(HQApp.java:557)
    2 frames
  27. org.hyperic.txsnatch
    ProxySnatch.invoke
    1. org.hyperic.txsnatch.ProxySnatch.invoke(ProxySnatch.java:37)
    1 frame
  28. JBoss Application Server Server
    ClientContainer.invoke
    1. org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
    2. org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97)
    3. org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
    3 frames
  29. Unknown
    $Proxy243.search
    1. $Proxy243.search(Unknown Source)
    1 frame
  30. org.hyperic.hq
    BaseRequestProcessor.processActionPerform
    1. org.hyperic.hq.ui.action.resource.hub.ResourceHubPortalAction.execute(ResourceHubPortalAction.java:315)
    2. org.hyperic.hq.ui.action.BaseRequestProcessor.processActionPerform(BaseRequestProcessor.java:63)
    2 frames
  31. struts
    ActionServlet.doPost
    1. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
    2. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
    3. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
    3 frames
  32. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    2 frames
  33. Glassfish Core
    ApplicationDispatcher.include
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
    4. org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
    5. org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
    5 frames
  34. struts
    ActionServlet.doPost
    1. org.apache.struts.tiles.UrlController.execute(UrlController.java:89)
    2. org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:219)
    3. org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:341)
    4. org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572)
    5. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221)
    6. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
    7. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
    7 frames
  35. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    2 frames
  36. Glassfish Core
    ApplicationDispatcher.forward
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
    4. org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
    5. org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
    6. org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
    6 frames
  37. struts
    ActionServlet.doPost
    1. org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
    2. org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
    3. org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
    4. org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
    5. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
    6. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
    7. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
    7 frames
  38. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    2 frames
  39. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  40. org.hyperic.hq
    AuthenticationFilter.doFilter
    1. org.hyperic.hq.ui.AuthenticationFilter.doFilter(AuthenticationFilter.java:143)
    1 frame
  41. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  42. org.hyperic.hibernate
    SessionFilter$1.run
    1. org.hyperic.hibernate.filter.SessionFilter$1.run(SessionFilter.java:59)
    1 frame
  43. org.hyperic.hq
    SessionManager.runInSession
    1. org.hyperic.hq.hibernate.SessionManager.runInSessionInternal(SessionManager.java:79)
    2. org.hyperic.hq.hibernate.SessionManager.runInSession(SessionManager.java:68)
    2 frames
  44. org.hyperic.hibernate
    SessionFilter.doFilter
    1. org.hyperic.hibernate.filter.SessionFilter.doFilter(SessionFilter.java:57)
    1 frame
  45. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  46. JBoss Application Server Tomcat
    ReplyHeaderFilter.doFilter
    1. org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    1 frame
  47. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  48. org.hyperic.hq
    JMXFilter.doFilter
    1. org.hyperic.hq.product.servlet.filter.JMXFilter.doFilter(JMXFilter.java:324)
    1 frame
  49. Glassfish Core
    StandardContextValve.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    4 frames
  50. JBoss Application Server Tomcat
    JaccContextValve.invoke
    1. org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    2. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
    3. org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    3 frames
  51. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    4 frames
  52. Grizzly HTTP
    MasterSlaveWorkerThread.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    4. org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    4 frames
  53. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame