search for: dbexecstatement

...and David James for the pointer) for resolving the problem of the empty rows returned from ROracle. However, I have a problem still: > library(ROracle) > ora <- dbDriver("Oracle") > con <- dbConnect(ora, user = USER, password = PWD, dbname = DBNAME) > rs <- dbExecStatement(con, "select * from USER_TABLES") Error in .class1(object) : No direct or inherited method for function "dbExecStatement" for this call dbSendQuery/dbGetQuery work fine. I've reinstalled ROracle 0.5-5 and DBI 0.1-8 from source on RH Linux Enterprise WS release 3 Taroon...

...) d <- data.frame(CDATE = "2004-03-10 10:12:00") ps <- dbPrepareStatement(con, "INSERT into DATEST (CDATE) VALUES ( :1 ) ", bind=c( "character")) ## -- c("date") does not work sapply(d, class) d$CDATE <- as.character(d$CDATE) sapply(d, class) dbExecStatement(ps,d) Error in oraExecStatement(ps, data, ...) : RS-DBI driver: (ORA-01861: literal does not match format string ) Thanks for your help in advance, Swami (smalladi at lexgen.com) ----------------------------- Correspondence with David James ----------------------- Dear David, Thanks...

Hello everybody, I found that queries (send by "dbExecStatement" ) with more than 4000 characters length produces an error in ROracle (ver 0.3-3). Maybe there is a limitation of 4kB.... Is this a bug? If yes, is this problem solved in the latest version of ROracle (ver 0.5-0)? My system information: platform sparc-sun-solaris2.8 arch sparc...

...Engine | varchar(30) | | | | | select,insert,update,references | | URL | text | | | | | select,insert,update,references | +----------------+-------------+------+-----+---------+-------+----------------- I access it via: rs<-dbExecStatement(con,"SELECT * from UserClick") res<-fetch(rs) Things go wrong withthe URL entry which is of type text; $Engine [1] "Armintest" "Test" "Voila" $URL $URL[[1]] NULL ... Any ideas of how I could fix that would be highly appreciated. If it's n...

Is it true that append=T does not work in assignTable() in RMySQL ? More specifically: I cannot append a data.frame to an existing table in a MySQL database, although I can use the same data.frame to create a new table. Even more specifically: > assignTable(con,"employee",dita,append=T) Error in execStatement.MySQLConnection(con, statement, ...) : RS-DBI driver: (could not

...onnect(m, dbname = "r", user="xxx", password="xxx") > >describe(m) > <MySQLManager:(1924)> > Driver name: MySQL > Max connections: 10 > Conn. processed: 1 > Default records per fetch: 500 > Open connections: 1 > > s <- dbExecStatement(c, "select * from user") > > data <- fetch(s, n = -1) > > print (data) > > etc. > > Sincerely, > > Arno Ouwehand > UCLA Department of Statistics > > p.s. Jan, maybe you could submit this to the r-help mailinglist > > === Jan de Leeuw; Profes...

...l dynamic SQL binding to data frames. SQL statements can be "prepared" (parsed and cached for improved performance), and columns of data frames bound to them for automatic data transfer). For details see the help() for "Oracle", "dbPrepareStatement" and "dbExecStatement". * Host arrays are now operational. These are buffers used by Oracle's internal implementation to reduce network traffic and speed up fetches and prepared statements. Currently fetches use a default buffer size (host arrays) of size 500 (previous version did no buffering). **Ve...

...1 456 0.456 the above works as expected. Now let's try to insert new rows into mytable using a prepared statement and bind variables: > ps<-dbPrepareStatement(conn,"insert into mytable (prd_id,vol_factor) values (:1,:2)",bind=c(rep("numeric",2))) > res<-dbExecStatement(ps,my.df) > dbCommit(conn) [1] TRUE > dbGetQuery(conn,"select * from jdomenge_test") PRD_ID VOL_FACTOR 0 123 0.123 1 456 0.456 2 123 NA 3 456 NA so the 2 new rows were appended, except the values in the second column were seemingly not read.....

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

Dear List, Would anyone know how to perform prepared queries with ROBC ? I had a shot with some of the internal (non-exported) functions of the package but ended up with a segfault, so I prefer asking around before experimenting further... Thanks, Laurent

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