sjdbc {sjdbc}

SJDBC Package Documentation

Description

The SJDBC Package provides an interface to databases using Java's JDBC connectivity.

Details

Provides an interface to a databases using JDBC drivers. You can get JDBC drivers from the software providers. Place the JAR or ZIP file containing the JDBC drivers in the drivers folder under the package installation directory. All files placed in this directory are added automatically to the Java CLASSPATH when the package is loaded. Alternatively, drivers can be loaded explicitly at runtime using loadJDBCDriver.

The interface has been tested with the following drivers:

• Microsoft SQL Server 2005

  • Connection String: jdbc:sqlserver://<host>:1433;databaseName=<database>;user=<username>;password=<password>;

  • Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

• IBM DB2 Universal Database 7.2

  • Connection String: jdbc:db2://<host>:6789/<database>

  • Driver Class: COM.ibm.db2.jdbc.net.DB2Driver

• MySQL Connector/J 3.1.14

  • Connection String: jdbc:mysql://<host>:3306/<database>

  • Driver Class: com.mysql.jdbc.Driver

• Oracle 10g Release 2 10.2.0.4 (ojdbc14.jar)

  • Connection String: jdbc:oracle:thin:@<host>:1521:<databaseSID>

  • Driver Class: oracle.jdbc.OracleDriver

• PostgreSQL 8.3 (JDBC3 driver 8.3-603)

  • Connection String: jdbc:postgresql://<host>:5432/<database>

  • Driver Class: org.postgresql.Driver

Known Issues

• Missing values might not be handled correctly in all cases. exportJDBC handles missing (NA) values for integer and numeric class columns by creating NULL values in the database table. Currently, this does not work for character or factor columns. NA values are stored as “NA” in the table, but empty strings (“”) are stored as empty strings.