Re: [R] Reg : read missing values from database using RJDBC
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@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. __ R-help@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.
Re: [R] Reg : read missing values from database using RJDBC
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. __ R-help@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.
Re: [R] Reg : read missing values from database using RJDBC
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. __ R-help@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.
[R] Reg : read missing values from database using RJDBC
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.53 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. __ R-help@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.