[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