My ignorance! I managed to connect doing:
library(RJDBC)
cp <- c(
"/opt/DbVisualizer-7.1.1/jdbc/mdb/log4j.jar",
"/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_lang.jar",
"/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_logging.jar"
)
.jinit(classpath=cp)
drv <- JDBC("jstels.jdbc.mdb.MDBDriver",
"/opt/DbVisualizer-7.1.1/jdbc/mdb/mdbdriver.jar")
con <- dbConnect(drv,
"jdbc:jstels:mdb:/mnt/disco/data/fhi/roads/ROADSII.mdb")
If there better ways please advice me. Thanks!
Caveman
On Sun, Jun 26, 2011 at 3:29 PM, Orvalho Augusto <orvaquim@gmail.com>
wrote:
> Corect me if this is not the right place to post this.
>
> I have a mdbdriver.jar (to access an MSAccess file) under Linux. I bought
> the license from http://www.csv-jdbc.com/ guys. The driver work fine when
> tested with DBVisualizer or another JDBC thing.
>
> The problem is that driver needs 3 other more jar files to work. Under R I
> have tried this and does not work:
> > library(RJDBC)
> Loading required package: DBI
> Loading required package: rJava
> > .jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/log4j.jar")
> >
.jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_lang.jar")
> >
.jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_logging.jar")
> >
> > drv <- JDBC("jstels.jdbc.mdb.MDBDriver",
> "/opt/DbVisualizer-7.1.1/jdbc/mdb/mdbdriver.jar")
> Error in .jfindClass(as.character(driverClass)[1]) :
> java.lang.NoClassDefFoundError: org/apache/log4j/PropertyConfigurator
>
> As you see I have added the log4j with .jaddClassPath. What is wrong?
>
> Caveman
>
>
[[alternative HTML version deleted]]