[mfotiou]

I am using Sybase ASE, latest version of server and JConnect driver 5.5. When I attempt to edit a table, the following error is issued in the editor window:

Error: can’t edit: The result set is not updateable.

Does the driver have to support this functionality to allow table editing?

[support-jeff]

Short answer: Yes

Not as short answer: Direct edit is an experimental feature that relies on JDBC2 support for RowSets. If the Sybase driver does not support this feature, then the feature will not work.

[mfotiou]

Thanks for the reply Jeff.

After consulting the JConnect documentation, it looks like the driver only supports updatable resultsets when its TYPE is FORWARD_ONLY. It would make sense that you would need a scrollable cursor to implement the table-edit grid. I also checked the documentation for version 6, and the behaviour is the same.

After trolling the JConnect newsgroup, it appears that implementing scrollable, updatable resultsets would require back-end changes to the server code, so it’s anyone’s guess when this functionality will be implemented.

[support-jeff]

Thanx for posting the follow-up work you did. This really helps others who find them selves in the same position.

[Author]

Posts