DatabaseConnector
DatabaseConnector copied to clipboard
OHDSI
An R package for connecting to databases using JDBC.
With some recent release of a dependency (unsure which), the dbplyr interface no longer works for duckdb when joining more than 2 tables in a single statement. The reason for...
Hi, I am using DatabaseConnector6.3.2 and I am having the following error when executing the DatabaseConnector::executeSql() function: print(connectionDetails$dbms) sql
This was discussed in the last HADES meeting and I think it would be good to implement something that we can say is our best practice principles for working with...
Hi @schuemie, @edward-burn, @catalamarti, and I would like get the Darwin tools working with DatabaseConnector as a DBI database driver. I think to do this we would like to change...
Use `rJava::J("java.lang.System")$getProperty("java.version")` to get the Java version.
Expected result DBI::dbCreateTable will create a new table in the database with the requested field names and datatypes. Actual result: `#> Error in fields[FALSE, ]: incorrect number of dimensions` ```...
DatabaseConnnector exports multiple valid methods for some DBI methods. Method selection is then somewhat ambiguous and done by R. Expected behavior - There is one unique method selected for a...
Expectation: DBI::dbIsValid(connection) should return false if the connection is closed. Actual behavior: DBI::dbIsValid(connection) returns true when the connection is closed in this postgres example. ``` con TRUE DBI::dbDisconnect(con) # this...
The dev version of odbc exports the classes it defines, so once it's on CRAN you can use them, rather than redefining yourself (https://github.com/OHDSI/DatabaseConnector/blob/bee58a314996123b59e08bd489bf712e14391c4f/R/DBI.R#L61-L70). This will avoid conflicting classes definition...
