SQL Exception in WAS-6

[Shachi Dogra]

Hi,

I am getting the following error in the WAS 6 environment however the same code exists in WAS 5 and it works perfectally without any error.
[[B]5/15/08 3:40:05:185 CDT] 00000062 SystemErr R com.ibm.db2.jcc.b.SqlException: An unexpected token "" was found following "". Expected tokens may include: "COMMIT PRESERVE ROWS".
at com.ibm.db2.jcc.b.sf.e(sf.java:1680)
at com.ibm.db2.jcc.b.sf.b(sf.java:1207)
at com.ibm.db2.jcc.c.jb.i(jb.java:225)
at com.ibm.db2.jcc.c.jb.b(jb.java:50)
at com.ibm.db2.jcc.c.w.b(w.java:36)
at com.ibm.db2.jcc.c.cc.e(cc.java:150)
at com.ibm.db2.jcc.b.sf.m(sf.java:1204)
at com.ibm.db2.jcc.b.sf.a(sf.java:1992)
at com.ibm.db2.jcc.b.sf.c(sf.java:566)
at com.ibm.db2.jcc.b.sf.executeUpdate(sf.java:551)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteUpdate(WSJdbcStatement.java:1235)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate(WSJdbcStatement.java:738)
at com.hewitt.connectivity.Conn.executeUpdate(Conn.java:273)
at com.hewitt.connectivity.Conn.executeUpdate(Conn.java:251)
at com.hewitt.listening.services.reportbuilder.SrvyReportGroupHandler.checkReportsAtGroupLevel(SrvyReportGroupHandler.java:968)
at com.hewitt.listening.controller.reportbuilder.ReportBuilderController.saveLinksAtReportGroupLevel(ReportBuilderController.java:2519)
at com.hewitt.listening.controller.reportbuilder.ReportBuilderController.process(ReportBuilderController.java:518)
at com.hewitt.listening.servlet.ControllerServlet.processRequest(ControllerServlet.java:283)
at com.hewitt.listening.servlet.ControllerServlet.doPost(ControllerServlet.java:183)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:762)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1924)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1471)[/B]


Please help me ASAP.. Thanks in Advance