Originally posted by sejal naik: If i run then same query on winSql its working fine but with JDBC not working.
If query is runnign on winsql then It may be possible that you have error in query formation in JDBC. Put the code here, Just for confirmation If I am not wrong winsql runs on odbc.
Shailesh
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
com.sybase.jdbc2.jdbc.SybSQLException: The identifier that starts with '"T3211PU,,insert into Illustr' is too long. Maximum length is 28.
[4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2408) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java(Compiled Code)) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.sybase.jdbc2.jdbc.SybStatement.executeLoop(SybStatement.java:1535) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1527) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:742) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.dcx.catl.macscompiler.util.CommonDataAccessManager.execQueryRetState(CommonDataAccessManager.java:759) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.dcx.catl.macscompiler.bo.RemoveIllustrationJavaBean.execute(RemoveIllustrationJavaBean.java:414) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.dcx.catl.macscompiler.ao.RemoveIllustrationAction.execute(RemoveIllustrationAction.java:219) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:948) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:530) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) [4/27/05 17:02:50:031 IST] 575ee900 SystemErr R [4/27/05 17:02:50:031 IST] 575ee900 SystemOut O SQLException: The identifier that starts with '"T3211PU,,insert into Illustr' is too long. Maximum length is 28.
