Displaying 20 results from an estimated 500 matches similar to: "dbHasCompleted() always returns TRUE for POSTGRES Database with RJDBC?"
2003 May 22
0
Question on dbHasCompleted(...)
All,
In the following, when I just enter R from UNIX and make a connection to
Oracle database, dbHasCompleted(rs) is TRUE. This shouldn't have happened
since I haven't fetched any thing. Help will be appreciated.
-MY
---------------------------------------------------------------------
MyUnixMachine% R
R : Copyright 2003, The R Development Core Team
Version 1.7.0 (2003-04-16)
R is
2010 Jun 21
0
RSQLite and fetching rows from multiple tables
I'm trying to use RSQLite statement to cycle through a large database
in "chunks" via the fetch(...,n=20000). As far as I can tell,
however, it keeps re-fetching the same beginning set of rows -- any
ideas what might be wrong with the following code? The select
statement is pulling from multiple tables. I apologize in advance --
the DB is about 4gb so I can't make it easily
2003 Nov 11
0
Installing and Loading RMySQL on OS X 2.8
Hello,
I have trouble installing and loading the RMySQL package on OS X 2.8.
The package seems to install from source fine (using R package manager
from within the R environment). I have the following error when I try
to load the package:
loading package: RMySQL
Error in dyn.load(x, as.logical(local), as.logical(now)) :
unable to load shared library
2007 Mar 20
1
RMySQL load error
I'm having trouble getting RMySQL to load. I was able to build it and install
it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37.
I've read many postings about this but have not found a mention of my
particular problem (some closely related). I get the "unable to load shared
library, no such file" error, but all the files do exist, RMySQL.so and
2005 Mar 09
1
RMySQL installed but not availalable
I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere!
Tom
> -----Original Message-----
> From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz]
> Sent: Thursday, 10 March 2005 5:13
2012 Dec 28
0
How to apply XPath query on XML nodes separately?
Dear R experts,
I try to extract certain child nodes from an XML document and construct a
table in which the parent node names are the columns and the child id
values, joined in a list, are the cell content.
If I first apply an XPath query to extract all above parent nodes, then
iterate over those nodes and again apply a XPath query to select their
child nodes, I get *ALL* matching child nodes
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",
2003 May 12
1
Problem in fetching from Oracle
Dear all,
I tried the following in R:
>library(ROracle)
>ora <- dbDriver("Oracle")
>channel <- dbConnect(ora, user = "scott",
password="tiger",dbname="abcdef")
>rs <- dbSendQuery(channel, "select * from USArrests")
>while(!dbHasCompleted(rs))
{
xxx <- fetch(rs, n = 5000)
}
+ + + > xxx
Error: Object
2003 Feb 06
0
rdbi segmentation fault
hi! i am experiencing the same behaviour explained here:
http://finzi.psych.upenn.edu/R/Rhelp02/archive/2482.html
(i copied the message below)
has anybody found a solution?
here is the code that gives me a segmentation fault
library(Rdbi)
library(Rdbi.PgSQL)
conn <- dbConnect(PgSQL(), dbname = "PGA")
tmp <- "create table test ( expid int, name varchar(128));"
2003 Feb 06
1
rdbi segmentation fault (fwd)
one more bit of information about this problem. If I start R as the
user "postgres" i dont have the segmentation fault.
---------- Forwarded message ----------
Date: Wed, 5 Feb 2003 19:19:39 -0500 (EST)
From: Rafael A. Irizarry <ririzarr at jhsph.edu>
Reply-To: rafa at jhu.edu
To: "R-Help (E-mail)" <r-help at r-project.org>
Subject: rdbi segmentation fault
hi! i
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
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
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,
2006 Oct 27
0
RMySQL and stored procedures
Hi,
I use RMySQL to connect to MySQL server where I have a couple of stored
procedures.
I know that the function for the stored procedures "is not yet
implemented", but I was trying to
get around the problem connecting like that:
drv <- dbDriver("MySQL")
con <- dbConnect(drv,user=MyUser, password=MyPasswd, dbname=MyDBName,
host=MyHost, client.flag="196608"
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,
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,
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,
2012 Feb 09
0
Java heap space Error while reading table from postgres database using RJDBC
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 <- mydir$db_server_lgn
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,