[
https://issues.apache.org/jira/browse/DRILL-8227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538607#comment-17538607
]
Nishanthi commented on DRILL-8227:
----------------------------------
Hi [~dzamo] / [~cgivre] ,
Thanks for the response , I tried using jTDS driver and got exception as below.
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
AbstractMethodError
jTDS jar - jtds-1.3.1
plugin configuration used as below:
{
"type": "jdbc",
"driver": "net.sourceforge.jtds.jdbc.Driver",
"url": "jdbc:jtds:sybase://<server-name>:<server-port>;DatabaseName=<dbName>",
"username": "xxxx",
"password": "****
",
"sourceParameters": {
"connectionTestQuery": "SELECT 1"
},
"enabled": true
}
PFA screenshots for reference: !sqlline_log.png!!jTDS_Error.png!
As mentioned in the Description in apache drill 1.17.0 we were using Tds driver
with jconn4 jar and it is executing the query as expected but same thing is
giving AbstractMethod exception in apache drill 1.19.0 . Kindly, let us know if
you have any information/findings regarding this behavior.
Will post the updates on apache drill 1.20.1 shortly.
> 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.
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> 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
> 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)
