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

Prof Brian Ripley r|p|ey @end|ng |rom @t@t@@ox@@c@uk
Fri Oct 7 08:26:06 CEST 2011


Have you reported this to the maintainer?  It looks like a bug in the 
package.

On Thu, 6 Oct 2011, MacQueen, Don wrote:

> 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
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

-- 
Brian D. Ripley,                  ripley using stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595




More information about the R-sig-DB mailing list