[Anand Narasimhan]

Hi,

The edit table feature does not work with Sybase ASA JDBC drivers. I get a message “The result set is not updatable.”. I am using the JDBC driver from sybase.

Where can I find a syabase JDBC driver for ASA that supports editable result sets.

Thanks
Anand

[Haris Peco]

try http://jtds.sourceforge.net/

sybase claim that JConnect support updatable ResultSet , but it is special method (probably)

[Anand Narasimhan]

Looks like JDTS does not work with Sybase ASA. Are there any other drivers?

[Haris Peco]

anandn ,

What mean ASA ? Do you try ?
jTDS work with mostly sybase and MS SQL databases. see http://jtds.sourceforge.net/features.html

You can try MS jdbc driver for MS SQL (it is same engine) and commercial datadirect drivers (http://www.datadirect.com/products/jdbc/overview/index.ssp)

I think that jTDS is good driver and please check and send us problems with log

Thanks

[Anand Narasimhan]

I mean Sybase Adaptive Server Anywhere. I saw some discussion in jDTS forum that says that it work with Sybase ASE (Adaptive Server Enterprise) and not ASA.

I tried using JDTS. I always get a message saying that login failed.

Here is the text from the discussion.

In it�s present form jTDS will not connect to ASA. These are the main areas of incompatibility that I am aware of:
1. The TDS 50 login packet sends the server�s host name where ASA expects either the database name that you wish to open or blank for the default. This is what the serviceName connection property with jConnect is used for.
2. During the login process the driver exchanges capability packets with the server. These are used to negotiate support for features such as long strings, big ints etc. The current logic is needs to be enhanced to support ASA features as well as ASE.
3. The DatabaseMetaData needs fixing to work correctly with ASA.
4. The get/set catalog methods do not work with ASA and the syntax for commit/rollback is slightly different.
5. Depending on the database settings, ASA servers can send genuine zero length strings (unlike ASE) and these need extra logic to process.
6. ASA does not support �select � for browse� or language cursors so jTDS will not be able to support updateable cursors.
7. The syntax for creating lightweight stored procedures (needed by prepared statements) is slightly different.

None of this is very hard to fix but the problem is the added complexity it adds to jTDS, which may not be worth supporting unless there is a reasonable demand for ASA connectivity.

[Haris Peco]

anandn,

try data direct http://www.datadirect.com/products/jdbc/matrix/jdbcpublic.htm

you can download trial and i will try find any solution for you yet

Best

[Author]

Posts