Things to know about the jConnect driver.
The jConnect driver is a Type 4, or Direct to Database Pure Java, JDBC driver. This means that the driver takes JDBC calls and directly converts it to the vendor specific protocol, in this case TDS.
Written completely in Java, a type 4 driver is platform independent. It installs inside the Java Virtual Machine of the client normally by using the "Class.forName()" method call. This provides better performance than type 1 and type 2 drivers as it does not have the overhead of conversion of calls into ODBC or database API calls. And unlike type 3 drivers, it does not require other associated software to work.
Advantages of a Type 4 driver are:
- The driver is completely implemented in Java to achieve platform independence.
- These drivers don't translate the requests into an intermediary format (such as ODBC).
- The client application connects directly to the database server. No translation or middleware layers are required, improving performance.
- The JVM can manage all aspects of the application-to-database connection; this can facilitate debugging using the JVM interface and APIs designed for this purpose.
The jConnect jdbc driver is part of the SDK for SAP ASE installation. Currently there is not a separate download site for this driver by itself.
Versions of the driver and what version of software it was included in.
SDK 16.0 - jConnect -16_0 version jdbc16 contains the jconn42.jar works with java 1.8 and higher starting with SDK for SAP ASE 16.0 SP03 PL09 (SAP Open Server and SDK for SAP ASE New Features Guide> JDBC 4.2 Specifications Support)
SDK 16.0 - jConnect-16_0 version jdbc16 contains the jconn4.jar works with java 1.6 and higher
SDK 15.7 - jConnect-7_0 version 7.0.7 contains the jconn4.jar works with java 1.6 and higher
SDK 15.5 - jConnect-7_0 version 7.0.0 contains the jconn4.jar works with java 1.6 and higher
SDK 15.0 and 15.5 jConnect–6_0 version 6.05 contains the jconn3.jar works with java 1.4 and higher
SDK 12.5.1 jConnect-5_5 contains the jconn2.jar work with java 1.3
Books for the Drivers are located here:
jConnect for JDBC 16
jConnect for JDBC 7.0.7
base - through ESD#7
SP100 - only has the Programmers Reference guide the installation and release bulletin are under the base-through ESD#7 books
SP110 - only has the Programmers Reference guide the installation and release bulletin are under the base-through ESD#7 books
jConnect for JDBC 7.0
jConnect for JDBC 6.0.5
jConnect for JDBC 5.5
Interoperability to ASE with version of jConnect
ASE 12.5.4: ref: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc73430_1254/html/aserbsol/CHDHDFCI.htm
ASE 15.0: ref https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.help.sdk.15.0/title.htm
ASE 15.5: ref http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00902.1550/doc/html/asc1219331977951.html
ASE 15.7: ref: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00762.1570/doc/html/car1328552835693.html
ASE 16.0: ref: https://help.sap.com/viewer/d5c023e929ac4a07b7a2c4f97eb3efa8/126.96.36.199/en-US/a6667123bc2b101481f8955183881c47.html?q=interoperability
from jconn3.jar to jconn4.jar from SDK 15.5 ESD#3 and higher DYNAMIC_PREPARE changed the default setting from false in jconn3 to true with jconn4.