[
https://issues.jboss.org/browse/TEIIDDES-2840?page=com.atlassian.jira.plu...
]
Matus Makovy edited comment on TEIIDDES-2840 at 5/12/16 6:35 AM:
-----------------------------------------------------------------
[~blafond]
I attached 3 models:
* H2.xmi - model created via JDBC import from H2
* MySQL.xmi - model created via JDBC import from MySQL
* H2-afterChange - model created via JDBC import from H2, then connection info was deleted
and I added connection profile for MySQL DB to this model
Also, after the change of CP on H2 model, this appeared in server log:
{code}
12:26:04,303 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-6) JBAS010400: Bound data source
[java:/PREVIEW_f955d627-839d-452a-9e01-5c819c17f2d2_reproducing_bug_MySQL]
12:27:25,842 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-2) JBAS010409: Unbound data source
[java:/PREVIEW_f955d627-839d-452a-9e01-5c819c17f2d2_reproducing_bug_H2]
12:27:56,024 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-14) JBAS010400: Bound data source
[java:/PREVIEW_f955d627-839d-452a-9e01-5c819c17f2d2_reproducing_bug_H2]
}
{code}
TD 9.0.1 and DV 6.2.4
was (Author: mmakovy):
[~blafond]
I attached 3 models:
* H2.xmi - model created via JDBC import from H2
* MySQL.xmi - model created via JDBC import from MySQL
* H2-afterChange - model created via JDBC import from H@, then connection info was deleted
and I added connection profile for MySQL DB to this model
Also, after the change of CP on H2 model, this appeared in server log:
{code}
12:26:04,303 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-6) JBAS010400: Bound data source
[java:/PREVIEW_f955d627-839d-452a-9e01-5c819c17f2d2_reproducing_bug_MySQL]
12:27:25,842 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-2) JBAS010409: Unbound data source
[java:/PREVIEW_f955d627-839d-452a-9e01-5c819c17f2d2_reproducing_bug_H2]
12:27:56,024 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-14) JBAS010400: Bound data source
[java:/PREVIEW_f955d627-839d-452a-9e01-5c819c17f2d2_reproducing_bug_H2]
}
{code}
TD 9.0.1 and DV 6.2.4
Metadata don't change when swapping H2 for MySQL
------------------------------------------------
Key: TEIIDDES-2840
URL:
https://issues.jboss.org/browse/TEIIDDES-2840
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.1, 9.0.6
Reporter: Matus Makovy
Attachments: H2-afterChange.xmi, H2.xmi, MySQL.xmi
Issue is copied from bugzilla, it was originally reported by [~skoussou]:
Description of problem:
Version-Release number of selected component (if applicable):
How reproducible:
Steps to Reproduce:
1. Create a Source Model based on H2 (see the
https://github.com/DataVirtualizationByExample/DVWorkshop/tree/master/doc... for an
example) in the Teiid Designer
2. In the Model Explorer view select the sourcemodel.xmi Right click --> Modelling
--> Remove Connection Info
3. Again using the same Right click --> sourcemodel.xmi --> Modelling --> Set
Connection Profile and either select the MySQL exisitng profile or create a new one
Actual results:
An exception occurs when previewing the data with a complaint that there is a MySQL query
error (don't have the error avaialble)
Expected results:
Additional info:
Once I delete the model and recreate it with the MySQL connection profile from the
beginning the preview works fine.
[~mmakovy]: I tried to reproduce this and I got the same error, also with TD 9.0.6.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)