[DRILL-8227] JConnect and jTDS JDBC drivers do not implement Connection::getSchema

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.20.2
• Component/s: 1.19

Environment

 Apache drill - 1.19.0 , jdk1.8.0_121 , jre1.8.0_121 , Windows 10 Enterprise

• Assignee: James Turton
• Reporter: Nishanthi
• Created: 17/May/22 07:37
• Updated: 10/Aug/22 13:36
• Resolved: 27/May/22 05:46

Description

Hi ,

In Apache drill - 1.19.0 not able to execute a Sybase ASE related query getting exception as org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: AbstractMethodError: com.sybase.jdbc4.jdbc.SybConnection.getSchema()Ljava/lang/String

jar - jconn4,
"driver": "com.sybase.jdbc4.jdbc.SybDriver" ,
"url": "jdbc:sybase:Tds:?<server-name>:<server-port>/<dbname>"

Query :
select * from <storage-plugin-name>.<schema-name>.<table-name>

Able to execute the query for same configuration with same jar and  driver in apache drill 1.17.0 but not in apache drill 1.19.0.

Kindly, look into it as it is coming as a blocker while trying to query with sybase ase

Issue Links

• duplicates: DRILL-8226 In Apache drill - 1.19.0 not able to execute a sybase related query getting exception as org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: AbstractMethodError: com.sybase.jdbc4.jdbc.SybConnection.getSchema()Ljava/lang/String.