similar to: R packages for R 2.11.1

Hi All, We are using the following dataset which contains UTF-8 characters and is stored in a MySQL database. When we use RODBC and read the data, the characters are read correctly.But when we read using RJDBC ,the characters are read like ???????????????????????????1 Can you please let me know how we can read the UTF-8 characters as it is done by RODBC. ID code Outlook Temperature Humidity

Hi R-helpers , can you please let me know the methods in which NULL values can be handled in R? Are there any generic commands/functions that can be given in a workspace,so that the NULL values occuring in that workspace (for any datasets that are loaded , any output that is calculated) , are considered in the same way? Thanks in advance. -- View this message in context:

Hi R-helpers, i am using the following dataset.This dataset is stored in a mysql database. W(x) pH(y) 10 1 15 1 20 4 5 7.5 3 13 9 5 11.5 13.5 3 16 2 1 9.6 1 I am using RJDBC package to read the data from the database into a dataFrame.The commands used are, jdbcDriver<-JDBC(driverClass="com.mysql.jdbc.Driver",

I am desperate for help. I am trying to get the RJDBC and rJava .5to work on both my windows xp and linux Redhat EL5 Server. On both I get a ava.lang.ClassNotFoundException when calling JDBC(). My example is require(RJDBC) classPath='C:\\libraries\\mysql-connector-java-5.1.3-rc\\mysql-connector-java-5.1.3-rc-bin.jar' driverClass=c("com.mysql.jdbc.Driver") drv <-

Hi, Our data has column names with spaces in that.The names in dataFrame are, *[1] "Sepal Length" "Sepal Width" "Petal Length" "Petal Width" "Species" * When i try to use the column names in rpart function, it gives the following error. * rp<-rpart(as.factor(`Species`)~`Sepal Length`) Error in `[.data.frame`(frame, predictors) :

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

Dear all I am trying to use the ODB package to connect to an libreoffice-odb database. The libreoffice package is german, thus, decimal separator is a comma. However, I can open the database and upload a it without error, library(ODB) db <- odb.open("Test.odb") but a soon as the "odb.open" command is executed, the decimal separator in R is changed to comma. Before

Dear List, Java Exception error while reading large data in R from DB using RJDBC. I am trying to read large data from DB table(Vectorwise), using RJDBC connection. I have tested the connection with small size data and was able to fetch DB tables using same connection(conn as in my code). Please suggest where am i going wrong or alternate option to solve such issues while reading large DB

I have a client running Microsoft SQL Server. I am interested in ways of accessing data from this server using R. I would welcome any information about how this can be done. I have a reasonable grasp of SQL and have experience with MySQL and RODBC but don't know anything much about Microsoft SQL Server. David Scott -- _________________________________________________________________

I have a query after finding an error running Rtools on a Windows machine. I am trying to build an update to the R fda library using Rtools27 under Windows XP Pro. This is the current fda library on RForge: http://r-forge.r-project.org/projects/fda Following R CMD build, R CMD check produces the following error in 00Install.out: installing R.css in F:/work/RForge/fda.Rcheck make: ***

Hi, I'm working with R on Cassandra and need to install RJDBC on my Ubuntu virtual machine. The traditional commands (install.packages(RJDBC, dep=TRUE) and library(RJDBC)) don't work: they throw an error that they can't find the package. I tried installing it using the Rkward GUI, but can't write to any of the pre-set directories because of permissions issues. When I try running

Hi, My data has column names which has ` character. For example , *> names(dataframe) [1] "`region" "farmsize`" "farmincome" "maincrop" "claimvalue"* If i use these objects in my function, the following error is thrown. *lmm<-lm(``region`~farmincome) Error: attempt to use zero-length variable name* Is there a way, say an escape

After installing RJDBC on RedHat Linux and using it successfully with mySQL JDBC driver i am trying to use it with Oracle database. I use the JDBC driver that works fine elsewhere (use it in DBVizualizer). However, when i try to load the driver, drv<-JDBC("oracle.jdbc.driver.OracleDriver", "/home/az05625/DBdrivers/ojdbc6.jar", identifier.quote="`") it gives me

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Dear all Backend is Ingres DBMS I use RJDBC with Ingres JDBC driver I have this csv file "","Strategy","par1","m.1997.09.01" "1","ALF",2,0.1244 which I try to load it RJDBC require (RJDBC) drv <- JDBC("com.ingres.jdbc.IngresDriver","/home/ingres/ingresv1/ingres/lib/iijdbc.jar") conn <- dbConnect(drv,

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Trying to install the above two packages via the "install.packages("package_name")" command and the "R CMD INSTALL file.tar.gz". I receive the following error either way "sh: ./configure: /bin/sh: bad interpreter: Permission denied". I have tried to chmod and chown permissions and also ran dos2unix in hopes that there is a CRLF in some of the tar.gz files,

Good Morning, I'm trying to install the rJava package on a local (work) machine and having some trouble. The following occurred in an RGui session. > sessionInfo() R version 2.13.0 (2011-04-13) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252 [3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C [5]

Hi All, I was using the following command for performing kmeans for Iris dataset. Kmeans_model<-kmeans(dataFrame[,c(1,2,3,4)],centers=3) This was giving proper results for me. But, in my application we generate the R commands dynamically and there was a requirement that the column names will be sent instead of column indices to the R commands.Hence, to incorporate this, i tried using the R

Rjdbc consistently gives me an execution error with postgresql 9.0s JDBC4 driver. It's probably something trivial so am including my code below: library("RJDBC") param <- 249 param2 <- 188129 postgres <- JDBC("org.postgresql.Driver", ".m2/repository/postgresql/postgresql/9.0-801.jdbc4/postgresql-9.0-801.jdbc4.jar") con <- dbConnect(postgres,