Up to now with SQL Anywhere 12, I used jconn3.jar as JDBC Driver to connect to our Application Server (Servoy/TomCat), IDE and Modeling tool. But with SQL Anywhere 16 this driver is not in the SQLAnywhere16/System/java folder any more.
The current JDBC URL and Driver Class are specified as following: JDBC URL: jdbc:sybase:Tds:10.0.1.4:2638?ServiceName=<database>&CHARSET=utf8 Driver Class: com.sybase.jdbc3.jdbc.SybDriver
Which driver is best to use for SQL Anywhere 16 and how would it affect the JDBC URL and Driver Class description?
OS: Yosemite 10.10.5, and Windows 7, Windows Server 2008/2012, Java 1.8.0_60
Thanks a lot in advance for any hint. Robert
asked 25 Sep '15, 10:31
Apparently, v16 uses v4 of the jConnect driver - I guess the following doc topic (and the comments there!) should be helpful:
Besides, you may also be able to use the "native" SQL Anyhwere JDBC4 driver which usually fits better.
answered 25 Sep '15, 10:42