1. Execute Multiline sybase statement with java.sql.Statement stackoverflow.comHow 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.comI'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.comI 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.comI 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.comI 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.comIn 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.comIn 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 ... |