sql « sybase « Java Database Q&A

1.	Blob
2.	cassandra
3.	column
4.	Connection
5.	Cursor
6.	dao
7.	Data Type
8.	Database
9.	Database Product
10.	DataSource
11.	Date
12.	db2
13.	derby
14.	Development
15.	Driver
16.	Exception
17.	file
18.	hadoop
19.	hbase
20.	hsqldb
21.	ibatis
22.	JDBC
23.	memcached
24.	mongodb
25.	MS Access
26.	mysql
27.	ODBC
28.	Operation
29.	oracle
30.	postgresql
31.	Record
32.	result
33.	Resultset
34.	Schema
35.	SQL
36.	sqlite
37.	SQLserver
38.	Statement
39.	stored procedure
40.	sybase
41.	Table
42.	Transaction
43.	Trigger

Java Database Q&A » sybase » sql

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