search for: dbmanag

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...

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...

...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...

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

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...

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...

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

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

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