[JBoss JIRA] (TEIID-3411) LDAP translator and multi-valued arrays
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-3411?page=com.atlassian.jira.plugin... ]
Johnathon Lee updated TEIID-3411:
---------------------------------
Comment: was deleted
(was: A comment with security level 'Red Hat Employee' was removed.)
> LDAP translator and multi-valued arrays
> ---------------------------------------
>
> Key: TEIID-3411
> URL: https://issues.jboss.org/browse/TEIID-3411
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> The problem is with how multi-valued attribute from the LDAP response is handled. They don't want to have the data mapped to an array or multivalued-concat and then transformed into another table to get the unique values. There is an issue with the translator as it should handle multivalued attribute, by simply creating multiple rows for each value of the multivalued attribute.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 8 months
[JBoss JIRA] (TEIID-3416) Missing dependency "ibm.jdk" in module org.jboss.security.negotiation
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-3416:
-----------------------------------
Summary: Missing dependency "ibm.jdk" in module org.jboss.security.negotiation
Key: TEIID-3416
URL: https://issues.jboss.org/browse/TEIID-3416
Project: Teiid
Issue Type: Feature Request
Affects Versions: 8.7.1
Reporter: Juraj Duráni
Assignee: Steven Hawkins
The module org.jboss.security.negotiation is missing "ibm.jdk" dependency. This module is needed if the JDV is running on IBM jdk - contains com.ibm.security.auth.module.Krb5LoginModule class.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 8 months
[JBoss JIRA] (TEIID-3411) LDAP translator and multi-valued arrays
by Jason Marley (JIRA)
[ https://issues.jboss.org/browse/TEIID-3411?page=com.atlassian.jira.plugin... ]
Jason Marley commented on TEIID-3411:
-------------------------------------
I will provide a use case soon, I'm working on getting you the details.
> LDAP translator and multi-valued arrays
> ---------------------------------------
>
> Key: TEIID-3411
> URL: https://issues.jboss.org/browse/TEIID-3411
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> The problem is with how multi-valued attribute from the LDAP response is handled. They don't want to have the data mapped to an array or multivalued-concat and then transformed into another table to get the unique values. There is an issue with the translator as it should handle multivalued attribute, by simply creating multiple rows for each value of the multivalued attribute.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 8 months
[JBoss JIRA] (TEIID-3412) Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3412?page=com.atlassian.jira.plugin... ]
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)
9 years, 8 months
[JBoss JIRA] (TEIID-3412) Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3412?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-3412:
------------------------------------
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)
9 years, 8 months