From sdavis2 at mail.nih.gov  Mon Mar  5 13:50:57 2007
From: sdavis2 at mail.nih.gov (Sean Davis)
Date: Mon, 05 Mar 2007 07:50:57 -0500
Subject: [Rd] RJDBC
In-Reply-To: <45EC0F6A.20309@integromics.com>
References: <45EC0F6A.20309@integromics.com>
Message-ID: <45EC1231.20108@mail.nih.gov>

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



[Rd] RJDBC
Sean Davis