[R-sig-DB] Null values from DBI connection

[Albert Vernon Smith]

I am connecting to an Oracle database with RJDBC, and creating a data frame with dbGetQuery.  When I get values return, values which are NULL in the database are being returned as 0 from my query.  How can I have them returned as <NA>?

I am querying as follows.

--
require(RJDBC)

drv <- JDBC("oracle.jdbc.driver.OracleDriver","/usr/local/ojdbc/ojdbc14.jar","'")
conn <- dbConnect(drv, "dbc:oracle:thin:@ADDRESS","user","pass")
results <- dbGetQuery("select rownum, col1 from table where col1 is null")
--

> results

  ROWNUM COL1
1       1    0
2       2    0
3       3    0
4       4    0
5       5    0

I'd rather see:

> results

  ROWNUM COL1
1       1    NA
2       2    NA
3       3    NA
4       4    NA
5       5    NA

--

-albert