[JBoss JIRA] (TEIID-5150) JDG source model with 'v' letter at beginning of a name doesn't work.
by Adrian Nistor (JIRA)
[ https://issues.jboss.org/browse/TEIID-5150?page=com.atlassian.jira.plugin... ]
Adrian Nistor commented on TEIID-5150:
--------------------------------------
[~rareddy][~van.halbert] This bug should be solved after https://issues.jboss.org/browse/ISPN-7863 is released with Infinispan 9.4.0.Final
> JDG source model with 'v' letter at beginning of a name doesn't work.
> ---------------------------------------------------------------------
>
> Key: TEIID-5150
> …
[View More] URL: https://issues.jboss.org/browse/TEIID-5150
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector
> Affects Versions: 8.12.11.6_4
> Environment: Fedora 26
> Mac OS 10.12
> Reporter: Matej Kralik
> Assignee: Ramesh Reddy
> Attachments: BookMat-vdb.xml
>
>
> When the name of a JDG source model starts with 'v' letter, after run query at the materialized table (BooksMatView.viewBooks in attached VDB), the server shows exception:
> {code:java}
> 14:29:19,383 WARN [org.infinispan.client.hotrod.impl.protocol.Codec21] (Worker3_QueryProcessorQueue176) ISPN004005: Error received from the server: java.lang.IllegalArgumentException: Message descriptor not found : endorBookJDGSource.viewBooks
> 14:29:19,384 ERROR [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue176) Connector worker process failed for atomic-request=X6jNnAMTIgyp.0.6.248: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for messageId=551 returned server error (status=0x85): java.lang.IllegalArgumentException: Message descriptor not found : endorBookJDGSource.viewBooks
> at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:363) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:152) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:138) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:60) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:68) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:30) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:57) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:68) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:53) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.teiid.translator.infinispan.hotrod.InfinispanResponse.fetchNextBatch(InfinispanResponse.java:76) [translator-infinispan-hotrod-8.12.11.6_4-redhat-7.jar:8.12.11.6_4-redhat-7]
> at org.teiid.translator.infinispan.hotrod.InfinispanResponse.getNextRow(InfinispanResponse.java:92) [translator-infinispan-hotrod-8.12.11.6_4-redhat-7.jar:8.12.11.6_4-redhat-7]
> at org.teiid.translator.infinispan.hotrod.InfinispanQueryExecution.next(InfinispanQueryExecution.java:142) [translator-infinispan-hotrod-8.12.11.6_4-redhat-7.jar:8.12.11.6_4-redhat-7]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:433) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source) [:1.8.0_65]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_65]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_65]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at com.sun.proxy.$Proxy42.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
> 14:29:19,389 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue177) TEIID30020 Processing exception for request X6jNnAMTIgyp.0 'TEIID30504 vendorBookJDGSource: java.lang.IllegalArgumentException: Message descriptor not found : endorBookJDGSource.viewBooks'. Originally TeiidProcessingException Codec20.java:363. Enable more detailed logging to see the entire stacktrace.
> {code}
> JDG source model has name *vendorBookJDGSource*.
> However, the name of JDG source model in the exception doesn't contain first 'v' letter ( Message descriptor not found : *endorBookJDGSource*.viewBooks ).
> Jdg server doesn't show any exception. I use DV 6.4.0 ER3, JDG 7.1 server and JDG 7.1.1 CR2 EAP module.
> In the attachments, I upload my VDB. Remove 'v' letter fix the issue.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months
[JBoss JIRA] (TEIID-5150) JDG source model with 'v' letter at beginning of a name doesn't work.
by Adrian Nistor (JIRA)
[ https://issues.jboss.org/browse/TEIID-5150?page=com.atlassian.jira.plugin... ]
Adrian Nistor edited comment on TEIID-5150 at 9/26/18 9:59 AM:
---------------------------------------------------------------
[~rareddy], [~van.halbert] This bug should be solved after https://issues.jboss.org/browse/ISPN-7863 is released with Infinispan 9.4.0.Final
was (Author: anistor):
[~rareddy][~van.halbert] This bug should be solved after https://issues.jboss.org/browse/ISPN-7863 is released with …
[View More]Infinispan 9.4.0.Final
> JDG source model with 'v' letter at beginning of a name doesn't work.
> ---------------------------------------------------------------------
>
> Key: TEIID-5150
> URL: https://issues.jboss.org/browse/TEIID-5150
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector
> Affects Versions: 8.12.11.6_4
> Environment: Fedora 26
> Mac OS 10.12
> Reporter: Matej Kralik
> Assignee: Ramesh Reddy
> Attachments: BookMat-vdb.xml
>
>
> When the name of a JDG source model starts with 'v' letter, after run query at the materialized table (BooksMatView.viewBooks in attached VDB), the server shows exception:
> {code:java}
> 14:29:19,383 WARN [org.infinispan.client.hotrod.impl.protocol.Codec21] (Worker3_QueryProcessorQueue176) ISPN004005: Error received from the server: java.lang.IllegalArgumentException: Message descriptor not found : endorBookJDGSource.viewBooks
> 14:29:19,384 ERROR [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue176) Connector worker process failed for atomic-request=X6jNnAMTIgyp.0.6.248: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for messageId=551 returned server error (status=0x85): java.lang.IllegalArgumentException: Message descriptor not found : endorBookJDGSource.viewBooks
> at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:363) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:152) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:138) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:60) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:68) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:30) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:57) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:68) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:53) [infinispan-client-hotrod.jar:8.4.1.Final-redhat-2]
> at org.teiid.translator.infinispan.hotrod.InfinispanResponse.fetchNextBatch(InfinispanResponse.java:76) [translator-infinispan-hotrod-8.12.11.6_4-redhat-7.jar:8.12.11.6_4-redhat-7]
> at org.teiid.translator.infinispan.hotrod.InfinispanResponse.getNextRow(InfinispanResponse.java:92) [translator-infinispan-hotrod-8.12.11.6_4-redhat-7.jar:8.12.11.6_4-redhat-7]
> at org.teiid.translator.infinispan.hotrod.InfinispanQueryExecution.next(InfinispanQueryExecution.java:142) [translator-infinispan-hotrod-8.12.11.6_4-redhat-7.jar:8.12.11.6_4-redhat-7]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:433) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source) [:1.8.0_65]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_65]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_65]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at com.sun.proxy.$Proxy42.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
> 14:29:19,389 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue177) TEIID30020 Processing exception for request X6jNnAMTIgyp.0 'TEIID30504 vendorBookJDGSource: java.lang.IllegalArgumentException: Message descriptor not found : endorBookJDGSource.viewBooks'. Originally TeiidProcessingException Codec20.java:363. Enable more detailed logging to see the entire stacktrace.
> {code}
> JDG source model has name *vendorBookJDGSource*.
> However, the name of JDG source model in the exception doesn't contain first 'v' letter ( Message descriptor not found : *endorBookJDGSource*.viewBooks ).
> Jdg server doesn't show any exception. I use DV 6.4.0 ER3, JDG 7.1 server and JDG 7.1.1 CR2 EAP module.
> In the attachments, I upload my VDB. Remove 'v' letter fix the issue.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months
[JBoss JIRA] (TEIID-5485) JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments fails
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5485?page=com.atlassian.jira.plugin... ]
Work on TEIID-5485 started by Steven Hawkins.
---------------------------------------------
> JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments fails
> --------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-5485
> URL: https://issues.jboss.org/…
[View More]browse/TEIID-5485
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1
> Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Priority: Blocker
>
> JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments, like:
> {code:sql}
> SELECT t2.i
> FROM (
> SELECT DISTINCT 1 a, b from test_tables_pg.test_x) t1,
> table(CALL "views.pr"(arg => t1.a)
> ) sub
> JOIN test_tables_pg.test_y t2 ON true ;;
> {code}
> fails with the following stack trace:
> {code:noformat}
> 2018-09-25 17:47:15,024 ERROR [org.teiid.TRANSPORT] (NIO1) TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core
> .TeiidRuntimeException: TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.Boolean". Please ensure that the column's modeled datatype matc
> hes the expected data.
> at org.teiid.transport.ObjectEncoder.write(ObjectEncoder.java:132)
> at io.netty.channel.AbstractChannelHandlerContext.invokeWrite0(AbstractChannelHandlerContext.java:738)
> at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:730)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:816)
> at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:723)
> at io.netty.channel.ChannelDuplexHandler.write(ChannelDuplexHandler.java:106)
> at io.netty.channel.AbstractChannelHandlerContext.invokeWrite0(AbstractChannelHandlerContext.java:738)
> at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:730)
> at io.netty.channel.AbstractChannelHandlerContext.access$1900(AbstractChannelHandlerContext.java:38)
> at io.netty.channel.AbstractChannelHandlerContext$AbstractWriteTask.write(AbstractChannelHandlerContext.java:1089)
> at io.netty.channel.AbstractChannelHandlerContext$AbstractWriteTask.run(AbstractChannelHandlerContext.java:1078)
> at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:163)
> at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:403)
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:442)
> at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:858)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.Boolean". Please ensure that the colum
> n's modeled datatype matches the expected data.
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:874)
> at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:315)
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1459)
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430)
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178)
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348)
> at org.teiid.net.socket.Message.writeExternal(Message.java:57)
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1459)
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430)
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178)
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348)
> at org.teiid.transport.ObjectEncoder.write(ObjectEncoder.java:112)
> ... 15 more
> Caused by: java.lang.ClassCastException: java.lang.Boolean cannot be cast to java.lang.Integer
> at org.teiid.client.BatchSerializer$IntColumnSerializer.writeObject(BatchSerializer.java:559)
> at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:530)
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:863)
> ... 26 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months
[JBoss JIRA] (TEIID-5482) Dynamic SQL: Executing Dynamic SQL Throws an Error
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5482?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5482.
-----------------------------------
Fix Version/s: 11.1.2
11.2
11.0.3
Resolution: Done
Corrected by also setting the name/type for the update count symbol.
> Dynamic SQL: Executing Dynamic SQL Throws an Error
> --------------------------------------------------
>
> Key: TEIID-5482
> …
[View More] URL: https://issues.jboss.org/browse/TEIID-5482
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1
> Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 11.1.2, 11.2, 11.0.3
>
> Attachments: TEIID_5482_stacktrace.jpg
>
>
> When running the following query:
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query;
> END ;;
> {code}
> in result set can see only:
> {code:noformat}
> Error: 0
> SQLState: 38000
> ErrorCode: 0
> {code}
> but running the following query just adding the "as cnt string":
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query as cnt string;
> END ;;
> {code}
> can see correct "1" in result set. I don't know if it's a correct behavior, maybe it's related to how SQuirrel handles result set.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months
[JBoss JIRA] (TEIID-5482) Dynamic SQL: Executing Dynamic SQL Throws an Error
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5482?page=com.atlassian.jira.plugin... ]
Steven Hawkins reopened TEIID-5482:
-----------------------------------
This is actually an issue with TEIID-4507 - that was an incomplete fix that worked only for embedded connections. Switching to remote you get the exception you are seeing. For some reason squirrel does not log the stacktraces by default, but turning on their debug logging shows an array index out of bounds exception coming from the client.
…
[View More]
> Dynamic SQL: Executing Dynamic SQL Throws an Error
> --------------------------------------------------
>
> Key: TEIID-5482
> URL: https://issues.jboss.org/browse/TEIID-5482
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1
> Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Attachments: TEIID_5482_stacktrace.jpg
>
>
> When running the following query:
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query;
> END ;;
> {code}
> in result set can see only:
> {code:noformat}
> Error: 0
> SQLState: 38000
> ErrorCode: 0
> {code}
> but running the following query just adding the "as cnt string":
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query as cnt string;
> END ;;
> {code}
> can see correct "1" in result set. I don't know if it's a correct behavior, maybe it's related to how SQuirrel handles result set.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months
[JBoss JIRA] (TEIID-5482) Dynamic SQL: Executing Dynamic SQL Throws an Error
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5482?page=com.atlassian.jira.plugin... ]
dalex dalex edited comment on TEIID-5482 at 9/25/18 12:32 PM:
--------------------------------------------------------------
[~shawkins] very sorry for the late reply but I have only stacktrace which I can see in debug mode
!TEIID_5482_stacktrace.jpg|thumbnail!
when running the:
{code:sql}
BEGIN
declare clob sql_query = 'select 1';
execute immediate sql_query;
END ;;
{code}
via SQuirrel. You can …
[View More]see that resultMode has EITHER value. I have suspicious that it's set via either StatementImpl.submitExecute or StatementImpl.execute methods in JDBC driver.
was (Author: dalex005):
[~shawkins] very sorry for the late reply but I have only stacktrace which I can see in debug mode
!TEIID_5482_stacktrace.jpg|thumbnail!
when running the:
{code:sql}
BEGIN
declare clob sql_query = 'select 1';
execute immediate sql_query;
END ;;
{code}
via SQuirrel. You can see that resultMode has EITHER value. I suspicious that it's set via either StatementImpl.submitExecute or StatementImpl.execute methods in JDBC driver.
> Dynamic SQL: Executing Dynamic SQL Throws an Error
> --------------------------------------------------
>
> Key: TEIID-5482
> URL: https://issues.jboss.org/browse/TEIID-5482
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1
> Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Attachments: TEIID_5482_stacktrace.jpg
>
>
> When running the following query:
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query;
> END ;;
> {code}
> in result set can see only:
> {code:noformat}
> Error: 0
> SQLState: 38000
> ErrorCode: 0
> {code}
> but running the following query just adding the "as cnt string":
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query as cnt string;
> END ;;
> {code}
> can see correct "1" in result set. I don't know if it's a correct behavior, maybe it's related to how SQuirrel handles result set.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months
[JBoss JIRA] (TEIID-5482) Dynamic SQL: Executing Dynamic SQL Throws an Error
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5482?page=com.atlassian.jira.plugin... ]
dalex dalex edited comment on TEIID-5482 at 9/25/18 12:32 PM:
--------------------------------------------------------------
[~shawkins] very sorry for the late reply but I have only stacktrace which I can see in debug mode
!TEIID_5482_stacktrace.jpg|thumbnail!
when running the:
{code:sql}
BEGIN
declare clob sql_query = 'select 1';
execute immediate sql_query;
END ;;
{code}
via SQuirrel. You can …
[View More]see that resultMode has EITHER value. I have suspicious that it's set to via either StatementImpl.submitExecute or StatementImpl.execute methods in JDBC driver.
was (Author: dalex005):
[~shawkins] very sorry for the late reply but I have only stacktrace which I can see in debug mode
!TEIID_5482_stacktrace.jpg|thumbnail!
when running the:
{code:sql}
BEGIN
declare clob sql_query = 'select 1';
execute immediate sql_query;
END ;;
{code}
via SQuirrel. You can see that resultMode has EITHER value. I have suspicious that it's set via either StatementImpl.submitExecute or StatementImpl.execute methods in JDBC driver.
> Dynamic SQL: Executing Dynamic SQL Throws an Error
> --------------------------------------------------
>
> Key: TEIID-5482
> URL: https://issues.jboss.org/browse/TEIID-5482
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1
> Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Attachments: TEIID_5482_stacktrace.jpg
>
>
> When running the following query:
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query;
> END ;;
> {code}
> in result set can see only:
> {code:noformat}
> Error: 0
> SQLState: 38000
> ErrorCode: 0
> {code}
> but running the following query just adding the "as cnt string":
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query as cnt string;
> END ;;
> {code}
> can see correct "1" in result set. I don't know if it's a correct behavior, maybe it's related to how SQuirrel handles result set.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months
[JBoss JIRA] (TEIID-5482) Dynamic SQL: Executing Dynamic SQL Throws an Error
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5482?page=com.atlassian.jira.plugin... ]
dalex dalex commented on TEIID-5482:
------------------------------------
[~shawkins] very sorry for the late reply but I have only stacktrace which I can see in debug mode ( !TEIID_5482_stacktrace.jpg|thumbnail! ) when running the:
{code:xml}
BEGIN
declare clob sql_query = 'select 1';
execute immediate sql_query;
END ;;
{code}
via SQuirrel. You can see that resultMode has EITHER value. I …
[View More]suspicious that it's set via either StatementImpl.submitExecute or StatementImpl.execute methods in JDBC driver.
> Dynamic SQL: Executing Dynamic SQL Throws an Error
> --------------------------------------------------
>
> Key: TEIID-5482
> URL: https://issues.jboss.org/browse/TEIID-5482
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1
> Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Attachments: TEIID_5482_stacktrace.jpg
>
>
> When running the following query:
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query;
> END ;;
> {code}
> in result set can see only:
> {code:noformat}
> Error: 0
> SQLState: 38000
> ErrorCode: 0
> {code}
> but running the following query just adding the "as cnt string":
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query as cnt string;
> END ;;
> {code}
> can see correct "1" in result set. I don't know if it's a correct behavior, maybe it's related to how SQuirrel handles result set.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months
[JBoss JIRA] (TEIID-5482) Dynamic SQL: Executing Dynamic SQL Throws an Error
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5482?page=com.atlassian.jira.plugin... ]
dalex dalex edited comment on TEIID-5482 at 9/25/18 12:29 PM:
--------------------------------------------------------------
[~shawkins] very sorry for the late reply but I have only stacktrace which I can see in debug mode
!TEIID_5482_stacktrace.jpg|thumbnail!
when running the:
{code:xml}
BEGIN
declare clob sql_query = 'select 1';
execute immediate sql_query;
END ;;
{code}
via SQuirrel. You can …
[View More]see that resultMode has EITHER value. I suspicious that it's set via either StatementImpl.submitExecute or StatementImpl.execute methods in JDBC driver.
was (Author: dalex005):
[~shawkins] very sorry for the late reply but I have only stacktrace which I can see in debug mode ( !TEIID_5482_stacktrace.jpg|thumbnail! ) when running the:
{code:xml}
BEGIN
declare clob sql_query = 'select 1';
execute immediate sql_query;
END ;;
{code}
via SQuirrel. You can see that resultMode has EITHER value. I suspicious that it's set via either StatementImpl.submitExecute or StatementImpl.execute methods in JDBC driver.
> Dynamic SQL: Executing Dynamic SQL Throws an Error
> --------------------------------------------------
>
> Key: TEIID-5482
> URL: https://issues.jboss.org/browse/TEIID-5482
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.1
> Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Attachments: TEIID_5482_stacktrace.jpg
>
>
> When running the following query:
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query;
> END ;;
> {code}
> in result set can see only:
> {code:noformat}
> Error: 0
> SQLState: 38000
> ErrorCode: 0
> {code}
> but running the following query just adding the "as cnt string":
> {code:sql}
> BEGIN
> declare clob sql_query = 'select 1';
> execute immediate sql_query as cnt string;
> END ;;
> {code}
> can see correct "1" in result set. I don't know if it's a correct behavior, maybe it's related to how SQuirrel handles result set.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
6 years, 6 months