Displaying 1 result from an estimated 1 matches for "1392_1_result".
2011 Feb 03
3
Reg : read missing values from database using RJDBC
...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-tp325...