[jira] [Commented] (HIVE-24452) Add a generic JDBC implementation that can be used to other JDBC DBs

["David Mollitor (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-24452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17240994#comment-17240994 ] 

David Mollitor commented on HIVE-24452:
---------------------------------------

Please consider using an abstraction layer that deals with the different vendors for you.

http://www.jooq.org/
https://blog.mybatis.org/
https://www.eclipse.org/eclipselink/
https://hibernate.org/

> Add a generic JDBC implementation that can be used to other JDBC DBs
> --------------------------------------------------------------------
>
>                 Key: HIVE-24452
>                 URL: https://issues.apache.org/jira/browse/HIVE-24452
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Naveen Gangam
>            Priority: Major
>
> Currently, we added a custom provider for each of the JDBC DBs supported by hive (MySQL, Postgres, MSSQL(pending), Oracle(pending) and Derby (pending)).  But if there are other JDBC providers we want to add support for, adding a generic JDBC provider would be useful that hive can default to.
> This means
> 1) We have to support means to indicate that a connector is for a JDBC datasource. So maybe add a property in DCPROPERTIES on connector to indicate that the datasource supports JDBC.
> 2) If there is no custom connector for a data source, use the GenericJDBCDatasource connector that is to be added as part of this jira.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)