B.15. Sybase Adaptive Server

B.15.1. Known issues with Sybase

Example B.15. Example properties for Sybase

javax.jdo.option.ConnectionDriverName: com.sybase.jdbc2.jdbc.SybDriver
javax.jdo.option.ConnectionURL: \
    jdbc:sybase:Tds:SERVER_NAME:4100/DB_NAME?ServiceName=DB_NAME&BE_AS_JDBC_COMPLIANT_AS_POSSIBLE=true

B.15.1. Known issues with Sybase

  • The "DYNAMIC_PREPARE" parameter of the Sybase JDBC driver cannot be used with Kodo.

  • Datastore locking cannot be used when manipulating many-to-many relations using the default Kodo schema created by the schematool, unless an auto-increment primary key field is manually added to the table.

  • Persisting a zero-length string results in a string with a single space characted being returned from Sybase, Inc.'s JDBC driver.