jConnect – This driver is a 100% pure Java driver.
In addition, applications can now fetch NCHAR data using the Get/SetNString or Get/SetNClob methods instead of the Get/SetString and Get/SetClob methods. With the JDBC 4.0 driver, metadata for NCHAR data now returns the column type as, NVARCHAR, or LONGNVARCHAR. The JDBC 4.0 driver contains manifest information to allow it to be loaded as an OSGi (Open Services Gateway initiative) bundle. It is instead sufficient to have the sajdbc4.jar file in the class file path and simply call DriverManager.getConnection() with a URL that begins with jdbc:sqlanywhere. Hence, if an application wants to make use of the JDBC 4.0 driver, it no longer needs to perform a Class.forName call to get the JDBC driver loaded. The JDBC 4.0 driver takes advantage of the new automatic JDBC driver registration. The JDBC 4.0 driver can be used only with JRE The SQL Anywhere JDBC 4.0 driver is the recommended JDBC driver for connecting Its behavior is consistent with ODBC, embedded SQL, and OLE DBĪpplications. SAP Sybase IQ supports the following JDBC drivers:
