January 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4601) Infinispan DSL Translator: cannot insert into byte array column

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4601?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4601. ----------------------------------- Resolution: Done Merged the pull request. > Infinispan DSL Translator: cannot insert into byte array column > --------------------------------------------------------------- > > Key: TEIID-4601 > URL: https://issues.jboss.org/browse/TEIID-4601 > Project: Teiid > Issue Type: Bug > Components: JDG Connector > Affects Versions: 8.12.7.6_3 > Reporter: Jan Stastny > Assignee: Van Halbert > Fix For: 9.2 > > > When a POJO class field is of type byte[] , insert into a table, which is mapped to the POJO class fails with: > {code:plain} > Caused by: org.teiid.translator.TranslatorException: Conversion from String to byte is not supported > at org.teiid.translator.object.ObjectUpdateExecution.writeColumnData(ObjectUpdateExecution.java:624) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.writeColumnData(ObjectUpdateExecution.java:579) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.writeColumnData(ObjectUpdateExecution.java:572) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.handleInsert(ObjectUpdateExecution.java:208) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.executeUpdate(ObjectUpdateExecution.java:143) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.execute(ObjectUpdateExecution.java:100) ~[?:?] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:404) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:366) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_102] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_102] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_102] > at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_102] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at com.sun.proxy.$Proxy82.execute(Unknown Source) ~[?:?] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_102] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[?:1.8.0_102] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[?:1.8.0_102] > at java.lang.Thread.run(Thread.java:745) ~[?:1.8.0_102] > Caused by: java.lang.IllegalArgumentException: Conversion from String to byte is not supported > at org.teiid.core.util.StringUtil.valueOf(StringUtil.java:797) ~[teiid-jdbc-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.core.util.StringUtil.valueOf(StringUtil.java:768) ~[teiid-jdbc-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.translator.object.ClassRegistry.executeSetMethod(ClassRegistry.java:139) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.writeColumnData(ObjectUpdateExecution.java:608) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.writeColumnData(ObjectUpdateExecution.java:579) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.writeColumnData(ObjectUpdateExecution.java:572) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.handleInsert(ObjectUpdateExecution.java:208) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.executeUpdate(ObjectUpdateExecution.java:143) ~[?:?] > at org.teiid.translator.object.ObjectUpdateExecution.execute(ObjectUpdateExecution.java:100) ~[?:?] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:404) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:366) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_102] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_102] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_102] > at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_102] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at com.sun.proxy.$Proxy82.execute(Unknown Source) ~[?:?] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_102] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) ~[teiid-engine-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[?:1.8.0_102] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[?:1.8.0_102] > at java.lang.Thread.run(Thread.java:745) ~[?:1.8.0_102] > {code} > POJO class: > {code:java|title=SmallA.proto} > package org.jboss.qe.jdg.remote.protobuf; > message SmallA { > required int32 intKey = 1; > optional string stringNum = 2; > required string stringKey = 3; > optional float floatNum = 4; > optional string bigIntegerValue = 5; > optional int32 shortValue = 6; > optional double doubleNum = 7; > optional bytes objectValue = 8; > optional int32 intNum = 9; > optional string bigDecimalValue = 10; > optional int64 longNum = 11; > optional bool booleanValue = 12; > optional int64 timeStampValue = 13; > optional int32 byteNum = 14; > optional int64 timeValue = 15; > optional int64 dateValue = 16; > optional int32 charValue = 17; > } > {code} > Java code used to insert: > {code:java} > PreparedStatement pSt = con.prepareStatement( > "INSERT INTO jdgSource1.SmallA(intKey,stringNum,stringKey,floatNum,bigIntegerValue,shortValue,doubleNum,objectValue,intNum,bigDecimalValue,longNum,booleanValue,timeStampValue,byteNum,timeValue,dateValue,charValue) VALUES" > + "(1,'1','1',1.0,1,1,1,?,1,1.00,1,true,{ts '2016-01-01 12:00:00'},1,'12:00:00','2016-01-01','1')"); > pSt.setBytes(1, "1".getBytes()); > pSt.executeUpdate(); > {code} > The cause is that internally the object translator uses StringUtil which can't handle byte type. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4629) Offer a ddl solution to replace the vdb.xml

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4629?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4629: --------------------------------------- Looks good. I just aligned things more with master to pull out some of the concepts we didn't yet need. So we need to give more thought to ddl in a zip archive - do we want an include/parse statement, or some convention on what order ddl is processed in, etc.? > Offer a ddl solution to replace the vdb.xml > ------------------------------------------- > > Key: TEIID-4629 > URL: https://issues.jboss.org/browse/TEIID-4629 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine, Server > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 9.2 > > > Based upon the work on TEIID-2578 we should first offer the ability to replace the vdb.xml with ddl. We can additionally include some of the work to represent additional pieces of the vdb as api level metadata objects (instead of in the admin layer) where possible. Ideally this should support as much alter functionality as possible. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3624) No way to associate enterprise data types in dynamic vdb constructs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3624?page=com.atlassian.jira.plugin... ] Work on TEIID-3624 started by Steven Hawkins. --------------------------------------------- > No way to associate enterprise data types in dynamic vdb constructs > ------------------------------------------------------------------- > > Key: TEIID-3624 > URL: https://issues.jboss.org/browse/TEIID-3624 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 9.2 > > > I don't find any doc's on how to define enterprise data types in a dynamic vdb. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4716) Teiid -Prelease doesn't update the jdg slot number in kit

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4716?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4716. ----------------------------------- Fix Version/s: 9.2 Resolution: Done Merged the pull request. > Teiid -Prelease doesn't update the jdg slot number in kit > --------------------------------------------------------- > > Key: TEIID-4716 > URL: https://issues.jboss.org/browse/TEIID-4716 > Project: Teiid > Issue Type: Bug > Components: JDG Connector > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.2 > > > The jdg-slot is not being substituted when the dist module is packaged. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4718) Enable JDG resource adapter to support HotRod encryption enablement

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4718?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-4718: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > Enable JDG resource adapter to support HotRod encryption enablement > ------------------------------------------------------------------- > > Key: TEIID-4718 > URL: https://issues.jboss.org/browse/TEIID-4718 > Project: Teiid > Issue Type: Enhancement > Components: JDG Connector > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > > Enable the JDG resource adapter to support the HotRod encryption [1] > http://infinispan.org/docs/9.0.x/infinispan_server_guide/infinispan_serve... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4709) Enable JDG resource adapter to pass the username/password to HotRod Client

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4709?page=com.atlassian.jira.plugin... ] Work on TEIID-4709 stopped by Van Halbert. ------------------------------------------ > Enable JDG resource adapter to pass the username/password to HotRod Client > -------------------------------------------------------------------------- > > Key: TEIID-4709 > URL: https://issues.jboss.org/browse/TEIID-4709 > Project: Teiid > Issue Type: Feature Request > Components: JDG Connector > Affects Versions: 9.3 > Reporter: Van Halbert > Assignee: Van Halbert > > Enable the JDG resource adapter to pass the username/password to the JDG hot rod client. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4718) Enable JDG resource adapter to support HotRod encryption enablement

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4718?page=com.atlassian.jira.plugin... ] Work on TEIID-4718 started by Van Halbert. ------------------------------------------ > Enable JDG resource adapter to support HotRod encryption enablement > ------------------------------------------------------------------- > > Key: TEIID-4718 > URL: https://issues.jboss.org/browse/TEIID-4718 > Project: Teiid > Issue Type: Enhancement > Components: JDG Connector > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > > Enable the JDG resource adapter to support the HotRod encryption [1] > http://infinispan.org/docs/9.0.x/infinispan_server_guide/infinispan_serve... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4718) Enable JDG resource adapter to support HotRod encryption enablement

