Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: error regarding calling db2 storedprocedure on java side

    all Viewers,
    i written one procedure using ibm workbench.it return all values in workbench tool.but in java side iam calling that procedure.it returns below error.
    --------***any body Please help me ***---------


    com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][1061][10303] Escape syntax error. See attached Throwable for details.
    com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][1061][10303] Escape syntax error. See attached Throwable for details.
    at com.ibm.db2.jcc.c.p.c(p.java:573)
    at com.ibm.db2.jcc.c.fg.m(fg.java:2456)
    at com.ibm.db2.jcc.c.gg.b(gg.java:222)
    at com.ibm.db2.jcc.c.gg.<init>(gg.java:204)
    at com.ibm.db2.jcc.c.hg.<init>(hg.java:50)
    at com.ibm.db2.jcc.b.xb.<init>(xb.java:80)
    at com.ibm.db2.jcc.b.b.b(b.java:1738)
    at com.ibm.db2.jcc.c.p.a(p.java:1553)
    at com.ibm.db2.jcc.c.p.prepareCall(p.java:503)
    at com.karishma.twofieldmaster.TwoFieldMasterDAO.getL istDetails(TwoFieldMasterDAO.java:80)
    at com.karishma.twofieldmaster.TwoFieldMaster.getList Details(TwoFieldMaster.java:72)
    at com.karishma.twofieldmaster.TwoFieldMaster.service (TwoFieldMaster.java:30)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
    at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
    at org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:368)
    at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: com.ibm.db2.jcc.c.h: [ibm][db2][jcc][1064][10658] Unrecognized keyword in escape clause: SP_GBL_GETTWOFIELDMASTERDATA(?,?,?,?,?).
    at com.ibm.db2.jcc.c.hb.a(hb.java:51)
    at com.ibm.db2.jcc.c.hb.a(hb.java:119)
    at com.ibm.db2.jcc.c.p.c(p.java:570)
    ... 29 more
    in list

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Please provide DB2 version and OS. Also provide SP code (at least name and parameters) and the java code you are using to make the call.

    Andy

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have you tried what the message tells you to do: See attached Throwable for details.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •