RH2: Using R cannot connect to my H2 database

Asked Dec 17 '12 at 01:02

Active Dec 17 '12 at 01:02

Viewed 590 times

I read the documentation of RH2 on CRAN but when I'm trying to connect to my H2 database I get this error:

> library(RH2)
Loading required package: chron
Loading required package: RJDBC
Loading required package: DBI
Loading required package: rJava
> con <- dbConnect(H2(), "jdbc:h2:mem:test")
Error in .local(drv, ...) : could not find function ".verify.JDBC.result"

WHere I'm wrong?

asked Dec 17 '12 at 01:02

Alberto

2,881
7
35
66

TRy to follow the example in ?H2 . Your second arguments looks wrong. – G. Grothendieck Dec 17 '12 at 01:10
I tried this and there is the same error: con <- dbConnect(H2(), "jdbc:h2:~/test", "sa", "") Error in .local(drv, ...) : could not find function ".verify.JDBC.result" – Alberto Dec 17 '12 at 01:37
1

I get the same error. It seems that RJDBC has been updated in such a way as to break RH2. Use RJDBC 2.0 until its fixed. – G. Grothendieck Dec 17 '12 at 04:51
1

RH2 version 0.1-2.9 is now on CRAN and fixes this problem. – G. Grothendieck Dec 19 '12 at 11:10
with RH2 0.1-2.9 and RJDBC 0.2-1 the problem remains – Alberto Dec 23 '12 at 12:17
I am able to reproduce this so go back to RJDBC 2.0 again until its fixed. – G. Grothendieck Dec 23 '12 at 13:31
I have updated the package again. If you want a copy to test it send me an email. (See http://cran.r-project.org/package=RH2 for my address.) – G. Grothendieck Dec 23 '12 at 15:21

RH2: Using R cannot connect to my H2 database

0 Answers0

Linked