dbUnloadDriver() fails for RJDBC
I have the following: ----------------------------------------
con.str
[1] "jdbc:oracle:thin:@myhost.domain:1521:dbname"
path.to.jar
[1] "path.to.oracle/instantclient_10_2/ojdbc14.jar"
jdbm <- JDBC('oracle.jdbc.OracleDriver', path.to.jar, "`")
jcon <- dbConnect(jdbm, con.str, ora.usr, ora.pw)
jdbm
An object of class "JDBCDriver"
Slot "identifier.quote":
[1] "`"
Slot "jdrv":
[1] "Java-Object{oracle.jdbc.OracleDriver at 6262937c}"
jcon
An object of class "JDBCConnection"
Slot "jc":
[1] "Java-Object{oracle.jdbc.driver.T4CConnection at 35c0e45a}"
Slot "identifier.quote":
[1] "`"
dbDisconnect(jcon)
[1] TRUE
dbUnloadDriver(jdbm)
Error in .valueClassTest(standardGeneric("dbUnloadDriver"), "logical", :
invalid value from generic function "dbUnloadDriver", class "NULL",
expected "logical"
----------------------------------------
This is of course not a big problem; I don't absolutely have to unload the
driver. But it should succeed, shouldn't it?
sessionInfo()
R version 2.13.1 (2011-07-08) Platform: x86_64-apple-darwin9.8.0/x86_64 (64-bit) locale: [1] C attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] RJDBC_0.2-0 rJava_0.9-1 DBI_0.2-5 loaded via a namespace (and not attached): [1] tools_2.13.1 Thanks -Don
Don MacQueen Lawrence Livermore National Laboratory 7000 East Ave., L-627 Livermore, CA 94550 925-423-1062