[JBoss JIRA] (TEIIDDES-2838) Setting connection profile to imported model won't set data source (issues with Preview)
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2838?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2838:
----------------------------------------
[~blafond]
Ok, than 2) looks like a best solution.
> Setting connection profile to imported model won't set data source (issues with Preview)
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2838
> URL: https://issues.jboss.org/browse/TEIIDDES-2838
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Priority: Blocker
> Attachments: Screen Shot 2016-05-09 at 16.35.06.png, Screen Shot 2016-05-09 at 16.54.45.png
>
>
> I imported an existing project into TD with 2 source models and 1 view model.
> After I set a connection profile to source model (via Modeling -> Set connection profile) it appears that Data Source is not set. As a result of this when I hit preview (Modeling -> Preview data) on some table in this model, it fails. Because the jndi-name in the dynamic vdb is set to null.
> See screenshots
> I am setting the priority to critical, because this used to work before.
--
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:
----------------------------------------
We do not have any info from original reporter about exact data types or stack trace. The models that are attached are just from me when I was trying to reproduce the issue. [~skoussou] Could you provide such info ?
[~blafond]
Thanks Barry.
Basically, I had to rework the whole H2-afterChange model by hand to make it look like MySQL model. There were some more native type differences and also everywhere where H2 uses double quotes (") MySQL uses single quote (`). So I had to change all the Name in Source properties for the columns and also for the table.
Is the resolution that this is basically not supported ?
> 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-2838) Setting connection profile to imported model won't set data source (issues with Preview)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2838?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2838:
----------------------------------------
[~mmakovy] The preview data manager looks in the model for JNDI name, so as long as the Set CP (and all the importers) allow users to set that value, then the preview will us it to create the data source.
> Setting connection profile to imported model won't set data source (issues with Preview)
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2838
> URL: https://issues.jboss.org/browse/TEIIDDES-2838
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Priority: Blocker
> Attachments: Screen Shot 2016-05-09 at 16.35.06.png, Screen Shot 2016-05-09 at 16.54.45.png
>
>
> I imported an existing project into TD with 2 source models and 1 view model.
> After I set a connection profile to source model (via Modeling -> Set connection profile) it appears that Data Source is not set. As a result of this when I hit preview (Modeling -> Preview data) on some table in this model, it fails. Because the jndi-name in the dynamic vdb is set to null.
> See screenshots
> I am setting the priority to critical, because this used to work before.
--
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] Be aware that at model imported from one JDBC source may not have the same supported Data Types, especially native types. In this case H2's *integer* is native type *integer,* while MySQL uses *int*. Since Teiid uses the *native type* if available, by changing the connection profile to a different JBDC type, it looks like the query fails because the metadata doesn't line up.
You could try hand-editing the *integer* datatype values in your H2-afterChange.xmi model and then try the preview again.
> 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-2838) Setting connection profile to imported model won't set data source (issues with Preview)
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2838?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2838:
----------------------------------------
[~blafond]
>From my point of view 2 is better for the user. When you consider that it worked before changing the way how preview is done. It is part of our automated test for preview so I am sure it worked before.
Will 2 also cover deploying the DS ?
> Setting connection profile to imported model won't set data source (issues with Preview)
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2838
> URL: https://issues.jboss.org/browse/TEIIDDES-2838
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Priority: Blocker
> Attachments: Screen Shot 2016-05-09 at 16.35.06.png, Screen Shot 2016-05-09 at 16.54.45.png
>
>
> I imported an existing project into TD with 2 source models and 1 view model.
> After I set a connection profile to source model (via Modeling -> Set connection profile) it appears that Data Source is not set. As a result of this when I hit preview (Modeling -> Preview data) on some table in this model, it fails. Because the jndi-name in the dynamic vdb is set to null.
> See screenshots
> I am setting the priority to critical, because this used to work before.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2838) Setting connection profile to imported model won't set data source (issues with Preview)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2838?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2838:
----------------------------------------
[~mmakovy] The Import wizards have been modified to include a "Set JNDI Name" panel. As a result, the DS can be auto-created/depoyed on FINISH. In your case, you are using an action that doesn't set the JNDI name too, so it's null when imported to project.
1) Workaround is to Set JNDI name via the action
2) I could ADD that Set JNDI Name panel to the Set Connection PRofile dialog so the user knows if the name is currently blank?
> Setting connection profile to imported model won't set data source (issues with Preview)
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2838
> URL: https://issues.jboss.org/browse/TEIIDDES-2838
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Priority: Blocker
> Attachments: Screen Shot 2016-05-09 at 16.35.06.png, Screen Shot 2016-05-09 at 16.54.45.png
>
>
> I imported an existing project into TD with 2 source models and 1 view model.
> After I set a connection profile to source model (via Modeling -> Set connection profile) it appears that Data Source is not set. As a result of this when I hit preview (Modeling -> Preview data) on some table in this model, it fails. Because the jndi-name in the dynamic vdb is set to null.
> See screenshots
> I am setting the priority to critical, because this used to work before.
--
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 didn't help for some reason. I cleared preview artifacts and hit preview again. No success.
Btw, the stack trace is here:
{code:java}
15:58:10,160 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=JogTpAecP3+y.0.0.0: org.teiid.translator.jdbc.JDBCExecutionException: 1064 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."BIGDECIMALVALUE", g_0."BYTENUM", g_0."TIMESTAMPVALUE", g_0."OBJECTVALUE", g_0."DATEVALUE", g_0."SHORTVALUE", g_0."LONGNUM", g_0."STRINGKEY", g_0."FLOATNUM", g_0."BOOLEANVALUE", g_0."BIGINTEGERVALUE", g_0."INTKEY", g_0."DOUBLENUM", g_0."STRINGNUM", g_0."INTNUM", g_0."TIMEVALUE", g_0."CHARVALUE" FROM "NEW"."BQT2"."SMALLA" AS g_0]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:330) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_71]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"BIGDECIMALVALUE", g_0."BYTENUM", g_0."TIMESTAMPVALUE", g_0."OBJECTVALUE", g_0."' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_71]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [rt.jar:1.8.0_71]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.8.0_71]
at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [rt.jar:1.8.0_71]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2212)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
... 12 more
{code}
> 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-2838) Setting connection profile to imported model won't set data source (issues with Preview)
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2838?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2838:
-----------------------------------
Priority: Blocker (was: Critical)
> Setting connection profile to imported model won't set data source (issues with Preview)
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2838
> URL: https://issues.jboss.org/browse/TEIIDDES-2838
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Priority: Blocker
> Attachments: Screen Shot 2016-05-09 at 16.35.06.png, Screen Shot 2016-05-09 at 16.54.45.png
>
>
> I imported an existing project into TD with 2 source models and 1 view model.
> After I set a connection profile to source model (via Modeling -> Set connection profile) it appears that Data Source is not set. As a result of this when I hit preview (Modeling -> Preview data) on some table in this model, it fails. Because the jndi-name in the dynamic vdb is set to null.
> See screenshots
> I am setting the priority to critical, because this used to work before.
--
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] The connection info in the 2 XMI files seems fine. I think what might be happening is the JNDI name is the same between the 2 H2 versions for the preview vdbs. The preview data sources are registered (same JNDI) and the standalone.xml probably isn't getting updated correctly? You could try H2 preview, then "Clear Preview Artifacts" on the server, then try H2-afterChange preview.
> 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 updated TEIIDDES-2840:
-----------------------------------
Attachment: MySQL.xmi
H2.xmi
H2-afterChange.xmi
> 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