9 a.m.
[
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)
3163
days inactive
3163
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
participants (1)
-
Matus Makovy (JIRA)