Displaying 20 results from an estimated 2000 matches similar to: "RJDBC vs RMySQL vs ???"
2011 Oct 19
4
Using SQL "IN" with RJDBC or RMySQL
Hello,
The code below works fine up until I try to use the "IN" statement in
the last line. The proper SQL format is:
SELECT * FROM this_table WHERE this_column IN (1,2,3,4,5)
But, I think I may be getting something like:
SELECT * FROM this_table WHERE this_column IN c(1,2,3,4,5)
Which makes no sense in SQL. I think it may be just a matter of string
massaging, but I'm not
2007 Mar 05
1
RJDBC
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,
2012 Jul 02
1
apply with multiple conditions
Hello all,
I have written a for loop to act on a dataframe with close to 3million rows
and 6 columns and I would like to pass it to apply() to speed the process up
(I let the loop run for 2 days before stopping it and it had only gone
through 200,000 rows) but I am really struggling to find a way to pass the
arguments. Below are the loop and the head of the dataframe I am working on.
Any hints
2012 May 21
1
tcktk problem with custom R 2.15.0 build on RHEL5
Hi all,
Please bear with me because I'm not all that familiar with R. I manage a
research cluster that's running Red Hat 5.6 (64-bit), and we recently
installed version 2.15.0 of R for some users. Here's how we built it:
./configure --prefix=/opt/shared/R/2.15.0 --with-tcltk --with-system-zlib --with-system-bzlib --with-system-pcre --with-lapack --enable-R-shlib
When we ran
2012 Aug 02
1
RJDBC in Ubuntu
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 permissions issues. When I try running
2010 Nov 24
1
RJDBC doesn't load Oracle driver?
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/az05625/DBdrivers/ojdbc6.jar", identifier.quote="`")
it gives me
2011 Feb 10
1
rjdbc identifier.quote
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/ingres/lib/iijdbc.jar")
conn <- dbConnect(drv,
2009 Aug 26
1
Installing rJava RJDBC bad interpreter: Permission denied
Trying to install the above two packages via the "install.packages("package_name")" command and
the "R CMD INSTALL file.tar.gz".
I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied".
I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF
in some of the tar.gz files,
2009 Sep 02
1
Installing rJava RJDBC bad interpreter: Permission denied
Trying to install the above two packages via the "install.packages("package_name")" command and
the "R CMD INSTALL file.tar.gz".
I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied".
I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF
in some of the tar.gz files,
2009 Sep 02
1
Installing rJava RJDBC bad interpreter: Permission denied
Trying to install the above two packages via the "install.packages("package_name")" command and
the "R CMD INSTALL file.tar.gz".
I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied".
I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF
in some of the tar.gz files,
2008 Jun 02
1
RJDBC cant find driver class in JDBC jar file
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
2012 Oct 30
2
Java Exception error while reading large data in R from DB using RJDBC.
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 reading large DB
2011 Feb 03
3
Reg : read missing values from database using RJDBC
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",
2007 Sep 27
2
rJava and 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("com.mysql.jdbc.Driver")
drv <-
2011 Feb 16
1
Rjdbc dbGetquery execution error
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/postgresql/9.0-801.jdbc4/postgresql-9.0-801.jdbc4.jar")
con <- dbConnect(postgres,
2011 Dec 21
1
Reg : Using RJDBC to read UTF-8 characterrs
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
2011 Jun 26
1
RJDBC and multiple classpaths
Corect me if this is not the right place to post this.
I have a mdbdriver.jar (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
2007 Mar 05
0
RJDBC
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,
2010 Oct 12
1
append rows to Sybase datatable using RJDBC
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 trying to append 'data' to the existing
2007 Dec 14
1
RJDBC to OpenOffice Calc as RODBC to MS Excel
Under Windows, I have used RODBC to connect to Excel spreadsheets as per
the example below:
library(RODBC);
connect = odbcConnectExcel("testdata.xls");
query = "SELECT [data$.ethn], [data$.sex], [data$.age],
[data$.height], [data$.weight],
[label$.label]
FROM [data$], [label$]
WHERE [data$.ethn] = [label$.ethn];"
data =