Displaying 9 results from an estimated 9 matches for "dbmanag".
Did you mean:
dbmmanage
2002 May 17
1
RMySQL/methods problem
I have a problem when using the RMySQL package and the methods package
together (R version 1.5.0)
I do :
library(RMySQL);
m<-dbManager('MySQL')
con<-dbConnect(m);
quickSQL(con, ' select blah blah..');
This works fine . However when I then do:
library(methods);
and then repeat my sql :
quickSQL(con, ' select blah blah..');
I get the following error:
Error in getClass(Class) : "MySQLResultSet&qu...
2007 Jun 02
1
setClass with a slot of RODBC
Hi - I tried to get some answer before but there seems to have no one response. My question is that I have a class like below definition:
setClass("DBManager",
representation(channel="RODBC"))
My purpose of the conn slot is to hold a channel to database connection which is returned by a command like:
channel <- odbcConnect("DB", uid="user", pwd="password")
According to RODBC documentation, this ch...
2008 Sep 15
2
S4 coercion responsibility
...quot;, contains=c("SQLiteConnection","integer"))
[1] "SQLConPlus"
> conPlus <- new("SQLConPlus", con, 1)
> dbListTables(con)
character(0)
> dbListTables(conPlus)
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (invalid dbManager handle)
> dbListTables(as(conPlus, "SQLiteConnection"))
character(0)
>
The problem is happening in sqliteExecStatement which does
conId <- as(con, "integer")
but con only *contains* an SQLiteConnection and the other integer
causes confusion. If the line were...
2002 Oct 16
5
Database newbee problem...
Hi all,
This is a potentially very stupid question about MySQL <-> R
interaction, but I have not been able to solve it.
I'm just trying to connect R to my MySQL databse, and gets this:
> library(RMySQL)
Loading required package: methods
> m <- dbDriver("MySQL")
> con <- dbConnect(m,group="testdb")
Process R segmentation fault at Wed Oct 16 07:04:30
2002 Feb 12
0
ROracle: Call function name not in load table
Hi,
I've just installed the ROracle package. The library loads okay but when I
try to instantiate a database manager I get an error:
> ora <- dbManager("Oracle")
Error in .Call("RS_Ora_init", config.params, reload) :
.Call function name not in load table
Has anyone had any experience with using this package?
Regards,
Gavin Kennedy
Software Engineer - Bioinformatics
CSIRO Mathematical and Information Sciences
Gav...
2002 Aug 28
0
segfault in RMySQL
Hi all,
I have experimented a segmentation fault error using
RMySQL_0.4-6 library in R 1.5.1.
Look the sequence:
-------------------------------------------
> library(RMySQL)
> m <- dbManager("MySQL")
> m
<MySQLManager:(1137)>
> describe(m)
<MySQLManager:(1137)>
Driver name: MySQL
Max connections: 10
Conn. processed: 0
Default records per fetch: 500
Open connections: 0
> con <- dbConnect(m)
Process R segmentation fault at Wed Aug 2...
2007 Jun 03
1
[R] setClass with a slot of RODBC
An embedded message was scrubbed...
From: David James <daj025 at gmail.com>
Subject: Re: [R] setClass with a slot of RODBC
Date: Sat, 02 Jun 2007 10:32:47 -0400
Size: 4053
Url: https://stat.ethz.ch/pipermail/r-devel/attachments/20070603/f3583feb/attachment.mht
2002 Aug 09
2
RMySQL fetch defaults to N=500?
It appears that fetch() gets only the first 500 rows by default. I
don't see this in the documentation, but
timeinfo <- fetch(rs)
gets only 500 rows where
timeinfo <- fetch(rs,n=-1)
gets (correctly) 736 for the same query. Is this an undocumented
feature? I played with this data for an alarming amount of time
before I realized that I was missing a third of the data. I
2002 Jan 15
3
R for large data sets
Hi All,
As a part of our regular data analysis, I have to read in large data sets
with six columns and about a million rows. In Splus, this usually take a
couple of minutes. I just tried R, it seems take forever to use read.table()
to read in the data frame! It did not help much even though I specified
colClasses and nrows in read.table().
How is R's ability to analyze large data sets? I