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