Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1335087

Summary: Metadata don't change when swapping H2 for MySQL
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Stelios Kousouris <stkousso>
Component: Teiid DesignerAssignee: Barry LaFond <blafond>
Status: CLOSED UPSTREAM QA Contact: Matus Makovy <mmakovy>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: drieden, jolee, mbaluch, stkousso, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-05-11 14:18:17 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Stelios Kousouris 2016-05-11 10:35:37 UTC
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/docs/labs 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.

Comment 2 Matus Makovy 2016-05-11 10:53:20 UTC
Could you please provide a version of Teiid Designer that you are using ?

Comment 3 Stelios Kousouris 2016-05-11 11:22:54 UTC
From what I see in my Eclipse Installation Details the version of the Teiid Designer is as follows

  Teiid Designer	9.0.1.Final-v20150211-1407-B643	org.teiid.designer.feature.feature.group	JBoss by Red Hat, Inc.

Comment 4 Matus Makovy 2016-05-11 14:18:17 UTC
Ok, thank you for the info. I'll close this, since we are tracking Teiid Designer issues in JIRA. I've created a JIRA and attached it here. You can watch the progress there.