[R] Reg : read missing values from database using RJDBC

[Raji]

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.