[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Tom Arnold commented on TEIID-3206:
-----------------------------------
Here's a quick script to make a module for IronJacamar 1.0.26.Final. This is the earliest version that fixes the issue according to my tests.
https://gist.github.com/Tom9729/fe28e904f9ce4048382e
Here's a patch to the install script. The URL and SHA1 parts need to be filled in.
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)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Tom Arnold edited comment on TEIID-3206 at 11/7/14 9:52 PM:
------------------------------------------------------------
Good find. Since the GA is not available without the $0 dev sub, could this be patched like resteasy used to be?
was (Author: tom9729):
Good find. So is the community just out of luck then?
> 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)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Tom Arnold commented on TEIID-3206:
-----------------------------------
Good find. So is the community just out of luck then?
> 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)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3206:
------------------------------------
According to EAP, https://issues.jboss.org/browse/JBJCA-1151 is the fix for this issue. It will be available in EAP GA.
> 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)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
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)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Tom Arnold updated TEIID-3206:
------------------------------
Summary: EAP 6.3 - JDBC Datasources Test Connection (was: EAP 6.3 - JDBC Datasources Broken Test Connection)
> 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 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.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Broken Test Connection
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Tom Arnold updated TEIID-3206:
------------------------------
Summary: EAP 6.3 - JDBC Datasources Broken Test Connection (was: JDBC Datasources Broken)
Description:
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.
was:
JDBC Datasources seem to be broken in the standalone server built from 8.9.x and master. I believe this is a regression introduced by changing the platform to 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.
See: TEIID-3185 and related.
> EAP 6.3 - JDBC Datasources Broken 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 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.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) JDBC Datasources Broken
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Tom Arnold commented on TEIID-3206:
-----------------------------------
Found similar issue posted in the forums (https://developer.jboss.org/thread/242186) with no resolution, but it looks like the data source still works even though Test Connection is broken. I will update the issue accordingly. Still, it would be good to get this fixed...
> JDBC Datasources Broken
> -----------------------
>
> 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
>
> JDBC Datasources seem to be broken in the standalone server built from 8.9.x and master. I believe this is a regression introduced by changing the platform to 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.
> See: TEIID-3185 and related.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) JDBC Datasources Broken
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3206:
------------------------------------
I downloaded the EAP 6.3 ALPHA kit. And without installing Teiid, I tried the same test, and it fails. So it appears the problem is with EAP, not with Teiid.
> JDBC Datasources Broken
> -----------------------
>
> 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
>
> JDBC Datasources seem to be broken in the standalone server built from 8.9.x and master. I believe this is a regression introduced by changing the platform to 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.
> See: TEIID-3185 and related.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIID-3206) JDBC Datasources Broken
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Tom Arnold updated TEIID-3206:
------------------------------
Description:
JDBC Datasources seem to be broken in the standalone server built from 8.9.x and master. I believe this is a regression introduced by changing the platform to 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.
See: TEIID-3185 and related.
was:
JDBC Datasources seem to be broken in the standalone server built from 8.9.x and master. I believe this is a regression introduced by changing the platform to 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.
> JDBC Datasources Broken
> -----------------------
>
> 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
>
> JDBC Datasources seem to be broken in the standalone server built from 8.9.x and master. I believe this is a regression introduced by changing the platform to 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.
> See: TEIID-3185 and related.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months