Description Details Known Issues
The SJDBC Package provides an interface to databases using Java's JDBC connectivity.
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
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.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.