[JBoss JIRA] (TEIID-3539) Infinispan-dsl-cache translator: Can't use IS [NOT] NULL operator for non-string columns
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3539?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3539:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1232649|https://bugzilla.redhat.com/show_bug.cgi?id=1232649] from NEW to CLOSED
> Infinispan-dsl-cache translator: Can't use IS [NOT] NULL operator for non-string columns
> ----------------------------------------------------------------------------------------
>
> Key: TEIID-3539
> URL: https://issues.jboss.org/browse/TEIID-3539
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Van Halbert
> Attachments: server.log
>
>
> If I use IS NULL or IS NOT NULL operator for non-string column, the server will throw the following exception:
> {code}
> 10:42:34,100 ERROR [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue151) Connector worker process failed for atomic-request=1LH0VEAxBj0U.40.0.30: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[176] returned server error (status=0x85): org.hibernate.search.SearchException: Cannot create numeric range query for field byteNum, since from and to values are null
> at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:298)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:88)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:74)
> at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:56)
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:57)
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:24)
> at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:50)
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:72)
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:62)
> at org.teiid.translator.infinispan.dsl.DSLSearch.performSearch(DSLSearch.java:112)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-2973) OData 4 support with Olingo
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2973?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2973:
-------------------------------------
[~vasudevan_madubhushi] I had it coded and available in branch https://github.com/rareddy/teiid/tree/TEIID-2973 here but did not make it into 8.11.Final as it requires couple changes from Olingo library. I need to wait for them to release next revision to check in these changes.
> OData 4 support with Olingo
> ---------------------------
>
> Key: TEIID-2973
> URL: https://issues.jboss.org/browse/TEIID-2973
> Project: Teiid
> Issue Type: Task
> Components: Misc. Connectors, OData
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Labels: CR1
> Fix For: 8.11
>
>
> Whenever an olingo final is available for odata 3/4 we'll want to utilize that. The best guess now is that this will happen in the 8.9 timeframe. Additional support can then be added for later odata features, which will have subtasks as necessary.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-2973) OData 4 support with Olingo
by Vasudevan Madubhushi (JIRA)
[ https://issues.jboss.org/browse/TEIID-2973?page=com.atlassian.jira.plugin... ]
Vasudevan Madubhushi commented on TEIID-2973:
---------------------------------------------
Hi Ramesh,
Did the support for $expand go into into 8.11 Final? Appreciate your help on this.
My Syntax is :
http://10.47.86.130:8080/odata/FirePanels2.1/FirePanels(1)?$expand=Softwa...
I get this as my response. The SoftwareUnits entity is related to FirePanels entity by pkey.
{
"d" : {
"__metadata" : {
"uri" : "http://10.47.86.130:8080/odata/FirePanels2.1/FirePanels.FirePanels(1L)", "type" : "FirePanels.FirePanels"
}, "pkey" : "1", "keySerialModel" : "asset-one", "assetType" : "FirePanel", "SoftwareUnits" : {
"__deferred" : {
"uri" : "http://10.47.86.130:8080/odata/FirePanels2.1/FirePanels.FirePanels(1L)/So..."
}
}
}
}
Server Logs if its of any help:
13:49:30,409 INFO [org.odata4j.producer.resources.EntityRequestResource] (http-/10.47.86.130:8080-5) null getEntity(FirePanels,(1),SoftwareUnits,null)
13:49:31,074 INFO [org.odata4j.producer.resources.EntityRequestResource] (http-/10.47.86.130:8080-5) null getEntity(FirePanels,(1),SoftwareUnits,null)
13:49:31,577 INFO [org.odata4j.producer.resources.EntityRequestResource] (http-/10.47.86.130:8080-5) null getEntity(FirePanels,(1),SoftwareUnits,null)
> OData 4 support with Olingo
> ---------------------------
>
> Key: TEIID-2973
> URL: https://issues.jboss.org/browse/TEIID-2973
> Project: Teiid
> Issue Type: Task
> Components: Misc. Connectors, OData
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Labels: CR1
> Fix For: 8.11
>
>
> Whenever an olingo final is available for odata 3/4 we'll want to utilize that. The best guess now is that this will happen in the 8.9 timeframe. Additional support can then be added for later odata features, which will have subtasks as necessary.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3535) Infinispan-dsl-cache translator: NPE when inserting data if a table doesn't have primary key defined
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3535?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3535:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1232240|https://bugzilla.redhat.com/show_bug.cgi?id=1232240] from NEW to CLOSED
> Infinispan-dsl-cache translator: NPE when inserting data if a table doesn't have primary key defined
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIID-3535
> URL: https://issues.jboss.org/browse/TEIID-3535
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Van Halbert
> Fix For: 8.7.1.6_2, 8.12, 8.11.1
>
>
> Exception:
> {code}
> ERROR [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue194) Connector worker process failed for atomic-request=ziNYENHc9zCz.0.0.33: java.lang.NullPointerException
> at org.teiid.translator.infinispan.dsl.InfinispanUpdateExecution.handleInsert(InfinispanUpdateExecution.java:149)
> at org.teiid.translator.infinispan.dsl.InfinispanUpdateExecution.execute(InfinispanUpdateExecution.java:107)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:358) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3533) Infinispan-dsl-cache translator: can't insert value into BYTE and BIGINTEGER columns
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3533?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3533:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1232182|https://bugzilla.redhat.com/show_bug.cgi?id=1232182] from NEW to CLOSED
> Infinispan-dsl-cache translator: can't insert value into BYTE and BIGINTEGER columns
> ------------------------------------------------------------------------------------
>
> Key: TEIID-3533
> URL: https://issues.jboss.org/browse/TEIID-3533
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Van Halbert
> Fix For: 8.7.1.6_2, 8.12, 8.11.1
>
> Attachments: server.log, testVDB.vdb
>
>
> Sample query:
> {code}
> insert into smalla(intKey, byteNum) values(100,100);
> insert into smalla(intKey, BIGINTEGERVALUE) values(100,100);
> {code}
> Exception:
> {code}
> [org.teiid.CONNECTOR] (Worker9_QueryProcessorQueue59) Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.20.0.13: java.lang.IllegalArgumentException: Conversion from String to java.math.BigDecimal is not supported
> at org.teiid.core.util.StringUtil.valueOf(StringUtil.java:797) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> at org.teiid.core.util.PropertiesUtils.setProperty(PropertiesUtils.java:792) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> at org.teiid.core.util.PropertiesUtils.setBeanProperty(PropertiesUtils.java:782) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> at org.teiid.translator.infinispan.dsl.InfinispanUpdateExecution.handleInsert(InfinispanUpdateExecution.java:204)
> {code}
> The VDB and the server log is attached.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3533) Infinispan-dsl-cache translator: can't insert value into BYTE and BIGINTEGER columns
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3533?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3533:
------------------------------------
There were several issues here:
- the model that was used didn't correspond to what was created when using the Teiid Connection Importer, which had data types on the source model mis-aligned.
- the logic needed to use DataTypeManager.transformValue to handle to help in broader conversion cases.
- and another issue was encountered (when the above was resolved) in that the JDG confirmed it has an issue with boolean columns. JDG will throw an exception if no value is specified in the insert or there's no default defined in the protobuf definition.
> Infinispan-dsl-cache translator: can't insert value into BYTE and BIGINTEGER columns
> ------------------------------------------------------------------------------------
>
> Key: TEIID-3533
> URL: https://issues.jboss.org/browse/TEIID-3533
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Van Halbert
> Fix For: 8.7.1.6_2, 8.12, 8.11.1
>
> Attachments: server.log, testVDB.vdb
>
>
> Sample query:
> {code}
> insert into smalla(intKey, byteNum) values(100,100);
> insert into smalla(intKey, BIGINTEGERVALUE) values(100,100);
> {code}
> Exception:
> {code}
> [org.teiid.CONNECTOR] (Worker9_QueryProcessorQueue59) Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.20.0.13: java.lang.IllegalArgumentException: Conversion from String to java.math.BigDecimal is not supported
> at org.teiid.core.util.StringUtil.valueOf(StringUtil.java:797) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> at org.teiid.core.util.PropertiesUtils.setProperty(PropertiesUtils.java:792) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> at org.teiid.core.util.PropertiesUtils.setBeanProperty(PropertiesUtils.java:782) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> at org.teiid.translator.infinispan.dsl.InfinispanUpdateExecution.handleInsert(InfinispanUpdateExecution.java:204)
> {code}
> The VDB and the server log is attached.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3535) Infinispan-dsl-cache translator: NPE when inserting data if a table doesn't have primary key defined
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3535?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3535:
-------------------------------
Fix Version/s: 8.7.1.6_2
8.12
8.11.1
> Infinispan-dsl-cache translator: NPE when inserting data if a table doesn't have primary key defined
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIID-3535
> URL: https://issues.jboss.org/browse/TEIID-3535
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Van Halbert
> Fix For: 8.7.1.6_2, 8.12, 8.11.1
>
>
> Exception:
> {code}
> ERROR [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue194) Connector worker process failed for atomic-request=ziNYENHc9zCz.0.0.33: java.lang.NullPointerException
> at org.teiid.translator.infinispan.dsl.InfinispanUpdateExecution.handleInsert(InfinispanUpdateExecution.java:149)
> at org.teiid.translator.infinispan.dsl.InfinispanUpdateExecution.execute(InfinispanUpdateExecution.java:107)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:358) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-1.jar:8.7.1.6_2-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3532) Infinispan-dsl-cache translator: Exception is thrown when order by clause is used
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3532?page=com.atlassian.jira.plugin... ]
Van Halbert closed TEIID-3532.
------------------------------
Resolution: Cannot Reproduce Bug
> Infinispan-dsl-cache translator: Exception is thrown when order by clause is used
> ---------------------------------------------------------------------------------
>
> Key: TEIID-3532
> URL: https://issues.jboss.org/browse/TEIID-3532
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Van Halbert
> Attachments: server.log
>
>
> Infinispan-dsl-cache translator will fail if order by clause is pushed down.
> Sample query:
> {code}
> select intKey from smalla where intkey > 1 order by intKey
> {code}
> Exception:
> {code}
> Connector worker process failed for atomic-request=iLuNd1gO/2N0.4.0.7: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[38] returned server error (status=0x85): org.hibernate.hql.ParsingException: HQLPARSER000002: The query FROM org.jboss.qe.jdg_remote.protobuf.SmallA _gen0 WHERE _gen0.intKey > 1 ORDER BY _gen0.null ASC is not valid; Parser error messages: [[statement, statementElement, selectStatement, orderByClause, sortSpecification, sortKey, concatenation, additiveExpression, multiplyExpression, unaryExpression, atom, identPrimary]: line 1:89 mismatched token: [@32,89:92='null',<124>,1:89]; expecting type IDENTIFIER].
> at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:298)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:88)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:74)
> {code}
> Full log is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3532) Infinispan-dsl-cache translator: Exception is thrown when order by clause is used
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3532?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3532:
------------------------------------
Have not been able to recreate when I've gone thru the process of using Teiid Designer and the Teiid Connection Importer to create the source model. And we know that the model that was had data types that did not correspond to what the importer was indicating.
I've been able to execute the following query using order by against the same data source:
Select intKey, stringKey, stringNum, intNum, booleanValue from SmallA.SmallA order by intKey
Marking as not reproducible at this time.
> Infinispan-dsl-cache translator: Exception is thrown when order by clause is used
> ---------------------------------------------------------------------------------
>
> Key: TEIID-3532
> URL: https://issues.jboss.org/browse/TEIID-3532
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Van Halbert
> Attachments: server.log
>
>
> Infinispan-dsl-cache translator will fail if order by clause is pushed down.
> Sample query:
> {code}
> select intKey from smalla where intkey > 1 order by intKey
> {code}
> Exception:
> {code}
> Connector worker process failed for atomic-request=iLuNd1gO/2N0.4.0.7: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[38] returned server error (status=0x85): org.hibernate.hql.ParsingException: HQLPARSER000002: The query FROM org.jboss.qe.jdg_remote.protobuf.SmallA _gen0 WHERE _gen0.intKey > 1 ORDER BY _gen0.null ASC is not valid; Parser error messages: [[statement, statementElement, selectStatement, orderByClause, sortSpecification, sortKey, concatenation, additiveExpression, multiplyExpression, unaryExpression, atom, identPrimary]: line 1:89 mismatched token: [@32,89:92='null',<124>,1:89]; expecting type IDENTIFIER].
> at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:298)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:88)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:74)
> {code}
> Full log is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months