[
https://issues.jboss.org/browse/TEIID-3412?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-3412:
-------------------------------------
Can you check if there are any other options? I think we need to think in general as to
how we can support any "ODBC" source not just MS Access.
As far UcanAccess, looks like an active project with active commit log, so that is good
news. If any issues, you can check if you can work with the commiter of the to get the
fixes done. If we go with UcanAcess, create extended translator in the
"translator-jdbc" based "jdbc-simple" or "jdbc-ani", and
further refine capabilities to match the UcanAccess support.
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)