Description Usage Arguments Value Examples
Call driver
to create a new JDBCDriver
in order to connect
to databases using the given JDBC driver.
1 2 3 4 | driver(driver_class = NULL, classpath = NULL, dialect = NULL,
read_conversions = default_read_conversions,
write_conversions = default_write_conversions,
create_new_connection = create_new_dbj_connection)
|
driver_class |
a character vector specifying the JDBC driver classes (e.g. 'org.h2.Driver') |
classpath |
a character vector of length one specifying classpaths separated by |
dialect |
The |
read_conversions |
a list of |
write_conversions |
a list of |
create_new_connection |
The factory function for JDBCConnection objects. |
A new JDBCDriver
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | library(DBI)
library(dbj)
jdbc_register_driver(
c('org.h2.Driver', 'org.apache.derby.jdbc.EmbeddedDriver'),
resolve(
list(
module('com.h2database:h2:1.3.176'),
module('org.apache.derby:derby:10.12.1.1')
),
repositories = list(maven_local, maven_central)
)
)
h2_con <- dbConnect(dbj::driver(), 'jdbc:h2:mem:example_db')
derby_con <- dbConnect(dbj::driver(), 'jdbc:derby:memory:example_db;create=true')
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.