Ver 10.0.18

Add support for datetimeoffset datatype. Published on maven central.

Dependency Example for maven:

<dependency>
    <groupId>se.alipsa</groupId>
    <artifactId>R2JDBC</artifactId>
    <version>10.0.18</version>
</dependency>
<dependency>
      <groupId>org.renjin.cran</groupId>
      <artifactId>DBI</artifactId>
      <version>1.0.0-b9</version>
      <scope>provided</scope>
</dependency>
<dependency>
      <groupId>joda-time</groupId>
      <artifactId>joda-time</artifactId>
      <version>2.10.1</version>
      <scope>provided</scope>
</dependency>

<!-- a the JDBC driver of choice depending on what database you are connecting to -->
<dependency>
      <groupId>org.apache.derby</groupId>
      <artifactId>derby</artifactId>
      <version>10.14.2.0</version>
      <scope>test</scope>
</dependency>

Example usage:

library("org.renjin.cran:DBI")
library("se.alipsa:R2JDBC")

drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver")
con <- dbConnect(drv
  , url="jdbc:sqlserver://mydbserver:1433;databaseName=fancy;"
  , user="mmbla"
  , password="s3cretpassword"
)

# Execute the query:
fancyDf <- dbGetQuery(con, "Select * from sometable")
dbDisconnect(con)

# Do some stuff with the data frame:
str(fancyDf)
m_fancyDf <- colMeans(fancyDf)