search

tidyverse / dbplyr

Database (DBI) backend for dplyr
https://dbplyr.tidyverse.org
Other
469 stars 169 forks source link

Error in ._jobjRef_dollar(x[["jobj"]], name) : no field, method or inner class called 'use_cli_format' #1523

Open DSLituiev opened 6 days ago

DSLituiev commented 6 days ago

This issue is supposedly partially solved in #1186 but I still run into it:

setup

setClass("Oracle", slots=list(), contains = "JDBCConnection")
drv <- JDBC("oracle.jdbc.driver.OracleDriver", "~/lib/instantclient_19_8/ojdbc8.jar")
conn_ <- dbConnect(drv, ...)
conn <- new("Oracle", jc = slot(conn_, "jc"))

dbplyr

tbl(conn, in_schema("MYSCH",  "MYTABLE_W_BLOB"))

# Error in ._jobjRef_dollar(x[["jobj"]], name) : 
#  no field, method or inner class called 'use_cli_format'

DBI

 dbExecute(conn, 'SELECT  * FROM "MYSCH"."MYTABLE_W_BLOB" FETCH FIRST 6 ROWS ONLY')

# Error in .jcall(rp, "I", "fetch", stride, block) : 
 # java.sql.SQLException: Invalid column type: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor

version: 2.5.0.9000