Validation not working with SAP HANA

[pitwegner]

Hi, we just realized that the library fails queries using jdbc on a HANA database. The validation query "SELECT COUNT (*) FROM SYSTABLES" (DBI-pool.R, Line 46) fails in HANA because the table does not exist. It is rather "SYS.TABLES" or "SYS_TABLES" instead.

Minimal example:

pool_sap <- pool::dbPool(
  drv = RJDBC::JDBC(driverClass="com.sap.db.jdbc.Driver", classPath="/opt/jdbc/ngdbc.jar"),
  url = "jdbc:sap://db.url.de:30015/?autocommit=false",
  user = "user",
  password = "pwd"
)
result <- pool::dbGetQuery(pool_sap, "select * from table_smth;")
Error: Object does not appear to be valid. Error message: Validation not successful -- Unable to retrieve JDBC result set
  JDBC ERROR: SAP DBTech JDBC: [259] (at 21): invalid table name:  Could not find table/view SYSTABLES in schema user: line 1 col 22 (at pos 21)
  Statement: select count(*) from systables
In addition: Warning message:
It wasn't possible to activate and/or validate the object. Trying again with a new object. 

[pitwegner]

Also setting validateQuery to something like SELECT 1 results on the same error. So somehow the other validations are performed nevertheless.