Sybase ASE: Table data edits are saved in wrong table Print

Modified on: Wed, 12 Jul, 2017 at 8:00 PM

If using the jTDS driver and having two identically named tables in different databases, any edits made in both tables shows up only in one of them. This is the default behavior for the jTDS driver. To workaround it you need to set the following driver property for your Sybase jTDS connection:

PREPARESQL = 2