[R] JDBC DB access in R

[zubin]

Thanks for the reply - thru R i have large data sets in oracle, mssql,
postgres and we have jdbc drivers for all of them - most of these systems
are on UNIX/LINUX and ODBC is not used - we use JDBC to hit the DB's usually
in java applications we have.  other than that we are a large SAS shop and i
am trying to find an alternative to SAS, i think R has a good chance.

For R and SQL - i assume using the wrapper below is the easiest way to hit
databases via SQL - are there any other ways i am missing?  or is JDBC route
the easiest when ODBC is not available?

not sure if R contains some standard database routines that i am not seeing?

also

does R have some good data manipulations function - if so, could you point
me in the right direction (similiar to DATA steps in SAS)

-thx!


-----Original Message-----
From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk]
Sent: Saturday, October 23, 2004 3:03 AM
To: zubin
Cc: r-help at stat.math.ethz.ch
Subject: Re: [R] JDBC DB access in R


The J is for Java (I presume, you did't actually say), and R is written in
C.  So `all' you need to do is to call a Java wrapper from R and call JDBC
from that.  I believe it has been done via RSJava.

But if all you want to do is to retrieve a dataframe, isn't this rather
hard work?

On Fri, 22 Oct 2004, zubin wrote:

> Hello, i see packages referencing using ODBC access to databases via R,
are
> there any packages that use JDBC to submit SQL to a database and return
into
> a data frame?

--
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595