similar to: accesing MySQL through JDBC

Hi, Please, is out there anybody using RMySQL under Mac OS X? I'm trying to build it without much success. How must I add/locate mysql.h and lmysqlclient library? Thanks for your help, Ricardo -- Ricardo Rodr?guez Your EPEC ICT Team

Hi all! I do hope question from newcomers are wellcome here! Thanks in advance. Trying to catch up and to acquired the needed background to easily read R documents it is being a bit hard to me to get into the required concepts to deal with data. I am trying to get data from a MySQL database and plotting it with barplot. Here the code... library(RMySQL) con <- dbConnect(dbDriver

Hi, Following an example I've received from Phil Spector, I am trying to get a remote file by using download file. The concerned remote server doesn't username and password passed with the URL, thus this line fails... download.file('http://username:password@xepecnet.environmentalchange.net/xwiki/bin/view/ICT/RGraphicSample02','RG02',method='wget') I can get a

Please, is it possible to pass an username and a password to source() to access code stored in restricted access web server? I know I can use commands like... > source("http://mire.environmentalchange.net/~webmaster/R/3Dsurface.r") but I am not able to find if it is possible to pass authorization parameters together with the link. Thanks you for your help, Ricardo -- Ricardo

Hi Ricardo and everybody In this old post to rhelp you say that the problem was solved but not what the sollution was. I have the same problem now. I want to read a Excel file from a google site that has restricted access so I need to give a username and password at some point. I could not find an example or a help file that shows how this can be done. You post is one of few but it does not

Hi all, Please, while using image() which is the graphical parameter which control the space between ylab and the y axis? I do need to write a number of relatively long y labels and I am not able the control, if possible, this space. See the effect I need to avoid... http://nvx.environmentalchange.net/@rrodriguez/images/overlapping.jpg Thanks for your help, Ricardo -- Ricardo Rodr?guez Your

hi to all, it is posible to use activerecord-jdbc with the jdbc-odbc bridge? i have problems to use ajax_scaffold. i get an error message, that the driver is unable to choose type for date from(list of datatypes) my database.yml look like development: adapter: jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver url: jdbc:odbc:ac43demo username: ac_odbc password: ac_odbc i have modified the

hi all, I am having a hard time trying to find out what''s wrong with my setup. It used to work smoothly until I decided out of the blue to do a selfupdate and upgrade outdated on MacPort, then things started going south very quickily. Since MacPort kinda broke, I pull it all out and re-install the ports I have before, which went pretty smoothly. Then to my surprise any command I

CentOS Errata and Bugfix Advisory 2018:1411 Upstream details at : https://access.redhat.com/errata/RHBA-2018:1411 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) x86_64: 36b6e7066fd5a7027bbf9d71d115f5717b0030f853ae2c523907947fe4c82f13 postgresql-jdbc-9.2.1002-6.el7_5.noarch.rpm

CentOS Errata and Security Advisory 2020:3285 Important Upstream details at : https://access.redhat.com/errata/RHSA-2020:3285 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) x86_64: 4085f09e7be4410758ded16aeb5fca59795cf4c2ad37a1afa78cddf45bef6806 postgresql-jdbc-9.2.1002-8.el7_8.noarch.rpm

CentOS Errata and Security Advisory 2020:3284 Important Upstream details at : https://access.redhat.com/errata/RHSA-2020:3284 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 7da24f52d632e4a7bfe00e2133a719c22e6927e21c74a8c4a584b001aeb35df8 postgresql-jdbc-8.4.704-4.el6_10.noarch.rpm x86_64:

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

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

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 =

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

I'm getting a MacBook and I'd like to stick with OS X rather than convert it to Linux just yet. However, my main concern is having decent performance. What's my best option: *use the existing binary for R? *compile R fresh under OS X? * install Linux and run R under that? Does anyone have any recent experience they can share? Thanks! -- I can answer any question. "I

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? -zubin

Due to some XML issues, we installed *1.6 from Sun jdk-6u20-nb-6_8-linux-ml.sh on Centos. * ** *below is the output from *[root at www2 tmp]# alternatives --config java There are 3 programs which provide 'java'. Selection Command ----------------------------------------------- 1 /usr/lib/jvm/jre-1.4.2-gcj/bin/java * 2

Hola, A lo mejor la solución pasa por ver si Statgraphics puede exportar su fichero a otro formato de cualquiera de los que R sí que puede leer. No sé si además del fichero, tienes acceso a Statgraphics.... Saludos, Carlos Ortega www.qualityexcellence.es El 12 de junio de 2013 13:26, Roberto <rv.tec@zoho.com> escribió: > Hola, es la primera lista en la que participo, espero no meter

I'm new to R - and trying to create a plot similiar to the spider plot at http://www.statgraphics.com/eda.htm#radar . I can't figure out several things... most of which I would think would be straightforward.... How can I change the lines for each series plotted instead of creating a filled area? How can I get the labels for each of the radial axes at the outside of the plot