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", classPath="E:/PAS/trunk/lib/mysql-connector-java-5.1.13-bin.jar", identifier.quote = NA) conn<-dbConnect(jdbcDriver,"jdbc:mysql://localhost/mysql","root","sa") dbSendQuery(conn,"SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED") dataFrame<-dbReadTable(conn,"1392_1_Result") But, the resulting dataFrame has 0.0 /0 in place of the missing values.Can you please let me know how i can avoid this and retain the missing values as NA in my dataFrame? -- View this message in context: http://r.789695.n4.nabble.com/Reg-read-missing-values-from-database-using-RJDBC-tp3257766p3257766.html Sent from the R help mailing list archive at Nabble.com.
Hi R-helpers, Did any of you get a chance to look into this issue?i am kind of stuck in my work due to this..Is there any R command/option that can be used to overcome this? Regards, Raji -- View this message in context: http://r.789695.n4.nabble.com/Reg-read-missing-values-from-database-using-RJDBC-tp3257766p3310591.html Sent from the R help mailing list archive at Nabble.com.
Hi All, This seems to be a bug with RJDBC package and it has been fixed in the latest RJDBC_0.1-6 version. I would like to try out RJDBC_0.1-6. can you please guide me to a link where i can find the 64-bit RJDBC_0.1-6.zip . I could find the 32-bit version at http://cran.sixsigmaonline.org/bin/windows/contrib/2.11/ ? Thanks in advance. -- View this message in context: http://r.789695.n4.nabble.com/Reg-read-missing-values-from-database-using-RJDBC-tp3257766p3874809.html Sent from the R help mailing list archive at Nabble.com.
On 05.10.2011 17:10, Raji wrote:> Hi All, > > This seems to be a bug with RJDBC package and it has been fixed in the > latest RJDBC_0.1-6 version. I would like to try out RJDBC_0.1-6. can you > please guide me to a link where i can find the 64-bit RJDBC_0.1-6.zip . I > could find the 32-bit version at > http://cran.sixsigmaonline.org/bin/windows/contrib/2.11/ ?RJDBC_0.2-0 seesm to be recent and binaries are available for recent versions of R on all CRAN mirrors. If you need a binary for an ancient version of R, you have to compile it yourself. Uwe Ligges> > Thanks in advance. > > -- > View this message in context: http://r.789695.n4.nabble.com/Reg-read-missing-values-from-database-using-RJDBC-tp3257766p3874809.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.