RJDBC
RJDBC copied to clipboard
s-u
R interface to databases using JDBC
## Summary RJDBC has an incompatibility with the DBI generic interface, which can be fixed by implementing a method for DBI::dbSendStatement() that calls RJDBC::dbSendUpdate(). I think this is a one-line...
Hi all -- thank you for your great software! We have been using RJDBC 0.2-8 with MS SQL Server backend; unfortunately we recently ran into issues trying to upgrade to...
Hello As mentioned in #61 and #74, some drivers don't respect JDBC specs about column names vs column labels. The fix you proposed and implemented works fine! (tested for Sas)...
Splitting off from a older separate issue, since it seems specific to Oracle and new problem: https://github.com/s-u/RJDBC/issues/55 Oracle Version: Oracle Database 19c Enterprise Edition 19.0.0.0.0 -- Version 19.17.0.0.0 It seems...
Since version 0.2-10 there are some issues with datatype conversion from SAP HANA tables. High precision 0 values return as character 0E-8 instead of double 0.0000000 RJDBC 0.2-08:  RJDBC...
If you are interested, I took a stab at this for https://github.com/s-u/RJDBC/issues/95
Currently, if you have a multi-schema database, you cannot access schema specifically using the - DBI::Id functionality. - https://dbi.r-dbi.org/reference/id - ```r table
Querying SQL via ODBC with MS-SQL Server is not supported on MacOs using MFA (see the [Microsoft ODBC driver feature matrix](https://docs.microsoft.com/en-us/sql/connect/driver-feature-matrix?view=sql-server-ver16#table2)). According to the same document, JDBC is supported. How...
I am running the following code to connect directly to snowflake using a jdbc driver. ``` DBI::dbConnect(RJDBC::JDBC(driverClass = "net.snowflake.client.jdbc.SnowflakeDriver", classPath = "[location]/snowflake-jdbc-3.13.18.jar"), "jdbc:snowflake://[web address]/?authenticator=externalbrowser") ``` With version 0.2-8, this code...
- adds support for integers (`INTEGER` and `SMALLINT` are read as integers) - adds support for NA values for integers and real values: NA values are writing as NULL and...
