[
https://issues.apache.org/jira/browse/DRILL-4200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15059838#comment-15059838
]
Karol Potocki commented on DRILL-4200:
--------------------------------------
This [thread|http://stackoverflow.com/a/2306051] might be helpful.
The issue seems related with
[DRILL-3882|https://issues.apache.org/jira/browse/DRILL-3882].
> drill-jdbc-storage: applies timezone to java.sql.Date field and fails
> ---------------------------------------------------------------------
>
> Key: DRILL-4200
> URL: https://issues.apache.org/jira/browse/DRILL-4200
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Other
> Affects Versions: 1.3.0
> Environment: drill-jdbc-storage plugin configured (based on
> https://drill.apache.org/docs/rdbms-storage-plugin) with
> org.relique.jdbc.csv.CsvDriver to access dbf (dbase) files.
> Reporter: Karol Potocki
>
> When using org.relique.jdbc.csv.CsvDriver to query files with date fields
> (i.e. 2012-05-01) causes:
> {code}
> UnsupportedOperationException: Method not supported: ResultSet.getDate(int,
> Calendar)
> {code}
> In JdbcRecordReader.java:406 there is getDate which tries to apply timezone
> to java.sql.Date which probably is not timezone related and this brings the
> error.
> Quick fix is to use ResultSet.getDate(int) instead.
> Details:
> {code}
> Caused by: java.lang.UnsupportedOperationException: Method not supported:
> Result
> Set.getDate(int, Calendar)
> at org.relique.jdbc.csv.CsvResultSet.getDate(Unknown Source)
> ~[csvjdbc-1
> .0-28.jar:na]
> at
> org.apache.commons.dbcp.DelegatingResultSet.getDate(DelegatingResultS
> et.java:574) ~[commons-dbcp-1.4.jar:1.4]
> at
> org.apache.commons.dbcp.DelegatingResultSet.getDate(DelegatingResultS
> et.java:574) ~[commons-dbcp-1.4.jar:1.4]
> at
> org.apache.drill.exec.store.jdbc.JdbcRecordReader$DateCopier.copy(Jdb
> cRecordReader.java:406)
> ~[drill-jdbc-storage-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT]
> at
> org.apache.drill.exec.store.jdbc.JdbcRecordReader.next(JdbcRecordRead
> er.java:242) ~[drill-jdbc-storage-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
