similar to: JDBC DB access in R

Displaying 20 results from an estimated 1000 matches similar to: "JDBC DB access in R"

2005 Feb 22
1
Rdbi and ODBC
I have been using RODBC for a while with no complaints (R 2.0.1 patched under WinXP), then I saw a link (http://grass.itc.it/statsgrass/r_and_dbms.html) showing that Rdbi claims to run a query in 5 seconds that takes RODBC 4.3 minutes. That was hard enough for me to believe that I wanted to try some tests myself, but I cannot get Rdbi to connect to my ODBC database. Here is what works for RODBC
2006 Jul 19
2
voronoi tessellations
Okay, been working with tripack, seems the most mature package for this. Got it to work well with their test data set - data(tritest). When i tried random numbers to explore further, i am getting some results that don't reconcile. example run this: library(tripack) y <- runif(100) x <- runif(100) vm <- voronoi.mosaic(x,y) plot(vm) par(new=T) plot(x,y,col='blue') when
2017 Nov 30
1
How to count instructions in a function?
Thanks so much John! That works :) Previously I wrote a pass that inherited from CallGraphWrapperPass and used its getCallGraph() function within runOnModule() which resulted in segmentation faults for me. Not sure why that happened, perhaps callgraph wasn't setup by the time runOnModule() was called internally. If you know why, kindly enlighten me and perhaps document the behavior for the
2005 Feb 22
6
rodbc or unixodbc error
Hi, I'm trying to establish a connection to a MySQL database, and am using the rodbc package for it. This is in a GNU/Debian Linux box, with the corresponding Debian unstable packages. I can login to my MySQL databases from any shell and directory, so the problem is probably not there. Here's an example of what I'm doing: R> odbcConnect("test",
2004 Apr 20
1
multi-user engine
hello, i just got introduced to R - WOW its beautiful.. I am presently a SAS user and wanted to configure R to work in a multi-user enteprise environment. Client - Server. Where we have a strong LINUX server supporting about 10 statisticians with R. Anyone have any backround or information they can share to help me get jump-started on setting up R in this environment? Does each user have
2008 Sep 14
5
string functions
Hello, trying to locate all the string commands in the base version of R, can't seem to find an area that describes them. I am in need to do some serious parsing of text data to create my dataset. Is there a summary link to all the character operators? string manipulations that would help in parsing text.
2017 Nov 29
2
How to count instructions in a function?
Hello, I am trying to count IR instructions in a function for static analysis using llvm pass. In contrast with existing examples, I am trying to include instruction counts of all the callees of the function. Counting the instructions of a function is easy using passes, but iterating through the module's CallGraph is proving to be confusing. I believe I have to use CallGraphWrapperPass to
2006 Sep 04
8
ActiveRecord-JDBC is coming along
The ActiveRecord-JDBC adapter is rapidly maturing these days. I got the full set of AWDwR2 migrations to run with it against MySQL last night, and Ola Bini has gotten migrations working well against Oracle and Firebird. We also have SQL Server support running most of our test cases (under non-Windows environments too!) and have started adding support for Derby and HSQLDB (Java-based DBs). Things
2003 Oct 31
2
Therotical basis of Kriging
hello I want to know about therotical basis of Kriging in elemantary level. I will appreciate if anyone sends me address,link,e-documents, etc.. kind regards -- Ahmet Temiz General Directory of Disaster Affairs Ankara TURKEY ______________________________________ Inflex - installed on mailserver for domain @deprem.gov.tr Queries to: postmaster at deprem.gov.tr
2008 Jun 02
1
RJDBC cant find driver class in JDBC jar file
I would like to set up a Windows XP environment with R and MySQL. This set-up was recommended by a friend who uses this set up, but I have been unable to get RJDBC to work. I have installed all of the software today (June 2 2008), first deleting and then replacing old versions of software. The error is as follows: Error in .jfindClass(as.character(driverClass)[1]) : class not found This error
2009 Jun 11
1
GRASS raster data processing
Hi, I just imported two raster maps into R using the SPGRASS6 package, one containing elevation data and the other containing an erosion index: Kar_inc <-readRAST6("Incis_Kar", plugin=FALSE) Kar_dem <- readRAST6("DEM_Kar", plugin=FALSE) I just wanted to make a xy plot of erosion parameter vs elevation. How does this work? I don't get how to handle
2010 Oct 28
2
ActiveRecord JDBC error Generated keys not requested
I''m getting the following error while connecting to mysql using activerecord-jdbcmysql-adapter (1.0.2). Rails 3.0.1. ActiveRecord::JDBCError: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().: SET SQL_AUTO_IS_NULL=0 This occurs not matter what application I run it in to e.g. rake, rails
2006 May 19
6
bayesian belief networks to determine causality
Hello, does R estimate belief networks to estimate chains of causality. Anyone point me to the right direction, or the most developed library? looking at DEAL>
2012 Oct 04
1
Intermittent connectivity issues for JDBC / Oracle
I have been experiencing issues with an R script hanging when connecting to an Oracle database. To help debug, I found a function here in the nabble forum and made a small test script: #!/usr/bin/Rscript --no-restore --no-save --no-init-file library("RJDBC") drv<-JDBC("oracle.jdbc.OracleDriver","/home/oracle/lib/ojdbc6.jar", "'") dbCheck =
2004 May 02
2
r dev site is down
the R developer site has been down for some time, what gives? http://developer.r-project.org/
2009 Sep 26
3
evaluate a set of symbols within an IF statement
Hello, writing some R code to cleanse a data set, if the following set of symbols are identified then perform some actions. trying to write the minimum code to do this. tname = "VIX" checkticker = c("VIX", "TYX", "TNX", "IRX") if (tname == checkticker) { //perform some operations } result i get is > tname == checkticker
2006 Oct 09
1
accesing MySQL through JDBC
Hi all, Completely new to this list and completely new to R so, please, accept my apologies in advance if any question is too basic or out of place. Thanks. After reading some docs, googling around and searched the mail lists I've only found spare references to accessing databases. Among these references, few are related with JDBC and none of them include both MySQL and JDBC access. Our
2009 May 25
2
cairoDevice.dll error, but it exists..?
Hello, running windows vista, R2.9. Installed the following libraries: (*latticist*, *playwith* and *Cairo*) Wanted then to run, to evaluate the visualization features: >data(iris) >library(latticist) >latticist(iris) However, i tested my desktop and laptop and get the following error after typing latticist(iris): latticist(iris) Loading required package: playwith Loading
2017 May 19
1
Null pointer dereference?
I was curious if this was a real null pointer dereference issue in R-devel/src/library/grDevices/src/devPS.c on line 1009? 1000: static type1fontinfo makeType1Font() 1001: { 1002: type1fontinfo font = (Type1FontInfo *) malloc(sizeof(Type1FontInfo)); 1003: /* 1004: * Initialise font->metrics.KernPairs to NULL 1005: * so that we know NOT to free it if we fail to 1006: *
2008 Apr 21
3
optFederov/AlgDesign - help avail?
Hello, we are needing to generate optimal (Fractional) designs for discrete choice applications, where we will be using logistic regression or multinomial logit as the modeling technique. It looks like optFederov, in the AlgDesign package may work, but not sure if this algorithm works when the variable of interest is binary or nominal? Anyone who are experts in this area, anyone interested