[
https://issues.apache.org/jira/browse/DRILL-8227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538789#comment-17538789
]
ASF GitHub Bot commented on DRILL-8227:
---------------------------------------
jnturton commented on PR #2551:
URL: https://github.com/apache/drill/pull/2551#issuecomment-1129938286
> I have two comments:
>
> 1. We might want to change the log level to `warn` here instead of
info.
>
> 2. What happens if we eat the error message? Does the schema still
get defined somewhere? I didn't see that anywhere and it looks like it is
causing an NPE in one of the unit tests. More unit tests would be nice as
well.
I'll change it to a warning. Already present in the plugin code (not in this
PR) are an attempt to default the schema in the event that the JDBC driver
doesn't supply it, and also logic for the case when both routes fail and
leaving `defaultSchema = null`. I'll add a MSSQL testcontainer and new test
suite since that's the only sane way I can see to unit test this.
> 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)
