[teiid-issues] [JBoss JIRA] (TEIID-3412) Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8

[Kylin Soong (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13057652#comment-13057652 ] 

Kylin Soong commented on TEIID-3412:
------------------------------------

> looks like an active project with active commit log
Yes, I have repost a issue, they give me quick response as [1], but UcanAccess only for MS Access, if we consider "ODBC" source in general, it not a option.
[1] http://sourceforge.net/p/ucanaccess/discussion/general/thread/58e4e3c9/

> Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8
> ------------------------------------------------------------------------------
>
>                 Key: TEIID-3412
>                 URL: https://issues.jboss.org/browse/TEIID-3412
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>    Affects Versions: 9.x
>            Reporter: Van Halbert
>            Assignee: Kylin Soong
>
> In JDK 1.8, the ODBC-JDBC bridge is removed, so accessing MS Access using this method will not be available.   An alternative, open source, driver that can be used is:  http://jackcess.sourceforge.net
> In nexus:
> <dependency>
>   <groupId>com.healthmarketscience.jackcess</groupId>
>   <artifactId>jackcess</artifactId>
>   <version>2.0.9</version>
> </dependency>
> This may require a new translator, but won't be know until a deeper look is done.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)