I am trying to get the fields of a table in an Arctic database. For that I've been successful at creating a jdbcConnection object which is of class "JDBCConnection", but once I write the following code to get the fields of the AR_LOT table (dbListFields comes from DBI package),
dbListFields(jdbcConnection, name = Id(schema = "ARCTIC", table = "AR_LOT"))
I get the following error message.
Error in dbSendQuery(conn, paste("SELECT * FROM ", dbQuoteIdentifier(conn, : Unable to retrieve JDBC result set JDBC ERROR: ORA-00933: SQL command not properly ended Statement: SELECT * FROM "ARCTIC"."AR_LOT" LIMIT 0
I also tried with RJDBC's function dbGetFields, but I'm also running into an error.
Error in .jcall(md, "Ljava/sql/ResultSet;", "getColumns", .jnull("java/lang/String"), : method getColumns with signature (Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet; not found
The weird thing is that dbReadTable from DBI package works just fine.
Can anyone please help me understand these error messages a little more clearly? Thanks in advance