> Schema  > Products  > SRTransport  > Documentation  > Supported JDBC Drivers

 
  JDBC Drivers

SR·Transport's JDBC module uses 3rd party Type 3 or 4 JDBC drivers. They may be obtained from database vendors (they are often part of a database installation) or other 3rd party sources. Because each driver is implemented a slightly different way, Schema Research cannot guarantee that any given driver will work with SRTransport. We have tested a number of drivers and found that most work, although sometimes adjustments are required to the SRTransport JDBC module.

JDBC drivers are cross platform by their nature, i.e. java. They have been tested using Java 1.2 and in some cases Java 1.3. It is possible that different versions of the Java Run Time might cause problems even with tested drivers. Contact Schema Research if you encounter any problems.

The drivers listed below have been found to work. If you are using a different driver and or a different database we will be glad to test it, and make modifications as necessary, provided we can obtain access to an appropriate database server.

Schema Research has found several drivers that do not work with SRTransport at this time, including the InterClient driver for Borland's InterBase and the twz1jdbcForMysql-1.0.4-GA driver for MySQL.

Drivers Tested by Schema Research:

Oracle:
Oracle driver for Java 1.2 Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.2.x(Thin)
File name: classes12.zip - Included with SRTransport
Sybase:
Use Sybase's jConnect.
File name: jconn2.jar - Included with SRTransport
MS SQLServer:
Microsoft driver
File name: sqlserver.jar, msbase.jar, msutil.jar
Merant/DataDirect JDBC driver
File name: sqlserver.jar, base.jar, util.jar
OpenBase:
Driver comes with OpenBase
File name: OpenBaseJDBC.jar - Included with SRTransport
FrontBase:
Driver comes with FrontBase (make sure you have the latest driver, older ones won't work)
File name: frontbasejdbc.jar
MySQL:
MySql 1.0 Release Version JDBC Driver
File name: mysql_comp.jar
PostgreSQL:
PostgreSQL 7.2 Standard Edition JDBC Driver
File name: pgjdbc2.jar
Driver name: org.postgresql.Driver
Pervasive:
Easysoft JDBC-ODBC Bridge driver
File name: EJOB.jar

If you have a database that is not mentioned, Sun Microsystems maintains a database of JDBC drivers for many different DBs, most of which will work in SRTransport.

Note for Microsoft and Merant drivers: The driver comes in 3 parts, all of which must be added to Java Preferences, but only the driver name for the sqlserver.jar needs to be entered. The other two 'driver names' should be left blank.

See Also