Provides Access to Databases Through the JDBC Interface
Overview
The RJDBC package is an implementation of R's DBI interface using JDBC as a back-end. This allows R to connect to any DBMS that has a JDBC driver.
- dbSendQuery() and dbSendUpdate() now remove named arguments
only from ... but not from list= to enable single-row
updates from data frames along the lines of list=iris[1,].
- dbWriteTable() failed for data frames with exactly one row,
because it used the form shown above for updates which will
fail with JDBC ERROR: Parameter at position 1 is not set
since all elements are named and thus none were set.
- merging arguments from
...andlist=was not always done
correctly, in some cases list= would overwrite ...
arguments.
(Note: all of the above are 0.2-9 regressions related to the
changes in handling of prepared statement arguments)
Show all changes in 0.2-10Hide the rest of the changes in 0.2-10
- add dbIsValid() methods for JDBCConnection and JDBCResult (#89)
From NEWS in the release
Install
Health
NOTEDESCRIPTION meta-informationr-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-oldrel-macos-arm64, r-oldrel-macos-x86_64, r-patched-linux-x86_64, r-release-linux-x86_64, r-release-macos-arm64, r-release-macos-x86_64
r-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-oldrel-macos-arm64, r-oldrel-macos-x86_64, r-patched-linux-x86_64, r-release-linux-x86_64, r-release-macos-arm64, r-release-macos-x86_64
License stub is invalid DCF.
r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc
Licence stub is invalid DCF.
NOTECRAN incoming feasibilityr-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc
Maintainer: ‘Simon Urbanek <Simon.Urbanek@r-project.org>’
No Authors@R field in DESCRIPTION.
Please add one, modifying
Authors@R: person(given = "Simon",
family = "Urbanek",
role = c("aut", "cre"),
email = "Simon.Urbanek@r-project.org")
as necessary.- NOTE3 OK, 10 NOTE2026-09-08
- ERROR3 OK, 9 NOTE, 1 ERROR2026-09-07
- NOTE3 OK, 11 NOTE2026-04-06
- ERROR3 OK, 10 NOTE, 1 ERROR2026-04-04
- NOTE3 OK, 11 NOTE2026-03-10
Documentation
- Help pages
- 7
- Examples that run
- 0%1 never run
- Exported functions with examples
- 100%
- Documented parameters
- 100%
- Return-value docs
- 100%
- Help pages citing references
- 14%
Downloads
Dependencies
Installing RJDBC adds 2 packages (1 with compiled code, 1.3 MB of source tarballs). Heaviest: DBI 727 KB, rJava 624 KB.
Code & Tests
People & History
Pick two releases to compare their code metrics.
- RR 4.6.0 released · 2026-04-24
- RR 4.5.0 released · 2025-04-11
- RR 4.4.0 released · 2024-04-24
- RR 4.3.0 released · 2023-04-21
- RR 4.2.0 released · 2022-04-22
- 0.2-10Latest
- RR 4.1.0 released · 2021-05-18
- RR 4.0.0 released · 2020-04-24
- 0.2-82020-03-10 · diff ↗
- RR 3.6.0 released · 2019-04-26
- RR 3.5.0 released · 2018-04-23
- 0.2-7.12018-04-16 · diff ↗
- 0.2-72018-01-24 · diff ↗
- RR 3.4.0 released · 2017-04-21
- RR 3.3.0 released · 2016-05-03
- RR 3.2.0 released · 2015-04-16
Show 24 earlier eventsHide 24 earlier events
- 0.2-52014-12-19 · diff ↗
- 0.2-42014-06-26 · diff ↗
- RR 3.1.0 released · 2014-04-10
- 0.2-32013-12-14 · diff ↗
- 0.2-22013-12-03 · diff ↗
- RR 3.0.0 released · 2013-04-03
- 0.2-1
- 0.2-0
- RR 2.15.0 released · 2012-03-30
- RR 2.14.0 released · 2011-10-31
- RR 2.13.0 released · 2011-04-13
- 0.1-62011-03-10 · diff ↗
- RR 2.12.0 released · 2010-10-15
- RR 2.11.0 released · 2010-04-22
- RR 2.10.0 released · 2009-10-26
- RR 2.9.0 released · 2009-04-17
- RR 2.8.0 released · 2008-10-20
- RR 2.7.0 released · 2008-04-22
- 0.1-52007-10-07 · diff ↗
- RR 2.6.0 released · 2007-10-03
- RR 2.5.0 released · 2007-04-24
- 0.1-32007-02-22 · diff ↗
- 0.1-22007-01-24
- RR 2.4.0 released · 2006-10-03
Package metadata
- First published
- 2007-01-24
- Total releases
- 14 / 19 yrs
- License
- MIT + file LICENSE OSI · relicensed from GPL-2 in 0.2-7
- Minimum R
- ≥ 2.4.0
- Download size
- 24 KB
Cite
Cite this package
Run in R for the authors' preferred citation:
citation("RJDBC")Cite the R Observatory
For a number measured here: a download total, a coverage figure, an archival date.
From data release v2026-10-22, which the citation names so these numbers can be found later. More on citing and the projects behind them.