org.artificer.common.error.ArtificerServerException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

Stack Overflow | user3560604 | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    DB2 ERRORCODE=-4461, SQLSTATE=42815 clob field

    Stack Overflow | 2 years ago | user3560604
    org.artificer.common.error.ArtificerServerException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

    Root Cause Analysis

    1. com.ibm.db2.jcc.am.SqlSyntaxErrorException

      [jcc][t4][1092][11644][4.15.113] Conversión de datos no válida: Tipo incorrecto de la columna de resultados para la conversión solicitada. ERRORCODE=-4461, SQLSTATE=42815

      at com.ibm.db2.jcc.am.fd.a()
    2. IBM DB2
      ResultSet.getClob
      1. com.ibm.db2.jcc.am.fd.a(fd.java:696)
      2. com.ibm.db2.jcc.am.fd.a(fd.java:60)
      3. com.ibm.db2.jcc.am.fd.a(fd.java:120)
      4. com.ibm.db2.jcc.am.jc.U(jc.java:2105)
      5. com.ibm.db2.jcc.am.ResultSet.getClob(ResultSet.java:1357)
      6. com.ibm.db2.jcc.am.ResultSet.getClob(ResultSet.java:1746)
      6 frames
    3. IronJacamar
      WrappedResultSet.getClob
      1. org.jboss.jca.adapters.jdbc.WrappedResultSet.getClob(WrappedResultSet.java:783)
      1 frame
    4. Hibernate
      QueryImpl.list
      1. org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:60)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      2. org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      3. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      4. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:261)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      5. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:251)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      6. org.hibernate.loader.hql.QueryLoader.getResultRow(QueryLoader.java:446)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      7. org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:747)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      8. org.hibernate.loader.Loader.processResultSet(Loader.java:949)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      9. org.hibernate.loader.Loader.doQuery(Loader.java:917)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      10. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      11. org.hibernate.loader.Loader.doList(Loader.java:2550)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      12. org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2395)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      13. org.hibernate.loader.Loader.list(Loader.java:2358)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      14. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      15. org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      16. org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      17. org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      18. org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)[hibernate-core-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      18 frames
    5. Hibernate EJB
      CriteriaQueryCompiler$3.getResultList
      1. org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268)[hibernate-entitymanager-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      2. org.hibernate.ejb.criteria.CriteriaQueryCompiler$3.getResultList(CriteriaQueryCompiler.java:254)[hibernate-entitymanager-4.2.17.Final-redhat-1.jar:4.2.17.Final-redhat-1]
      2 frames
    6. org.artificer.repository
      AbstractArtificerQueryImpl.executeQuery
      1. org.artificer.repository.hibernate.query.ArtificerToHibernateQueryVisitor.query(ArtificerToHibernateQueryVisitor.java:187)[artificer-repository-hibernate-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      2. org.artificer.repository.hibernate.query.HibernateQuery.executeQuery(HibernateQuery.java:93)[artificer-repository-hibernate-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      3. org.artificer.repository.hibernate.query.HibernateQuery.access$000(HibernateQuery.java:39)[artificer-repository-hibernate-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      4. org.artificer.repository.hibernate.query.HibernateQuery$1.doExecute(HibernateQuery.java:76)[artificer-repository-hibernate-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      5. org.artificer.repository.hibernate.query.HibernateQuery$1.doExecute(HibernateQuery.java:73)[artificer-repository-hibernate-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      6. org.artificer.repository.hibernate.HibernateUtil$HibernateTask.execute(HibernateUtil.java:73)[artificer-repository-hibernate-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      7. org.artificer.repository.hibernate.query.HibernateQuery.executeQuery(HibernateQuery.java:73)[artificer-repository-hibernate-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      8. org.artificer.repository.query.AbstractArtificerQueryImpl.executeQuery(AbstractArtificerQueryImpl.java:105)[artificer-repository-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      8 frames
    7. org.artificer.server
      QueryResource.queryFromPost
      1. org.artificer.server.QueryServiceImpl.query(QueryServiceImpl.java:76)[classes:]
      2. org.artificer.server.atom.services.AbstractFeedResource.createArtifactFeed(AbstractFeedResource.java:67)[classes:]
      3. org.artificer.server.atom.services.QueryResource.queryFromPost(QueryResource.java:113)[classes:]
      3 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[rt.jar:1.7.0_55]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[rt.jar:1.7.0_55]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[rt.jar:1.7.0_55]
      4. java.lang.reflect.Method.invoke(Method.java:606)[rt.jar:1.7.0_55]
      4 frames
    9. RESTEasy JAX-RS Implementation
      HttpServletDispatcher.service
      1. org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      2. org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      3. org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      4. org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      5. org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      6. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      7. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      8. org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      9. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      10. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
      10 frames
    10. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:847)[jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]
      1 frame
    11. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    12. org.artificer.repository
      ServletCredentialsFilter.doFilter
      1. org.artificer.repository.filter.ServletCredentialsFilter.doFilter(ServletCredentialsFilter.java:45)[artificer-repository-1.0.0.Final-redhat-4.jar:1.0.0.Final-redhat-4]
      1 frame
    13. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    14. org.overlord.commons
      SamlBearerTokenAuthFilter.doFilter
      1. org.overlord.commons.auth.filters.SamlBearerTokenAuthFilter.doFilterChain(SamlBearerTokenAuthFilter.java:264)[overlord-commons-auth-2.0.17.Final.jar:2.0.17.Final]
      2. org.overlord.commons.auth.filters.SamlBearerTokenAuthFilter.doFilter(SamlBearerTokenAuthFilter.java:238)[overlord-commons-auth-2.0.17.Final.jar:2.0.17.Final]
      2 frames
    15. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2 frames
    16. org.artificer.server
      LocaleFilter.doFilter
      1. org.artificer.server.filters.LocaleFilter.doFilter(LocaleFilter.java:59)[classes:]
      1 frame
    17. Glassfish Core
      AuthenticatorBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      5 frames
    18. JBoss Web
      LockingValve.invoke
      1. org.jboss.as.web.session.ClusteredSessionValve.handleRequest(ClusteredSessionValve.java:134)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      2. org.jboss.as.web.session.ClusteredSessionValve.invoke(ClusteredSessionValve.java:99)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      3. org.jboss.as.web.session.JvmRouteValve.invoke(JvmRouteValve.java:92)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      4. org.jboss.as.web.session.LockingValve.invoke(LockingValve.java:64)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      4 frames
    19. JPA
      WebNonTxEmCloserValve.invoke
      1. org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)[jboss-as-jpa-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      2. org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)[jboss-as-jpa-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      2 frames
    20. JBoss Web
      SecurityContextAssociationValve.invoke
      1. org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)[jboss-as-web-7.5.0.Final-redhat-17.jar:7.5.0.Final-redhat-17]
      1 frame
    21. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      4 frames
    22. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)[jbossweb-7.5.4.Final-redhat-1.jar:7.5.4.Final-redhat-1]
      3 frames
    23. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:744)[rt.jar:1.7.0_55]
      1 frame