Query « sybase « Java Database Q&A

  1. Java Database Q&A
  2. sybase
  3. Query




1. Mixing Parameterized Query and Sub-query on Insert    stackoverflow.com

I have a colleague who wants to attempt the following query: 

INSERT INTO table (ColumnA, ColumnB, ColumnC)
VALUES (?, (SELECT Id FROM ColumnD WHERE x=y), ?)
Sybase complains about this as it does not ...

2. Nested query results mapped to Java data types    stackoverflow.com

I have two tables in my Sybase database A and B. The relationship between them is one-to-many where an entry in A may have one or more entries in B associated ...

3. Sybase Query with Java Prepared Statements Not Working    stackoverflow.com

I have a web application using Java/JSP that was running off a MySQL database which I've now moved to Sybase. I've changed what I believe are all the relevant connection parts (Sybase ...

4. maximum length of identitifer in Sybase for insert query    coderanch.com

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] ...