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

Kylin Soong edited comment on TEIID-3412 at 4/8/15 1:39 AM:
------------------------------------------------------------

I think we should do more estimation of the UCanAccess, does it really production ready? it more looks like a personal project, there only 12 discussions in sourceforge, I test with QA mdb, some table data can not be queried, but ODBC-JDBC bridge driver works fine. Below is one of errors which I met:
~~~
WARNING:Error in the metadata of the table EmpData: table's row count in the metadata is 52 but 51 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.
~~~
this seems Row Count not synchronous between metadata and access file.

UCanAccess not support MS Access 2013. I have found some issue related with MS Access 2013, so I think Teiid support MS 2013.

If we decide to use UCanAccess, no so much work left, also not require a new translator, the work need to do is configure UCanAccess datasource in jboss server(it should be easy), the current access translator may works fine(probably a little adjustment). So do we will use UCanAccess?




was (Author: kylin):
I think we should do more estimation of the UCanAccess, does it really production ready? it more looks like a personal project, there only 12 discussions in sourceforge, I test with QA mdb, some table data can not be queried, but ODBC-JDBC bridge driver works fine. Below is one of errors which I met:
~~~
WARNING:Error in the metadata of the table EmpData: table's row count in the metadata is 52 but 51 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.
~~~
this seems Row Count not synchronous between metadata and access file.

UCanAccess not support MS Access 2013. I have found some issue related with MS Access 2013, so I think Teiid support MS 2013.

If we decide to use UCanAccess, no so much work left, not require a new translator, the work need to do is configure UCanAccess datasource in jboss server(it should be easy), the current access translator may works fine with UCanAccess driver(probably a little adjustment). So do we will use UCanAccess?



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