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 orvaq...@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]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.