[teiid-issues] [JBoss JIRA] Resolved: (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:all-tabpanel ]

Ramesh Reddy resolved TEIID-472.
--------------------------------

    Resolution: Done


When the Embedded loaded the Connector Types it only loaded the Property Definitions that are defined on its XMl fragment, it never loaded the connector's "super" types property definitions. Now that "password" property is not on individual connector type, it is specified on the "JDBC Connector", which is super type this information was not loaded, thus never being decrypted property.

> 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