http://blog.gmane.org/gmane.comp.lang.r.db hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.lang.r.db/731 <pre>Hello. Does sqlSave support appending to a table with a computed column? In my attempt, RODBC will not allow the append because I have "missing columns in 'data'" If I create a column in my dataframe as a place holder for the computed column in the table and then try to append the data RStudio experiences an unhandled exception and crashes. Thanks for any advice you might have. Mikael [[alternative HTML version deleted]] _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB-0bNBQ1PAWB4BXFe83j6qeQ&lt; at &gt;public.gmane.org https://stat.ethz.ch/mailman/listinfo/r-sig-db </pre> Mortensen, Mikael - Marketing 2012-05-25T20:52:44 http://comments.gmane.org/gmane.comp.lang.r.db/728 <pre>We are trying to attach R to our ODBC driver via RODBC. Unfortunately we're getting Segmentation faults in odbcConnect (error detailed below). We would like to attach a debugger to whatever process is communicating with UnixODBC/our driver, but are not sure where to start. R itself seems to be a large bash script, ideally we could inject "gdb --args" before the execution of some process in that script to get the desired results. Any guidance is much appreciated. *** caught segfault *** address 0x100000abb, cause 'memory not mapped' Traceback: 1: .Call(C_RODBCDriverConnect, as.character(connection), id, as.integer(believeNRows)) 2: odbcDriverConnect(st, ...) 3: odbcConnect("sql1010odbc") </pre> Christopher A. Simon 2012-05-17T20:06:22 http://comments.gmane.org/gmane.comp.lang.r.db/723 <pre>Getting frustrated using R with MySQL (on Debian Squeeze). I can connect to mySQL database and I can execute simple queries. But, having various difficulties executing queries with multiple statements separated by ";". Set the client.flag to CLIENT_MULTI_STATEMENTS but still having difficulties. Questions: are the RMySQL and RODBC packages really meant just for simple, one line queries? Can anyone point me to where I might learn how to execute more complicated queries with in R? Thanks! Mark _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB-0bNBQ1PAWB4BXFe83j6qeQ&lt; at &gt;public.gmane.org https://stat.ethz.ch/mailman/listinfo/r-sig-db </pre> Mark Moon 2012-05-17T14:59:38 http://comments.gmane.org/gmane.comp.lang.r.db/721 <pre>Hello, when I query a MySQL database using the commands con &lt;- dbConnect(MySQL(), user=dbuser, password=dbpasswd, dbname=dbname, host=dbhost) df &lt;- dbGetQuery(con, sql) I get the following message when a table contains the timestamp type: RS-DBI driver warning: (unrecognized MySQL field type 7 in column 1 imported as character) I googled and found a post on this mailing list from 2006: https://stat.ethz.ch/pipermail/r-sig-db/2006q3/000221.html Obviously this is still not fixed. Are there any plans to do so? Thanks, Andreas R version 2.15.0 (2012-03-30) Platform: i686-pc-linux-gnu (32-bit) locale: [1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C [3] LC_TIME=de_CH.UTF-8 LC_COLLATE=en_US.UTF-8 [5] LC_MONETARY=de_CH.UTF-8 LC_MESSAGES=en_US.UTF-8 [7] LC_PAPER=C LC_NAME=C [9] LC_ADDRESS=C LC_TELEPHONE=C [11] LC_MEASUREMENT=de_CH.UTF-8 LC_IDENTIFICATION=C attached base packages: [1] stats graphics grDevices utils datasets methods base other attache</pre> Andreas Voellenklee 2012-05-09T14:05:20 http://comments.gmane.org/gmane.comp.lang.r.db/711 <pre>Greetings, I'm not sure if this is the right list for this subject so if not please point me there. rpart() and some other R libraries now have model scoring output in PMML through the pmml library. I do some consulting in predictive modeling and often the companies require SQL case statement code or C# or some other language. I know there are things such as the Oracle solution for in database scoring but this is somewhat different in that typically the IT shops will want the scoring code as the deliverable and then run it natively in the data warehouse they have. Most (all?) commercial data mining and modeling packages have SQL as one of the options for scoring code. SAS eMiner for instance can deliver code in several languages. So can Angoss, KXEN, etc. Does anyone know of an equivalent to the pmml library in SQL? Thomas Brandenburger Assistant Professor Department of Mathematics and Statistics South Dakota State University Cell: 605.480.0951 Fax: 605.688.5880 thomas.brandenburger-B3sqeG8WtU+Vc3sc</pre> Brandenburger, Thomas 2012-04-19T15:11:11 http://comments.gmane.org/gmane.comp.lang.r.db/710 <pre></pre> siddharth arun 2012-04-14T14:58:27 http://comments.gmane.org/gmane.comp.lang.r.db/709 <pre>I understand that reading date time fields through ODBC can be problematic. When reading a table containing several MS Access date time fields, some are correctly read, others are not. In the snippet below, both DateTimeFld1 and DateTimeFld2 are formatted identically within MS Access. When read in through RODBC date times in the first field are truncated to dates, but the second field imports correctly. I have tried this from both MS Access .mdb and .accdb files, and tried both the odbcConnect and odbcConnectAccess2007 functions with the same results. When using odbcConnect, I have specified a dsn created by C:\Windows\SysWOW64\odbcad32.exe driver? Please advise if there may be a solution to reliably handle date time fields from MS Access. Snippet: PK DateTimeFld1 DateTimeFld2 1 41910 2004-04-26 2004-04-27 02:00:00 [[alternative HTML version deleted]] _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB-0bNBQ1PAWB4BXF</pre> Anthony S Fischbach 2012-03-27T18:50:12 http://comments.gmane.org/gmane.comp.lang.r.db/707 <pre>Can any one tell how can I find return on the CRSP equally-weighted protfolio from a given set of data from CRSP? </pre> siddharth arun 2012-03-26T23:25:45 http://comments.gmane.org/gmane.comp.lang.r.db/706 <pre>I want to forecast using GARCH function. Can any one help how to do it? </pre> siddharth arun 2012-03-26T23:22:37 http://comments.gmane.org/gmane.comp.lang.r.db/702 <pre>Hi there, I'm pretty new to the use of R with a newly created schema SQLite database. I've been looking to the vignettes and to some examples, but I couldn't find a pretty basic task: i.e. inserting a row in a table only if it doesn't exist. if it does, I would either update or do nothing. this is a simple table in my database variation_id name reference_allele validation_status 1 1 rs123 A not_validated 2 2 rs234 C validated 3 3 rs345 T not_validated and this the small test dataframe I'd like to insert data from variants=data.frame(variation_id=c(1,2,3),name=c("rsNN","rsXX", "rs123"), reference_allele=c("A","C","T"), validation_status=c("not_validated","validated","not_validated")) based on SQL commands I was tempted to write something like dbBeginTransaction(db) query &lt;- paste('IF NOT EXISTS (SELECT * FROM variation WHERE name = :name)', 'INSERT INTO "variation"', "VALUES(NUL</pre> Lescai, Francesco 2012-03-20T12:28:28 http://comments.gmane.org/gmane.comp.lang.r.db/700 <pre>I've setup RStudio server and pointed it to use an existing R (2.13) installation. ROracle works fine when accessed from R, but the same does not work from RStudio web-interface. Loading required package: DBI Error in .oci.Driver() : ROracle internal error [rociDrvInit, 1, -1] "/etc/rstudio/rserver.conf" has rsession-which-r=/usr/local/R/bin/R rsession-ld-library-path=/u01/app/oracle/product/11.1.0/db_1/lib:/u01/app/oracle/product/11.1.0/db_1 There is an existing path environment variable defined $ env |grep LD_LIB* =/u01/app/oracle/product/11.1.0/db_1/lib:/u01/app/oracle/product/11.1.0/db_1 RStudio web-interface was giving me the above mentioned issue. I added the path in rserver.conf and restarted the RStudio server but the problem still exists. [[alternative HTML version deleted]] _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB-0bNBQ1PAWB4BXFe83j6qeQ&lt; at &gt;public.gmane.org https://stat.ethz.ch/mailman/listinfo/r-sig-db </pre> Sai Munikuntla 2012-03-15T15:31:35 http://comments.gmane.org/gmane.comp.lang.r.db/698 <pre>Hello. This is a copy of my email to r-sig-deb I'm trying install roracle in my debian 64 bit system. I've read the http://cran.r-project.org/web/packages/ROracle/INSTALL and I've installed Oracel Instant Client by rpm package (using alien to deb convert). When I try to install I write export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib:$LD_LIBRARY_PATH in terminal and then I download ROracle_1.1-1.tar.gz from cran and I type sudo R CMD INSTALL ROracle_1.1-1.tar.gz where I've downloaded the tar.gz file. I always get the same error jose&lt; at &gt;jose-laptop:~/Descargas$ sudo R CMD INSTALL ROracle_1.1-1.tar.gz * installing to library '/usr/local/lib/R/site-library' * installing *source* package 'ROracle' ... ** package 'ROracle' successfully unpacked and MD5 sums checked configure: error: OCI libraries not found ERROR: configuration failed for package 'ROracle' * removing '/usr/local/lib/R/site-library/ROracle' and I don't understand why. any idea? Thanks. [[alternative HTML version deleted]] ______</pre> jose luis cañadas 2012-03-06T21:27:22 http://comments.gmane.org/gmane.comp.lang.r.db/697 <pre>Hi, I've encountered a snag when trying to create a dataframe from FileMaker data. For what it's woth, I'm uising FileMaker Pro 11, FileMaker's ODBC driver, and ODBC Administrator on MacOS Lion. I am able to sucessfully make the connection. Thus, executes and gives no error messages. However, gives a list of all of the label names of the table (53 in all), but without the variables. confirms this: The editor labels the columns correctly, but the cells are empty. Is this expected behavior, or a bug? Have I overlooked something? Any and all help appreciated! Thank you, </pre> Rolf Marvin Bøe Lindgren 2012-02-23T22:02:11 http://comments.gmane.org/gmane.comp.lang.r.db/696 <pre>Dear R-users, I have to read data from a worksheet that is available on the Internet. I have been doing this by copying the worksheet from the browser. But I would like to be able to copy the data automatically using the url command. But when using "url" command the result is the source code, I mean, a html code. I see that the data I need is in the source code but before thinking about reading the data from the html code I wonder if there is a package or anoher way to extract these data since reading from the code will demand many work and it can be not so accurate. Below one can see the from where I am trying to export the data: dados&lt;-url(" http://www.mar.mil.br/dhn/chm/meteo/prev/dados/pnboia/sc1201_arquivos/sheet002.htm","r ") I am looking forward any help. Thanks in advance , Nilza Barros [[alternative HTML version deleted]] _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB-0bNBQ1PAWB4BXFe83j6qeQ&lt; at &gt;public.gmane.org https://stat.ethz.ch/</pre> Nilza BARROS 2012-02-12T00:49:07 http://comments.gmane.org/gmane.comp.lang.r.db/693 <pre>Dear R Users and Experts, I got a MySQL table with German special characters (umlaute like ä,ö,ü etc.) . The MySQL database table is in the UTF8 format, and if I submit a query over the MySql client the umlaute are displayed correctly. If I submit the same query via R the umlaute are displayed wrong. That is a little confusing for me, R as well as the MySQL support UTF8. Is there any option which I should use to get the umlaute in R correct? Thanks, Henri \xd6sterreichische Schilling ... _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB-0bNBQ1PAWB4BXFe83j6qeQ&lt; at &gt;public.gmane.org https://stat.ethz.ch/mailman/listinfo/r-sig-db </pre> Henri Mone 2012-02-08T18:24:38 http://comments.gmane.org/gmane.comp.lang.r.db/691 <pre>Hi, I am curious as how to connect to an informix database. I believe this to be possible from what I found but have absolutely no idea how to. If somebody could point me in the right direction please let me know. I posted this on the nabble forum and got no response. Thank you, Scott [[alternative HTML version deleted]] _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB-0bNBQ1PAWB4BXFe83j6qeQ&lt; at &gt;public.gmane.org https://stat.ethz.ch/mailman/listinfo/r-sig-db </pre> Scott Randall 2012-01-25T22:20:20 http://comments.gmane.org/gmane.comp.lang.r.db/687 <pre>Hi, First, my apologies for a lengthy email. I have been trying to get connectivity between R and Oracle over the past few days (I am new to R, but know Oracle and Linux). I have tried both RODBC and ROracle methods to connect, but having issues with both. Below is our environment, what I have done, and the issues to date. I would much appreciate any help on this, as I'm not sure what to do now. Our server: - RHEL 5.7 64-bit - Oracle 11.2.0.3 64-bit - R version 2.14.0 (2011-10-31) 64-bit i.e. .Machine$sizeof.pointer = 8. _RODBC_ I have installed unixODBC-2.2.14, as I had issues with the standard RHEL 2.2.11. Also installed is the following Oracle 11.2.0.3 64-bit instant client software: - instantclient-basic-linux.x64-11.2.0.3.0 - instantclient-odbc-linux.x64-11.2.0.3.0 - instantclient-precomp-linux.x64-11.2.0.3.0 - instantclient-sdk-linux.x64-11.2.0.3.0 - instantclient-sqlplus-linux.x64-11.2.0.3.0 With the unixODBC 2.2.11 rpm, I kept getting the error with isql: isql: symbol lookup error: </pre> Stuart Uren 2011-12-21T01:27:32 http://comments.gmane.org/gmane.comp.lang.r.db/686 <pre>Hi all, I have recently created a new project/package on r-forge, "easydb". http://easydb.r-forge.r-project.org/ In short: - This package provides a simplified interface to SQLite, MS Access and MySQL (on top of RSQLite and RODBC); - Identical interface (= same functions &amp; arguments) for these 3 databases; - Data subsetting style similar to data.frame, with single square brackets myDatabase[ "myTable", row_constrains, col_name ] - Intended to be user friendly; - Similar to what had been done by John Fox and Oswaldo Cruz in their package dfdb-rodbc; - Database connection handled internally; - Some SQL queries handled internally; - Minimal operation log system, to keep track of operations done on a database; - Internally handles SQL's "LAST_INSERT_ID()" for the 3 databases; Limitations: - Not intended to replace DBI and RODBC. Only the most common operations are covered. - Not designed for speed (but rather usability) All functions are documented + I made a vignette too that cover the most important oper</pre> Julien Moeys 2011-12-06T09:42:49 http://comments.gmane.org/gmane.comp.lang.r.db/685 <pre>Hi all, A new version of RSQLite is available. Details on new features and fixes below. Thanks to Gabor Grothendieck for some useful bug reports and feature suggestions. + seth Version 0.11.0 - Enhance type detection in sqliteDataType (dbDataType). The storage mode of a data.frame column is now used as part of the type detection. Prior to this patch, all vectors with class other than numeric or logical were mapped to a TEXT column. This patch uses the output of storage.mode to map to integer and double vectors to INTEGER and REAL columns, respectively. All other modes are mapped to a TEXT column. - Detection of BLOBs was narrowed slightly. The code now treats only objects with data.class(obj) == "list" as BLOBs. Previously, is.list was used which could return TRUE for lists of various classes. - Fix bug in sqliteImportFile (used by dbWriteTable) that prevented a comment character from being specified for the input file. - Increase compile-time SQLite limits for maximum number of col</pre> Seth Falcon 2011-12-01T21:52:19 http://comments.gmane.org/gmane.comp.lang.r.db/682 <pre>I am having an issue compiling and installing ROracle. My knowledge of R is very limited so I am looking for any advice on ways I can troubleshoot and/or solve this issue, i.e. logs, commands, patches, etc. My environment is as follows: Operating System - Red Hat Enterprise Linux AS release 4 (Nahant Update 6) Linux atlqtfldplz01 2.6.9-78.0.1.ELhugemem #1 SMP Tue Jul 22 18:23:25 EDT 2008 i686 i686 i386 GNU/Linux R version 2.14.0 (2011-10-31) Platform: i686-pc-linux-gnu (32-bit) Trying to install ROracle_0.5-12.tar.gz Oracle Client: 10.1.0.3.0 (32bit) ORACLE_HOME=/mass/oracle/product/10.1.0.3.0 LD_LIBRARY_PATH=/mass/oracle/product/10.1.0.3.0/lib Installed R libraries: # /mass/bin/R --slave -e 'cat(rownames(installed.packages()), "\n")' base bitops boot caTools chron class cluster codetools corpcor datasets DBI digest ellipse fAssets fBasics fCopulae fda fields foreign fPortfolio gdata getopt glpk gplots graphics grDevices grid gtools Hmisc KernSmooth lars lattice leaps limSolve lpSolve MASS Matrix metho</pre> Bowling, Brad 2011-11-14T23:12:31 http://comments.gmane.org/gmane.comp.lang.r.db/679 <pre>Dear all, I have two problems while using R and PostgreSQL 9.0 and need some help. 1) I want to import tables from a specific PostgreSQL-Database into R. Connecting R to PostgreSQL using dbConnect worked, but instead of showing just the tables in the requested database, R returned every single table from all databases. I used these commands: conRLP &lt;- dbConnect(pgSQL(), user = "postgres", password = "pw”, dbname = "Data RLP") dbListTables(conRLP) and now instead of just the 15 tables from “Data RLP” I need, I see a list of all tables. Is there a way to just show the tables that are in Data RLP? My session info: R version 2.13.2 (2011-09-30) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=German_Germany.1252 LC_CTYPE=German_Germany.1252 LC_MONETARY=German_Germany.1252 LC_NUMERIC=C LC_TIME=German_Germany.1252 attached base packages: [1] stats graphics grDevices utils datasets methods base 2) I tried to install RPostgreS</pre> Meike Börder 2011-11-10T10:51:33 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.lang.r.db