[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:comment-tabpanel&focusedCommentId=13019110#comment-13019110 ] 

Tom Arnold commented on TEIID-3206:
-----------------------------------

The work to get it in the install script is 90% done.

This script needs to be run once to create a replacement module for IronJacamar. The version can be changed, but I settled on 1.0.26.Final as it seemed to be the earliest that fixed the issue (counter to the version indicated by JBJCA-1151). It uses the existing module XML with the versions updated, and gets the new JARs from JBoss repos. I took this approach because I couldn't find any IronJacamar releases published as JBoss modules. I assume the resulting ZIP can be hosted on Teiid SourceForge or somewhere similar.
https://gist.github.com/Tom9729/fe28e904f9ce4048382e

This is a patch file for the install script that updated the IronJacamar module. The SHA1 and URL parts need to be filled in once the module has been made and it has been uploaded somewhere.
https://gist.github.com/Tom9729/a158354a3468dda731d6

> 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)