[
https://issues.apache.org/jira/browse/DRILL-8227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538688#comment-17538688
]
ASF GitHub Bot commented on DRILL-8227:
---------------------------------------
jnturton opened a new pull request, #2551:
URL: https://github.com/apache/drill/pull/2551
# [DRILL-8227](https://issues.apache.org/jira/browse/DRILL-XXXX): JConnect
and jTDS JDBC drivers do not implement Connection::getSchema
## Description
Swallow and log the AbstractMethodError thrown when we call this method in
the mentioned drivers. The default schema for the plugin will default to the
first one in the list of schemas returned by the connection in this instance.
## Documentation
N/A
## Testing
What do we want to do about testing this? One option would be to add a new
MSSQL testcontainer which gets unit tested through the jTDS driver. The
resulting test coverage of MSSQL might be nice to have in general...
> JConnect and jTDS JDBC drivers do not implement Connection::getSchema
> ---------------------------------------------------------------------
>
> Key: DRILL-8227
> URL: https://issues.apache.org/jira/browse/DRILL-8227
> Project: Apache Drill
> Issue Type: Bug
> Components: 1.19
> Affects Versions: 1.19.0
> Environment: Apache drill - 1.19.0 , jdk1.8.0_121 , jre1.8.0_121 ,
> Windows 10 Enterprise
> Reporter: Nishanthi
> Assignee: James Turton
> Priority: Major
> Fix For: 1.20.2
>
> Attachments: Sybase_Exception.png, jTDS_Error.png, sqlline_log.png
>
>
> 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
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
