search for: rjdbc

Hi, I'm working with R on Cassandra and need to install RJDBC on my Ubuntu virtual machine. The traditional commands (install.packages(RJDBC, dep=TRUE) and library(RJDBC)) don't work: they throw an error that they can't find the package. I tried installing it using the Rkward GUI, but can't write to any of the pre-set directories because of permis...

After installing RJDBC on RedHat Linux and using it successfully with mySQL JDBC driver i am trying to use it with Oracle database. I use the JDBC driver that works fine elsewhere (use it in DBVizualizer). However, when i try to load the driver, drv<-JDBC("oracle.jdbc.driver.OracleDriver", "/home/az05...

Dear all Backend is Ingres DBMS I use RJDBC with Ingres JDBC driver I have this csv file "","Strategy","par1","m.1997.09.01" "1","ALF",2,0.1244 which I try to load it RJDBC require (RJDBC) drv <- JDBC("com.ingres.jdbc.IngresDriver","/home/ingres/ingresv1/ingr...

...to get this to work because of some incompatibility with the rpm packages?? * Installing *source* package ?rJava? ... sh: ./configure: /bin/sh: bad interpreter: Permission denied ERROR: configuration failed for package ?rJava? * Removing ?/usr/lib64/R/library/rJava? * Installing *source* package ?RJDBC? ... ** R ** preparing package for lazy loading Error : package 'rJava' required by 'RJDBC' could not be found ERROR: lazy loading failed for package ?RJDBC? * Removing ?/usr/lib64/R/library/RJDBC? I'm using the rpm version of R found here http://cran.cnr.berkeley.edu/bin/linux...

...I have tried this with the compiled version of R and the RPM version of R. * Installing *source* package ?rJava? ... sh: ./configure: /bin/sh: bad interpreter: Permission denied ERROR: configuration failed for package ?rJava? * Removing ?/usr/lib64/R/library/rJava? * Installing *source* package ?RJDBC? ... ** R ** preparing package for lazy loading Error : package 'rJava' required by 'RJDBC' could not be found ERROR: lazy loading failed for package ?RJDBC? * Removing ?/usr/lib64/R/library/RJDBC? I'm using the rpm version of R found here http://cran.cnr.berkeley.edu/bin/linux...

...I have tried this with the compiled version of R and the RPM version of R. * Installing *source* package ?rJava? ... sh: ./configure: /bin/sh: bad interpreter: Permission denied ERROR: configuration failed for package ?rJava? * Removing ?/usr/lib64/R/library/rJava? * Installing *source* package ?RJDBC? ... ** R ** preparing package for lazy loading Error : package 'rJava' required by 'RJDBC' could not be found ERROR: lazy loading failed for package ?RJDBC? * Removing ?/usr/lib64/R/library/RJDBC? I'm using the rpm version of R found here http://cran.cnr.berkeley.edu/bin/linux...

I would like to set up a Windows XP environment with R and MySQL. This set-up was recommended by a friend who uses this set up, but I have been unable to get RJDBC to work. I have installed all of the software today (June 2 2008), first deleting and then replacing old versions of software. The error is as follows: Error in .jfindClass(as.character(driverClass)[1]) : class not found This error is produced after running the following code (): library(RJDBC...

I am desperate for help. I am trying to get the RJDBC and rJava .5to work on both my windows xp and linux Redhat EL5 Server. On both I get a ava.lang.ClassNotFoundException when calling JDBC(). My example is require(RJDBC) classPath='C:\\libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar' driverClass=c("co...

Dear List, Java Exception error while reading large data in R from DB using RJDBC. I am trying to read large data from DB table(Vectorwise), using RJDBC connection. I have tested the connection with small size data and was able to fetch DB tables using same connection(conn as in my code). Please suggest where am i going wrong or alternate option to solve such issues while r...

Hi R-helpers, i am using the following dataset.This dataset is stored in a mysql database. W(x) pH(y) 10 1 15 1 20 4 5 7.5 3 13 9 5 11.5 13.5 3 16 2 1 9.6 1 I am using RJDBC package to read the data from the database into a dataFrame.The commands used are, jdbcDriver<-JDBC(driverClass="com.mysql.jdbc.Driver", classPath="E:/PAS/trunk/lib/mysql-connector-java-5.1.13-bin.jar", identifier.quote = NA) conn<-dbConnect(jdbcDriver,"jdbc:mysql://...

Rjdbc consistently gives me an execution error with postgresql 9.0s JDBC4 driver. It's probably something trivial so am including my code below: library("RJDBC") param <- 249 param2 <- 188129 postgres <- JDBC("org.postgresql.Driver", ".m2/repository/postgresql/postg...

I am running a simple SQL SELECT statement that involvs 50k + data points using R and the RJDBC interface. I am facing very slow response times in both the RGUI and the R console. When running this SQL statement directly in a SQL client I have processing times that are a lot lot faster (which means that the SQL statement itself is not the problem). Did any of you compare RJDBC vs RMySQL or i...

Hi List, I am reading table from postgres database into R session using RJDBC, table contains 150 columns and 200000 rows. Sample code is as below, which works fine with smaller tables. ######################################################################## db_driver <- mydir$db_driver db_jar_file <- mydir$db_jar_file db_server <- mydir$db_server db_server_lgn &lt...

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://loc...

Hi All, We are using the following dataset which contains UTF-8 characters and is stored in a MySQL database. When we use RODBC and read the data, the characters are read correctly.But when we read using RJDBC ,the characters are read like ???????????????????????????1 Can you please let me know how we can read the UTF-8 characters as it is done by RODBC. ID code Outlook Temperature Humidity Windy Play a Sunny Hot High FALSE ????????????1 b Sunny Hot High TRUE ????????????2 c Overcast Hot High FALSE ???...

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://l...

Has anybody used RJDBC to read tables from an MS Access mdb file? I know how to do it with RODBC, and I have used RJDBC with SQL Server. I am, however interested now in this particular combination. Is it possible? -- View this message in context: http://n4.nabble.com/RJDBC-with-MS-Access-tp1470599p1470599.html Sent fro...

...ar (to access an MSAccess file) under Linux. I bought the license from http://www.csv-jdbc.com/ guys. The driver work fine when tested with DBVisualizer or another JDBC thing. The problem is that driver needs 3 other more jar files to work. Under R I have tried this and does not work: > library(RJDBC) Loading required package: DBI Loading required package: rJava > .jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/log4j.jar") > .jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_lang.jar") > .jaddClassPath("/opt/DbVisualizer-7.1.1/jdbc/mdb/commons_logging.ja...

Hi, Does anyone have experience using RJDBC library to write to Sybase datatable? The jdbc driver I am using is jConnect 6.0. I can successfully write into a new datatable, but have problem appending rows to existing one. It either complains "Table *** already exists" or simply overwrite the existing one. Here is the example. I am...

.... I can also have UNION queries that allow me to overcome the spreadsheet row limitation of a single sheet. The idea is to allow normalization of data in a spreadsheet and leveraging the power of SQL, without using a database. Can the same be done under Windows (Linux?) with OpenOffice Calc using RJDBC? Are there ODBC drivers for OpenOffice Calc? I know that the right solution would be to use a database, but this is outside the comfort zone of many users who rely mainly on spreadsheets to collect, manipulate and analyze their data. Thomas Metz International Rice Research Institute Philippines