[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-683) JDBC Importer cannot connect with DB unless the ConnectionProfile has username and password.

JDBC Importer cannot connect with DB unless the ConnectionProfile has username and password. -------------------------------------------------------------------------------------------- Key: TEIIDDES-683 URL: https://jira.jboss.org/browse/TEIIDDES-683 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.1 Reporter: John Doyle Assignee: John Doyle Fix For: 7.1.1 The UI in the JDBC importer allows a user to provide a password at import time, rather than keep it in the ConnectionProfile, for security purposes. In theory DTP supports this use and has a connect() method that allows a user to pass the username and password. In practice there is a defect in the ConnectionProfiles provided in the DTP enablement project. The username and password are not used. This means that when a Teiid Designer user selects a ConnectionProfile w/o a password in the JDBC importer and supplies the password in our UI, the connection will fail. Here's the eclipse bug. https://bugs.eclipse.org/bugs/show_bug.cgi?id=328738 Targeted to be fixed in DTP 1.9. For our purposes the JDBC importer should validate that the profile has a password before attempting to connect, and inform the user that Teiid Designer can only use profiles with full credentials.