[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=13060734#comment-13060734 ] 

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

Committed the pull request and removed the blob handling.  If there is a need to copy blob values, there is an existing setting property called copyLobs (which can be defaulted to true if needed.  Can you describe under what circumstances or why the blob values need to be copied, their potential size, etc.?

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