After installing RJDBC on RedHat Linux and using it successfully with mySQL
JDBC driver i am trying to use it with Oracle database. I use the JDBC
driver that works fine elsewhere (use it in DBVizualizer). However, when i
try to load the driver,
drv<-JDBC("oracle.jdbc.driver.OracleDriver",
"/home/az05625/DBdrivers/ojdbc6.jar", identifier.quote="`")
it gives me error message
Error in .jfindClass(as.character(driverClass)[1]) :
java.lang.UnsupportedClassVersionError: Bad version number in .class file
One would think that this has to do with JRE older than the JDBC driver, but
i use the same JRE for the application that connects successfully and for
RJDBC, namely
java version "1.6.0_10"
Java(TM) SE Runtime Environment (build 1.6.0_10-b33)
Java HotSpot(TM) 64-Bit Server VM (build 11.0-b15, mixed mode)
What could this be a symptom of, could someone knowledgeable about RJDBC
comment?
--
View this message in context:
http://r.789695.n4.nabble.com/RJDBC-doesn-t-load-Oracle-driver-tp3058107p3058107.html
Sent from the R help mailing list archive at Nabble.com.
I am having trouble loading Oracle JDBC driver into RJDBC. Basically, i installed RJDBC and used it to connect to MySql. However, when i try to load JDBC Oracle driver, it gives me an error message> drv<-JDBC("oracle.jdbc.driver.OracleDriver", "/pathToDriver/ojdbc6.jar")Error in .jfindClass(as.character(driverClass)[1]) java.lang.UnsupportedClassVersionError: Bad version number in .class file Few relevant facts 1. I use this JDBC driver elsewhere, in DBvizualiser, it connects fine 2. I run R and Java on 64 bit Red Hat Linux. 3. I run same version of JRE in DBvizualiser that works with the driver as the version that doesn't work with RJDBC What could it be? Would really appreciate someone familiar with RJDBC commenting More details on versions: Java version is ------------------------ java version "1.6.0_10" Java(TM) SE Runtime Environment (build 1.6.0_10-b33) Java HotSpot(TM) 64-Bit Server VM (build 11.0-b15, mixed mode) R version ------------- R version 2.10.0 (2009-10-26) OS version ------------- Linux 2.6.18-164.19.1.el5 #1 SMP Mon May 24 17:03:22 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux -- View this message in context: http://r.789695.n4.nabble.com/RJDBC-doesn-t-load-Oracle-driver-tp3058121p3058121.html Sent from the R help mailing list archive at Nabble.com.