by Van Halbert (JIRA)

Van Halbert created TEIID-4718: ---------------------------------- Summary: Enable JDG resource adapter to support HotRod encryption enablement Key: TEIID-4718 URL: https://issues.jboss.org/browse/TEIID-4718 Project: Teiid Issue Type: Enhancement Components: JDG Connector Affects Versions: 9.2 Reporter: Van Halbert Assignee: Steven Hawkins Enable the JDG resource adapter to support the HotRod encryption [1] http://infinispan.org/docs/9.0.x/infinispan_server_guide/infinispan_serve... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4578) Create SqlAlchemy Dialect for Teiid

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4578?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4578: ------------------------------------- [~sincandela] It looks like there is a PostgresSQL dialect here [1], you need to try this out with one of the available drivers (prefer py-postgresql) to Teiid as Teiid supports PostgresSQL wire protocol. > Create SqlAlchemy Dialect for Teiid > ----------------------------------- > > Key: TEIID-4578 > URL: https://issues.jboss.org/browse/TEIID-4578 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Tooling > Affects Versions: 9.1.1 > Reporter: Salvatore Incandela > Fix For: Open To Community > > > Create SqlAlchemy Dialect for Teiid > http://www.sqlalchemy.org/ > http://docs.sqlalchemy.org/en/latest/dialects/ -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4709) Enable JDG resource adapter to pass the username/password to HotRod Client

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4709?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4709: ------------------------------------ Authentication is done per-connection and not per-operation. This means it happens at the RemoteCacheManager level: if you want to use different credentials you will need to connect with a separate RCM (which is a very heavy object and will definitely have a negative impact on performance). Will be unable to pass subject on the current thread, as the Subject doesn't contain quite enough information/context to perform the SASL authentication required by Hot Rod (different SASL mechs need different information). > Enable JDG resource adapter to pass the username/password to HotRod Client > -------------------------------------------------------------------------- > > Key: TEIID-4709 > URL: https://issues.jboss.org/browse/TEIID-4709 > Project: Teiid > Issue Type: Feature Request > Components: JDG Connector > Affects Versions: 9.3 > Reporter: Van Halbert > Assignee: Van Halbert > > Enable the JDG resource adapter to pass the username/password to the JDG hot rod client. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2017