File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes maximum length of identitifer in Sybase for insert query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "maximum length of identitifer in Sybase for insert query" Watch "maximum length of identitifer in Sybase for insert query" New topic
Author

maximum length of identitifer in Sybase for insert query

Hd Desai
Ranch Hand

Joined: Aug 04, 2003
Posts: 65
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

Joined: Aug 13, 2004
Posts: 1081

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
Hd Desai
Ranch Hand

Joined: Aug 04, 2003
Posts: 65
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

Joined: Aug 13, 2004
Posts: 1081

also provide code where you are forming query

Shailesh
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: maximum length of identitifer in Sybase for insert query