[Rd] RJDBC
Jose Sierra
jose.sierra at integromics.com
Mon Mar 5 14:02:33 CET 2007
Thank you Sean.
I send the message to R-help.
Sean Davis escribió:
> 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
>
______________________________________________
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
More information about the R-devel
mailing list