[teiid-issues] [JBoss JIRA] Commented: (TEIID-472) Teiid Embedded unable to login to JDBC data sources requiring username/password

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-472:
------------------------------------

When Embedded finds a connector type that is not defined in it's own configuration.xml, it is wrong fully removing all the property definitions set by the VDB loader from the connector type that is loaded from file"configurationInfo.def". The correct behaviour should be, look in its configuration if not found, look for its parent and combine its parent and seld defined properties to make the correct set of the property definitions.

> Teiid Embedded unable to login to JDBC data sources requiring username/password
> -------------------------------------------------------------------------------
>
>                 Key: TEIID-472
>                 URL: https://jira.jboss.org/jira/browse/TEIID-472
>             Project: Teiid
>          Issue Type: Bug
>          Components: Embedded
>    Affects Versions: 6.0.0
>         Environment: fedora 10, Teiid Designer 040709, Teiid 6.0.0
>            Reporter: Paul Nittel
>            Assignee: Ramesh Reddy
>             Fix For: 6.1.0
>
>
> I took the PartsSupplier_VDB from the Designer and tried to use it in Teiid Embedded. Using a simple JDBC query tool, I was unable to login to the data sources (Oracle and SQL Server). Working with Ramesh, we found we could edit the configuration.def inside the VDB and edit the mm-encrypted password to plain text and it would work. As an alternative, we could use the configuration.xml file from the Designer and that worked.
> Ramesh will fill in the technical details...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira