[teiid-issues] [JBoss JIRA] (TEIID-4356) Add asort of connection test for "connection definitions" of resource adapters

[ https://issues.jboss.org/browse/TEIID-4356?page=com.atlassian.jira.plugin... ] Marco Ardito edited comment on TEIID-4356 at 7/30/16 12:02 PM: --------------------------------------------------------------- Sorry, I didn't meant that this is something broken in Teiid, I just submitted an idea to make things simpler, or more evident, when possible. I know that a standard jdbc rdbms connection is much simpler to test (it's more or less always the same method), but that is the point, imho: I can test that kind of connection easily in many other ways (even connecting directly with squirrel, using the same jdbc driver for the rdbms). Other connection types (files/network protocols, specific connectors), which have no "test" button in Wildfly/Teiid, how can they be tested? Of course they could be very different from each other... In the linked thread, I tried to use php or soapui, but that didn't help either. Both connected, while Teiid didn't. As Steven said above, at least some better error reporting when connection fails could help. In my case the remote server response was missing a rfc required field: Teiid was doing the right thing as for the rfc, but... that was invisible to me, I only got "server error"on the client, and many strange (to me)bcfx errors in the server.log. Probably Ramesh examined the code and spotted there what was happening? I would have tried to add CXF logging but Ramesh was faster to find the cause of the issue, and made a patch. Maybe (eg) in that case Teiid could log a line like "access token received, but the remote server response is missing the required field token_type, so we can't use that -. see rfc xxx). That would also help a lot. Or, at least suggest in the docs how to get more details if connection doesn't seem to work... that kind of thing. was (Author: m.ardito): Sorry, I didn't meant that this is something broken in Teiid, I just submitted an idea to make things simpler, or more evident, when possible. I know that a standard jdbc rdbms connection is much simpler to test (it's more or less always the same method), but that is the point, imho: I can test that kind of connection easily in many other ways (even connecting directly with squirrel, using the same jdbc driver for the rdbms). Other connection types (files/network protocols, specific connectors), which have no "test" button in Wildfly/Teiid, how can hey be tested? Of course they could be very different from each other... In the linked thread, I tried to use php or soapui, but that didn't help either. Both connected, while Teiid didn't. As Steven said above, at least some better error reporting when connection fails could help. In my case the remote server response was missing a rfc required field: Teiid was doing the right thing as for the rfc, but... that was invisible to me, I only got "server error"on the client, and many strange (to me)bcfx errors in the server.log. Probably Ramesh examined the code and spotted there what was happening? I would have tried to add CXF logging but Ramesh was faster to find the cause of the issue, and made a patch. Maybe (eg) in that case Teiid could log a line like "access token received, but the remote server response is missing the required field token_type, so we can't use that -. see rfc xxx). That would also help a lot. Or, at least suggest in the docs how to get more details if connection doesn't seem to work... that kind of thing. -- This message was sent by Atlassian JIRA (v6.4.11#64026)