Ver 10.0.25

• Removed dependency on Joda Time
• Make dateTime retrieval more robust
• Upgrade jdbc drivers used in test

Ver 10.0.24

• Upgrade h2 dependency
• Workaround for RowNamesVector changes in renjin master compared to 0.9.2716 (now works in all versions)
• upgrade slf4j version
• upgrade testcontainers versions

Ver 10.0.23

• upgrade dependencies (h2, maven site plugin)
• improve bigint support for postgresql (when detected as int8)
• add support for bigserial

Ver 10.0.22

• Add support for CHARACTER VARYING data type (e.g. H2)
• Version bump of dependencies.

Ver 10.0.21

• mysql has a BIGINT UNSIGNED type; treat it as a regular BIGINT for now.
• Version bump of dependencies.

Ver 10.0.20

Add support for the "name" datatype (e.g. in postgresql). To use r2jdbc in Renjin R, add the following dependencies:

<dependency>
        <groupId>org.renjin.cran</groupId>
        <artifactId>DBI</artifactId>
        <version>1.0.0-b9</version>
</dependency>
<dependency>
        <groupId>se.alipsa</groupId>
        <artifactId>R2JDBC</artifactId>
        <version>10.0.20</version>
</dependency>
<dependency>
        <groupId>joda-time</groupId>
        <artifactId>joda-time</artifactId>
        <version>2.10.5</version>
</dependency>

Ver 10.0.19

Fix for Sql server when url contains username/password. Add unit tests using TestContainer with Docker. Version bump of dependencies. To use r2jdbc in Renjin R, add the following dependencies:

<dependency>
        <groupId>org.renjin.cran</groupId>
        <artifactId>DBI</artifactId>
        <version>1.0.0-b9</version>
</dependency>
<dependency>
        <groupId>se.alipsa</groupId>
        <artifactId>R2JDBC</artifactId>
        <version>10.0.19</version>
</dependency>
<dependency>
        <groupId>joda-time</groupId>
        <artifactId>joda-time</artifactId>
        <version>2.10.2</version>
</dependency>

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)

Ver 10.0.17

Fix for boolean datatype on postgres (announced as "bool" type)

First release of fork

R2JDBC is a renjin extension providing database connectivity. It is Based on the renjin-dbi (https://github.com/bedatadriven/renjin-dbi). Most of the changes consists of support for more data types.