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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3412:
---------------------------------------

Yes this would only be for ms access.  That's the only general odbc source that we have left.

As for general odbc source support that will have to be filled by third parties for now.

Can you put together a pull request with their latest driver?

> 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)