[R-sig-DB] dbUnloadDriver() fails for RJDBC

MacQueen, Don m@cqueen1 @end|ng |rom ||n|@gov
Thu Oct 6 22:42:20 CEST 2011


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 using 6262937c}"

> jcon
An object of class "JDBCConnection"
Slot "jc":
[1] "Java-Object{oracle.jdbc.driver.T4CConnection using 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




More information about the R-sig-DB mailing list