[R] connecting to db2 via RJDBC

From: Aydemir, Zava (FID) <Zava.Aydemir_at_morganstanley.com>
Date: Thu, 14 Jun 2007 16:07:57 -0400


Hello,  

I seem to have issues with setting the driver:  

My code:  

    library(RJDBC)    

    getStatic <- function()
    {

     # set driver
     driverClass <-

JDBC("com.ibm.db2.jcc.DB2Driver","someClassPath.jar","'")  
     conn <- dbConnect(driverClass,"serverName")
     etc etc 
 

}    

I get this error  

> data <-getData()

Exception in thread "main" java.sql.SQLException: No suitable driver  at java.sql.DriverManager.getConnection(DriverManager.java:545)  at java.sql.DriverManager.getConnection(DriverManager.java:171) Error in .local(drv, ...) : Unable to connect JDBC to serverName        

Can anyone help me?  

Thank you    

Zava


This is not an offer (or solicitation of an offer) to buy/se...{{dropped}}



R-help_at_stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Thu 14 Jun 2007 - 20:26:29 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 14 Jun 2007 - 20:33:47 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.