sql « sybase « Java Database Q&A





1. Execute Multiline sybase statement with java.sql.Statement    stackoverflow.com

How can I both set rowcount and then execute a query in a Statement.executeQuery() function? note I don't want to use Statement.setMaxRows() to do this

2. cryptic error message: Length of Bind host variable exceeds MaxLength    stackoverflow.com

I've encountered a cryptic error message thrown by Sybase IQ server. com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -1001019: Function not supported on varchars longer than 255 Length of Bind host variable exceeds MaxLength , ...

3. Sybase: programmatically turn off foreign key checks    stackoverflow.com

I need to do bulk inserts/updates/deletes on a table-by-table basis via JDBC. Database is Sybase. Because of FK checks, I can't do this, because I temporarily violate integrity. In MySQL I can easily ...

4. Temporary table committing the transaction in sybase    stackoverflow.com

I am doing a bulk insert using sybase temporary table approach (# table name). This happens in a transaction. However this operation is committing the data transaction. ( I ...

5. "Implicit conversion from datatype 'CHAR' to 'SMALLINT' is not allowed"    stackoverflow.com

I have been trying to fix an issue for the past 3 days but I'm getting no where. Someone please help!!! I am trying to call an Insert stored procedure at Sybase ...

6. Calling Sybase Adaptive Server Enterprise's "sp_help" from JDBC    stackoverflow.com

In order to query the database meta data in Sybase ASE, I found this relevant answer (not the accepted one), to be ideal: From a Sybase Database, how I can get ...

7. Reading GUID as string from Sybase Table using JDBC    stackoverflow.com

In my Sybase 12.0 ASE database, I have at table that contains a column defined as binary(16) and used to store GUIDS/UUIDs. When i run a select query using a ...