[JBoss JIRA] (TEIID-3534) Infinispan-dsl-cache translator: can't insert null into column of type boolean
by Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3534?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3534:
-------------------------------
Description:
Inserting null into boolean column causes exception.
Sample queries:
{code}
insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
insert into smalla(intKey, stringKey) values(128,'ss');
{code}
This query works:
{code}
insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);
{code}
Exception:
{code}
Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.52.0.44: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[239] returned server error (status=0x85): org.hibernate.search.bridge.BridgeException: Exception while calling bridge#set
class: org.infinispan.query.remote.indexing.ProtobufValueWrapper
path:
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)
{code}
This bug breaks data integrity. If this exception is thrown, data will be inserted but it won't be indexed.
The whole exception is in the attachment.
was:
Inserting null into boolean column causes exception.
Sample queries:
insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
insert into smalla(intKey, stringKey) values(128,'ss');
This query works:
insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);
Exception:
Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.52.0.44: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[239] returned server error (status=0x85): org.hibernate.search.bridge.BridgeException: Exception while calling bridge#set
class: org.infinispan.query.remote.indexing.ProtobufValueWrapper
path:
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)
This bug breaks data integrity. If this exception is thrown, data will be inserted but it won't be indexed.
The whole exception is in the attachment.
> Infinispan-dsl-cache translator: can't insert null into column of type boolean
> ------------------------------------------------------------------------------
>
> Key: TEIID-3534
> URL: https://issues.jboss.org/browse/TEIID-3534
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log, testVDB.vdb
>
>
> Inserting null into boolean column causes exception.
> Sample queries:
> {code}
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
> insert into smalla(intKey, stringKey) values(128,'ss');
> {code}
> This query works:
> {code}
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);
> {code}
> Exception:
> {code}
> Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.52.0.44: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[239] returned server error (status=0x85): org.hibernate.search.bridge.BridgeException: Exception while calling bridge#set
> class: org.infinispan.query.remote.indexing.ProtobufValueWrapper
> path:
> 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)
> {code}
> This bug breaks data integrity. If this exception is thrown, data will be inserted but it won't be indexed.
> The whole exception is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3534) Infinispan-dsl-cache translator: can't insert null into column of type boolean
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3534?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-3534:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1232236
> Infinispan-dsl-cache translator: can't insert null into column of type boolean
> ------------------------------------------------------------------------------
>
> Key: TEIID-3534
> URL: https://issues.jboss.org/browse/TEIID-3534
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log, testVDB.vdb
>
>
> Inserting null into boolean column causes exception.
> Sample queries:
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
> insert into smalla(intKey, stringKey) values(128,'ss');
> This query works:
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);
> Exception:
> Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.52.0.44: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[239] returned server error (status=0x85): org.hibernate.search.bridge.BridgeException: Exception while calling bridge#set
> class: org.infinispan.query.remote.indexing.ProtobufValueWrapper
> path:
> 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)
> This bug breaks data integrity. If this exception is thrown, data will be inserted but it won't be indexed.
> The whole exception is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3534) Infinispan-dsl-cache translator: can't insert null into column of type boolean
by Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3534?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3534:
-------------------------------
Attachment: server.log
Server log
> Infinispan-dsl-cache translator: can't insert null into column of type boolean
> ------------------------------------------------------------------------------
>
> Key: TEIID-3534
> URL: https://issues.jboss.org/browse/TEIID-3534
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log, testVDB.vdb
>
>
> Inserting null into boolean column causes exception.
> Sample queries:
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
> insert into smalla(intKey, stringKey) values(128,'ss');
> This query works:
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);
> Exception:
> Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.52.0.44: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[239] returned server error (status=0x85): org.hibernate.search.bridge.BridgeException: Exception while calling bridge#set
> class: org.infinispan.query.remote.indexing.ProtobufValueWrapper
> path:
> 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)
> This bug breaks data integrity. If this exception is thrown, data will be inserted but it won't be indexed.
> The whole exception is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3534) Infinispan-dsl-cache translator: can't insert null into column of type boolean
by Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3534?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3534:
-------------------------------
Attachment: testVDB.vdb
VDB
> Infinispan-dsl-cache translator: can't insert null into column of type boolean
> ------------------------------------------------------------------------------
>
> Key: TEIID-3534
> URL: https://issues.jboss.org/browse/TEIID-3534
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1.6_2
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: testVDB.vdb
>
>
> Inserting null into boolean column causes exception.
> Sample queries:
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
> insert into smalla(intKey, stringKey) values(128,'ss');
> This query works:
> insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);
> Exception:
> Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.52.0.44: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[239] returned server error (status=0x85): org.hibernate.search.bridge.BridgeException: Exception while calling bridge#set
> class: org.infinispan.query.remote.indexing.ProtobufValueWrapper
> path:
> 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)
> This bug breaks data integrity. If this exception is thrown, data will be inserted but it won't be indexed.
> The whole exception is in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3534) Infinispan-dsl-cache translator: can't insert null into column of type boolean
by Filip Elias (JIRA)
Filip Elias created TEIID-3534:
----------------------------------
Summary: Infinispan-dsl-cache translator: can't insert null into column of type boolean
Key: TEIID-3534
URL: https://issues.jboss.org/browse/TEIID-3534
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7.1.6_2
Reporter: Filip Elias
Assignee: Steven Hawkins
Inserting null into boolean column causes exception.
Sample queries:
insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',null);
insert into smalla(intKey, stringKey) values(128,'ss');
This query works:
insert into smalla(intKey, stringKey,booleanValue) values(128,'ss',false);
Exception:
Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.52.0.44: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[239] returned server error (status=0x85): org.hibernate.search.bridge.BridgeException: Exception while calling bridge#set
class: org.infinispan.query.remote.indexing.ProtobufValueWrapper
path:
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)
This bug breaks data integrity. If this exception is thrown, data will be inserted but it won't be indexed.
The whole exception is in the attachment.
--
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 Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3533?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3533:
-------------------------------
Attachment: testVDB.vdb
The VDB through which data are inserted
> 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: Steven Hawkins
> 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 Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3533?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3533:
-------------------------------
Attachment: server.log
Server log
> 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: Steven Hawkins
> 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 Filip Elias (JIRA)
Filip Elias created TEIID-3533:
----------------------------------
Summary: 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: Steven Hawkins
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-3524) Database Logging not working
by Jan Stastny (JIRA)
[ https://issues.jboss.org/browse/TEIID-3524?page=com.atlassian.jira.plugin... ]
Jan Stastny commented on TEIID-3524:
------------------------------------
I tried to log more logs than is the batch-size value (I ran a query ten times, which should produce 40 log entries, batch-size is 25 by default), but still nothing gets into the logging database.
To provide logs I have altered persistence.xml in database-service.jar as follows (the only edited property is hibernate.show_sql):
{code:xml}
<persistence version="2.0"
xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="
http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="teiid-logger">
<jta-data-source>java:/teiid-log-ds</jta-data-source>
<properties>
<!-- Properties for Hibernate -->
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.jdbc.batch_size" value="25"/>
</properties>
</persistence-unit>
</persistence>
{code}
Then I set org.hibernate.SQL logger to DEBUG level and examined the server.log for corresponding log entries. There are no entries suggesting, that anything gets through Hibernate. Compared to older versions, there are NO logs as:
{code:plain}
13:30:19,548 DEBUG [org.hibernate.SQL] (pool-1-thread-1) select next_val as id_val from hibernate_sequence for update
13:30:19,706 DEBUG [org.hibernate.SQL] (pool-1-thread-1) update hibernate_sequence set next_val= ? where next_val=?
13:30:20,018 DEBUG [org.hibernate.SQL] (pool-1-thread-1) insert into commandlog (applicationname, executionid, modelname, principal, queryplan, requestid, row_count, sessionid, sourcecommand, sourcerequestid, sqlcmd, eventtype, logtime, transactionid, translatorname, vdbname, vdbversion, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
{code}
But there are present org.teiid.COMMAND_LOG entries in server.log:
{code:plain}
08:27:49,547 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1) START DATA SRC COMMAND: startTime=2015-06-16 08:27:49.547 requestID=YQFPgFN1w2US.0 sourceCommandID=0 executionID=0 txID=null modelName=Accounts translatorName=translator-h2 sessionID=YQFPgFN1w2US principal=user@teiid-security sql=SELECT g_0.ID, g_0.SYMBOL, g_0.COMPANY_NAME FROM Accounts.PRODUCT AS g_0
08:27:49,552 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue2) END SRC COMMAND: endTime=2015-06-16 08:27:49.552 requestID=YQFPgFN1w2US.0 sourceCommandID=0 executionID=0 txID=null modelName=Accounts translatorName=translator-h2 sessionID=YQFPgFN1w2US principal=user@teiid-security finalRowCount=25
08:27:49,598 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue3) END USER COMMAND: endTime=2015-06-16 08:27:49.598 requestID=YQFPgFN1w2US.0 txID=null sessionID=YQFPgFN1w2US principal=user@teiid-security vdbName=Portfolio vdbVersion=1 finalRowCount=25
08:27:49,598 DEBUG [org.teiid.COMMAND_LOG] (New I/O worker #75) START USER COMMAND: startTime=2015-06-16 08:27:49.598 requestID=YQFPgFN1w2US.1 txID=null sessionID=YQFPgFN1w2US applicationName=JDBC principal=user@teiid-security vdbName=Portfolio vdbVersion=1 sql=select * from product
{code}
> Database Logging not working
> ----------------------------
>
> Key: TEIID-3524
> URL: https://issues.jboss.org/browse/TEIID-3524
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Jan Stastny
> Assignee: Van Halbert
>
> When using db logging in Teiid, nothing gets inserted into the db. Logs appear at server.log, but not in the db.
> I set up the logging as follows:
> Created java:/teiid-log-ds datasource.
> Added these to logging subsystem:
> {code:xml}
> <async-handler name="TEIID_COMMAND_LOG">
> <level name="DEBUG"/>
> <queue-length value="50"/>
> <overflow-action value="block"/>
> <subhandlers>
> <handler name="TEIID_JPA_LOG"/>
> </subhandlers>
> </async-handler>
> <async-handler name="TEIID_AUDIT_LOG">
> <level name="DEBUG"/>
> <queue-length value="50"/>
> <overflow-action value="block"/>
> <subhandlers>
> <handler name="TEIID_JPA_LOG"/>
> </subhandlers>
> </async-handler>
> <custom-handler name="TEIID_JPA_LOG" class="org.teiid.logger.DatabaseAppender" module="org.jboss.teiid.extensions">
> <level name="DEBUG"/>
> </custom-handler>
> <logger category="org.teiid.COMMAND_LOG">
> <level name="DEBUG"/>
> <handlers>
> <handler name="TEIID_COMMAND_LOG"/>
> </handlers>
> </logger>
> <logger category="org.teiid.AUDIT_LOG">
> <level name="DEBUG"/>
> <handlers>
> <handler name="TEIID_AUDIT_LOG"/>
> </handlers>
> </logger>
> {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 RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3532?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-3532:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1232169
> 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: Steven Hawkins
> 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