Methods for the class JDBCDriver in Package ‘RJDBC’

Description

Methods for the class ‘H2Driver’ in Package ‘H2’. In addition to methods listed here there are methods inherited from JDBCDriver.

dbConnect creates a new H2 connection.

Methods

dbConnect

signature(drv = "H2Driver", ...)

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
## Not run: 
# in memory database
con <- dbConnect(H2(), "jdbc:h2:mem:")
dbDisconnect(con)

# external database
con <- dbConnect(H2(), "jdbc:h2:~/test")
dbDisconnect(con)

# same but run in MySQL compatibility mode
con <- dbConnect(H2(), "jdbc:h2:~/test;MODE=MYSQL")

## End(Not run)