[JBoss JIRA] (TEIIDDES-2840) Metadata don't change when swapping H2 for MySQL
by Matus Makovy (JIRA)
[ 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)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2840) Metadata don't change when swapping H2 for MySQL
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2840?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2840:
----------------------------------------
[~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
>
> 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)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2841) Deprecate XML, XSD and XML Document metamodels
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2841:
--------------------------------------
Summary: Deprecate XML, XSD and XML Document metamodels
Key: TEIIDDES-2841
URL: https://issues.jboss.org/browse/TEIIDDES-2841
Project: Teiid Designer
Issue Type: Task
Components: Modeling, Web Services Support
Affects Versions: 10.0
Reporter: Barry LaFond
Assignee: Barry LaFond
Priority: Critical
Fix For: 10.0.1
Support for creating Web Services, XML Document and Schema (XSD) models should be deprecated. The direction of Teiid runtime metadata has changed and these features should be phased out.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2840) Metadata don't change when swapping H2 for MySQL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2840?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2840:
----------------------------------------
[~mmakovy] can you capture and attach the connection info in the sourcemodel.xmi before and after re-setting the CP? There will be a <annotations>.....</annotations> element containing *connection:xxxxxx, *translator:xxxxx*, and *connectionProfile.xxxx* properties
> 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
>
> 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)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2483) Add a Import Teiid DDL feature
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2483?page=com.atlassian.jira.plu... ]
Barry LaFond closed TEIIDDES-2483.
----------------------------------
Fix Version/s: 10.0
Assignee: Barry LaFond
Resolution: Out of Date
This has been implemented for 10.0.0 as a new DDL import option
> Add a Import Teiid DDL feature
> ------------------------------
>
> Key: TEIIDDES-2483
> URL: https://issues.jboss.org/browse/TEIIDDES-2483
> Project: Teiid Designer
> Issue Type: Feature Request
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 10.0
>
>
> Designer's DDL importer requires the user to set a few properties in order to define the import as Teiid-specific.
> Create an action/wizard page that knows it's Teiid DDL and shortcuts whatever it can to add the views to a virtual model.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2840) Metadata don't change when swapping H2 for MySQL
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2840?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2840:
---------------------------------------------------
Matus Makovy <mmakovy(a)redhat.com> changed the Status of [bug 1335087|https://bugzilla.redhat.com/show_bug.cgi?id=1335087] from NEW to CLOSED
> 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
>
> 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)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2840) Metadata don't change when swapping H2 for MySQL
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2840?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration updated TEIIDDES-2840:
----------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1335087
Bugzilla Update: Perform
> 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
>
> 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)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2840) Metadata don't change when swapping H2 for MySQL
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2840:
--------------------------------------
Summary: 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
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)
8 years, 8 months