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

  1. 0

    DB2 ERRORCODE=-4461, SQLSTATE=42815 clob field

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

    connection error with db2 jdbc

    Stack Overflow | 6 months ago | Mr Smith
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][3.63.75] Invalid database URL syntax: jdbc:db2:/dxxx_xxx.xxx.com:5000/XXXXX:deferPrepares=false. ERRORCODE=-4461, SQLSTATE=42815
  3. 0

    PreparedStatementCallback; bad SQL grammar in JDBC Spring

    Stack Overflow | 4 years ago | Ashish
    org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [update product.typecategory set taxonomydescription = ? where taxonomydescription = ?]; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10824][4.13.127] Invalid data conversion: Parameter instance [Ljava.lang.Object;@1dc421 is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Parameter instance recId is invalid for the requested conversion. ERRORCODE=-4461

    Stack Overflow | 4 months ago | User45
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.13.80] Invalid data conversion: Parameter instance REC_ID is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815
  6. 0

    SQDR Plus Troubleshooting Tips

    starquest.com | 1 year ago
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][3.65.77] Invalid data conversion: Parameter instance ?1?0.?00 is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815

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