Uploaded image for project: 'apiman (API Management)'
  1. apiman (API Management)
  2. APIMAN-1130

SqlException when accessing API published to JDBC gateway

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 1.2.6.Final, 1.2.x
    • 1.2.4.Final
    • None

      Simple public API

      {"responseCode":500,"message":" Bad value for type long : 
      {\"publicAPI\":true,\"organizationId\":\"qe\",\"apiId\":\"foo\",\"version\":\"1.0\",\"endpoint\":\"http://10.8.49.50:8082/qa/echo\",\"endpointType\":\"rest\",\"endpointContentType\":\"json\",\"endpointProperties\":{},\"apiPolicies\":[]} Query: SELECT bean FROM gw_apis WHERE org_id = ? AND id = ? AND version = ? Parameters: [qe, foo, 1.0]","trace":"java.sql.SQLException: Bad value for type long : {\"publicAPI\":true,\"organizationId\":\"qe\",\"apiId\":\"foo\",\"version\":\"1.0\",\"endpoint\":\"http://10.8.49.50:8082/qa/echo\",\"endpointType\":\"rest\",\"endpointContentType\":\"json\",\"endpointProperties\":{},\"apiPolicies\":[]} Query: SELECT bean FROM gw_apis WHERE org_id = ? AND id = ? AND version = ? Parameters: [qe, foo, 1.0]
      	at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:393)
      	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:351)
      	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:289)
      	at io.apiman.gateway.engine.jdbc.JdbcRegistry.getApiInternal(JdbcRegistry.java:243)
      	at io.apiman.gateway.engine.jdbc.CachingJdbcRegistry.getApi(CachingJdbcRegistry.java:134)
      	at io.apiman.gateway.engine.jdbc.CachingJdbcRegistry.getApi(CachingJdbcRegistry.java:113)
      	at io.apiman.gateway.engine.impl.SecureRegistryWrapper.getApi(SecureRegistryWrapper.java:110)
      	at io.apiman.gateway.engine.impl.ApiRequestExecutorImpl.execute(ApiRequestExecutorImpl.java:252)
      	at io.apiman.gateway.platforms.servlet.GatewayServlet.doAction(GatewayServlet.java:179)
      	at io.apiman.gateway.platforms.servlet.GatewayServlet.service(GatewayServlet.java:79)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
      	at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
      	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
      	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
      	at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
      	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
      	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
      	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
      	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
      	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
      	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
      	at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
      	at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
      	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      	at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
      	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:285)
      	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:264)
      	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
      	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:175)
      	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202)
      	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:792)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      "}
      

              ewittman@redhat.com Eric Wittmann
              jcechace@redhat.com Jakub Čecháček
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: