similar to: ROracle/DBI problem with dbExecStatement on RH Linux

Hello, Attached is a mail regarding question how to insert Date field using ROracle package. I am stuck with this problem and appreciate receiving help from gurus on this list. Code used mainly is: library(ROracle) ### --- Version 0.53 drv <- dbDriver("Oracle") con <- dbConnect( drv, "user/passwd") d <- data.frame(CDATE = "2004-03-10 10:12:00") ps

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 os solaris2.8

Hi all, I've been playing with ROracle (0.5-9) for a few days and I can't wrap my mind around this one. Here's a sample of my R (2.4.0) session. my.df<-data.frame(prd_id=c(123,456),vol_factor=c(.123,.456)) > my.df prd_id vol_factor 1 123 0.123 2 456 0.456 > library(ROracle) Loading required package: DBI >

An update to the ROracle package is now in CRAN. Version 0.5-0 * This version has an experimental 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

Dear Mysql & R users, first of all a big thanks to the authors of RMySQL. I got the following table; mysql> describe UserClick; +----------------+-------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges |

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as

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

Full_Name: Christian Hoffmann Version: 2.4.0 OS: Win 2000 Submission from: (NULL) (193.134.202.252) Database queries using the combination DBI + ROracle are handicapped by quirks in the pipeline between the textual representation of the query and the database engine Oracle. Comments and linefeed at start are interfering: dbGetQuery(conn, query): works: dbGetQuery(conn, "select *

Hello, I have installed the ROracle and DBI packages, and I want to access an Oracle database that is not on the same machine as the one I am running R on. I can access the database remotely with perl DBI and Java JDBC. Does anyone know if this is possible using R DBI/ROracle ? I have looked through the documentation and also tried to guess at things which might work, but with no success. I

Hi, Has anyone seen this problem before, and does anyone have a solution? When I query a database using DBI and ROracle to retrieve a date in a format other than the system default, I get a core dump. System: Redhat Linux 7.3 uname: Linux 2.4.20-20.7smp #1 SMP Mon Aug 18 14:46:14 EDT 2003 i686 Oracle version 8i R --version: R 1.7.1 (2003-06-16). DBI_0.1-6, ROracle_0.5-0 Start up R, load

Hi everyone, I have been following these forums closely for the last few months but this is my first time posting. Basically I am trying to get an Oracle SQL Developer Binary Large Object(BLOB/CLOB) file in as an R object in R. For those not familiar with a BLOB/CLOB file, it is basically lik a table that has cells that contain tables or files. By converting the large table into a BLOB/CLOB file

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

Begin forwarded message: > From: Arno Ouwehand <arno at stat.ucla.edu> > Date: Wed Jul 3, 2002 16:00:54 America/Los_Angeles > To: fernando.pineda at jhu.edu > Cc: deleeuw at stat.ucla.edu > Subject: RMySQL and Mac OS X > > I got it working, initially I had the same problem (using R1.5.0 and Mysql-3.23.49 ) > Then I installed the R 1.5.1 MetaPackage from

Hi all!! I would like to know if anyone has experienced this behaviour with ROracle package. I'm attaching information to reproduce the issue. Bug maybe? Thank you very much for your attention. Ramon. ################################################################## ################################################################## oraExecStatement BUG : RS-DBI driver: (ORA-02005:

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

I am curious about the opinionated opinion behind the decision.Was it performance? Complexity? Databases support or something else. I recently used Ruby:dbi and liked all the metadata that comes with the data. Performance looked good but I didn''t benchmark it so I don''t know which one execute faster. If I am not wrong Ruby:dbi offers true parameters binding which would be nice

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd" db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

Hi, Just wondering: does anybody know if ActiveRecord has been built entirely from scratch or if it''s inherited (a lot of) functionality from ruby-dbi? Jeroen

I an run a simple DBI app fine no issues. When trying it on FCGI on my server I get this error: Could not load driver (undefined local variable or method `e'' for DBI:Module) Anyone got any idea why this would error using FCGI? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk"