[Rd] RJDBC
Sean Davis
sdavis2 at mail.nih.gov
Mon Mar 5 13:50:57 CET 2007
Jose Sierra wrote:
> I need help.
>
> I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using
> RJDBC package.
>
> My code is the next:
>
> library('rJava')
> library('DBI')
> library('RJDBC')
>
> //Mysql
> drv <-
> JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'")
>
> conn <- dbConnect(drv, "jdbc:mysql://localhost:3306/bd", "user",
> "password")
>
> //Oracle
> drv <-
> JDBC("oracle.jdbc.driver.OracleDriver","C:\\Temporal\\classes12.jar","'")
> conn <-
> dbConnect(drv,"jdbc:oracle:thin:@192.168.1.70:1521:SDS22","user","password")
>
>
> R always returns for oracle
> "Error en .local(drv, ...) : Unable to connect JDBC to
> jdbc:oracle:thin:@192.168.1.70:1521:SDS22"
> and for mysql
> "Error en .local(drv, ...) : Unable to connect JDBC to
> jdbc:mysql://localhost:3306/bd"
>
> And the function summary(drv) returns:
> JDBCDriver
> name = JDBC
> driver.version = 0.1-1
> DBI.version = 0.1-1
> client.version = NA
> max.connections = NA
>
> Can you help me, please?
>
Jose,
This message should go to the R-help or the R-SIG-DB list. When you
send it, I suggest you include your Java version, the output of a call
to sessionInfo(), and let folks know whether you can connect from your
machine using JDBC in Java. I don't use RJDBC, so I can't help
directly--sorry.
Sean
More information about the R-devel
mailing list