File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

maximum length of identitifer in Sybase for insert query

 
Hd Desai
Ranch Hand
Posts: 65
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am using Sybase 12.0 with JConnect 5.

I am facing some problem with insert query.

It gives exception like " identitifer is too long maximum length is 30"

If i run then same query on winSql its working fine but with JDBC not working.

Pls help me reagrding this.
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Hd Desai
Ranch Hand
Posts: 65
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

this is the error message i am getting

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.
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
also provide code where you are forming query

Shailesh
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic