Insert « sybase « Java Database Q&A

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




1. Sybase stored procedure insert limit with JDBC driver    stackoverflow.com

I'm having issues with stored procedures that have a lot of insert statements when using Sybase's jdbc driver. After 50-60 inserts, the stored procedure stops execution and returns. See code below. I'm ...

2. Sybase JDBC get generated keys    stackoverflow.com

In Postgres, I can write 

INSERT .. RETURNING *
To retrieve all values that had been generated during the insert. In Oracle, HSQLDB, I can use 
String[] columnNames = ...
PreparedStatement ...

3. Sybase text column insert    coderanch.com

Hi, I have a Sybase table that has a column of type TEXT. What I am doing is that, I am reading characters from a file, convert them into String object and then insert into this column. The value of the String gets into the TEXT column. The String object (roughly 4K characters) gets inserted successfully into the column and when ...

4. Sybase database - insert statement problems    coderanch.com

I have a table(CODE_LOOKUP) with 3 columns(CL_ID,CL_RC,CL_DESC) i wanted to insert a new column taking the max(id)+1 This is the sql query i am trying to insert INSERT INTO CODE_LOOKUP(CL_ID,CL_RC,CL_DESC) values(max(CL_ID)+1, 'Region0', 'Region0'); I couldnot execute the Query..it throws me out saying com.sybase.jdbc2.jdbc.SybSQLException: The name 'CL_ID' is illegal in this context. Only constants, constant expressions, or variables allowed here. Column names ...