The SJDBC Package provides an interface to databases using Java's JDBC connectivity.
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.
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
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
IBM DB2 Universal Database 7.2
Driver Class: COM.ibm.db2.jdbc.net.DB2Driver
MySQL Connector/J 3.1.14
Driver Class: com.mysql.jdbc.Driver
Oracle 10g Release 2 10.2.0.4 (ojdbc14.jar)
Driver Class: oracle.jdbc.OracleDriver
PostgreSQL 8.3 (JDBC3 driver 8.3-603)
Driver Class: org.postgresql.Driver