[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