[teiid-issues] [JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection

[Tom Arnold (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tom Arnold updated TEIID-3206:
------------------------------
    Description: 
Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1.

This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources.

The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible.

  was:
Using `Test Connection` for JDBC Datasources seem to be broken in the standalone server built from 8.9.x and master. This seems to be an issue with EAP 6.3 Alpha1.

This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid.

This also happens with Oracle and PostgreSQL datasources.



> EAP 6.3 - JDBC Datasources Test Connection
> ------------------------------------------
>
>                 Key: TEIID-3206
>                 URL: https://issues.jboss.org/browse/TEIID-3206
>             Project: Teiid
>          Issue Type: Bug
>          Components: Build/Kits
>    Affects Versions: 8.9, 8.10
>            Reporter: Tom Arnold
>            Assignee: Steven Hawkins
>
> Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1.
> This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources.
> The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible.



--
This message was sent by Atlassian JIRA
(v6.3.8#6338)