[JBoss JIRA] (TEIID-5228) Reference to "element in the tree" in documentation
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5228?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5228:
----------------------------------
Fix Version/s: 10.2
> Reference to "element in the tree" in documentation
> ---------------------------------------------------
>
> Key: TEIID-5228
> URL: https://issues.jboss.org/browse/TEIID-5228
> Project: Teiid
> Issue Type: Bug
> Components: Documentation
> Reporter: Andrej Šmigala
> Assignee: Steven Hawkins
> Fix For: 10.2
>
>
> The section "Writing a Visitor" of the Developer's Guide contains this quote:
> bq. For instance, if you wanted to count the number of elements in the tree, you need only override the visit(ColumnReference) method.
> This is old terminology and shoud be replaced with "column reference"
> {quote}
> shawkins: it's mixing terminology. in the engine (from the old metamatrix days) column references are called element symbols, so a lot of the logic refers to them as elements
> shawkins: it should use the term column reference instead
> {quote}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5225) Building embedded applications without JBoss Third Party repository is not possible
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5225?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5225.
-----------------------------------
Resolution: Done
Effectively created a slim fork of nux and switched to the common version of xerces which also required the explicit inclusion of xml-apis.
> Building embedded applications without JBoss Third Party repository is not possible
> -----------------------------------------------------------------------------------
>
> Key: TEIID-5225
> URL: https://issues.jboss.org/browse/TEIID-5225
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 10.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 10.1
>
>
> Building any Teiid applications like
> - Embedded Teiid based applications
> - WildFly Swarm based applications
> - Spring Boot based applications
> is not possible just using the Maven Central repository, one must include the JBoss Third Party repository to fetch "nux:nux:1.6" jar. This project seems to nowhere to found in maven central and not actively being managed. The alternative solution is to fork the code of this project and build deploy a maven artifact with "org.teiid:nux:1.6" coordinates into Maven Central and use this in Teiid build.
> Also, xerces:xercesImpl seems to be in similar situation, but a stable version of this library is now available in the Maven Central repository. Teiid build should be moved to this version.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5231) teiid designer installation
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5231?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5231:
-------------------------------------
You should use Teiid Forums to ask questions when it is determined that it is issue then you want to open a jira. so, please use forums at https://community.jboss.org/en/teiid?view=discussions
> teiid designer installation
> ---------------------------
>
> Key: TEIID-5231
> URL: https://issues.jboss.org/browse/TEIID-5231
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Affects Versions: 9.0.6
> Reporter: Prasad choudhary
> Assignee: Steven Hawkins
> Priority: Minor
>
> I have 9.0.6 With WildFly/Console standalone server
> 11.1(teiid designer) 9.0(teiid version) trying to install teiid designer studio 11.0.0(Compatible JBDS) GA 4.7 Oxygen(eclipse), Install new software from eclipse is not working since installation artifacts are not available. So went ahead and did the offline installation by extracting zip file at eclipse root folder. after that launched eclipse with '-clean' , I'm not able to see teiid perspective in eclipse, do I'm missing something please let me know
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5232) Add ability to call system functions on VDB Datasource
by Debbie Steigner (JIRA)
Debbie Steigner created TEIID-5232:
--------------------------------------
Summary: Add ability to call system functions on VDB Datasource
Key: TEIID-5232
URL: https://issues.jboss.org/browse/TEIID-5232
Project: Teiid
Issue Type: Feature Request
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Add ability to call the system function teiid_session_set on a EAP VDB datasource
When i send :
select teiid_session_set('project','myProject');
My session variable is changed only on my vdb. I would want to send this command to my VDB EAP datasource. I need to let my vdb's client the opportunity to call teiid_session_set in one of my datasource dynamically. For now, the only way i have found is putting this on my datasource configuration :
<new-connection-sql>select teiid_session_set('country','BELGIUM')</new-connection-sql>
The problem is that this sql request is only called once, at the vdb deployment. I would like to be able to call this request at runtime.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5231) teiid designer installation
by Prasad choudhary (JIRA)
Prasad choudhary created TEIID-5231:
---------------------------------------
Summary: teiid designer installation
Key: TEIID-5231
URL: https://issues.jboss.org/browse/TEIID-5231
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 9.0.6
Reporter: Prasad choudhary
Assignee: Steven Hawkins
Priority: Minor
I have 9.0.6 With WildFly/Console standalone server
11.1(teiid designer) 9.0(teiid version) trying to install teiid designer studio 11.0.0(Compatible JBDS) GA 4.7 Oxygen(eclipse), Install new software from eclipse is not working since installation artifacts are not available. So went ahead and did the offline installation by extracting zip file at eclipse root folder. after that launched eclipse with '-clean' , I'm not able to see teiid perspective in eclipse, do I'm missing something please let me know
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5195) Osisoft translator - applying LIMIT on a UNION query causes syntax error
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5195?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5195:
------------------------------------------------
Andrej Smigala <asmigala(a)redhat.com> changed the Status of [bug 1530523|https://bugzilla.redhat.com/show_bug.cgi?id=1530523] from ON_QA to VERIFIED
> Osisoft translator - applying LIMIT on a UNION query causes syntax error
> ------------------------------------------------------------------------
>
> Key: TEIID-5195
> URL: https://issues.jboss.org/browse/TEIID-5195
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Ramesh Reddy
> Fix For: 8.12.x-6.4, 10.1
>
>
> Query such as
> {code:sql}
> SELECT g_0.intkey FROM bqt1.smalla g_0 UNION SELECT g_1.intkey FROM bqt1.smallb g_1 LIMIT 100
> {code}
> fails with
> {noformat}
> [PIOLEDBENT] [SQL Parser] [Line 1:106] Syntax error at 'TOP'
> {noformat}
> because it is translated as
> {code:sql}
> SELECT g_1.IntKey AS c_0 FROM dvqe..SmallA AS g_1 UNION SELECT g_0.IntKey AS c_0 FROM dvqe..SmallB AS g_0 TOP 100
> {code}
> notice the TOP 100 at the end, instead of right after the SELECT.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5203) Google Spreadsheet translator NPE thrown on UPDATE
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5203?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5203:
------------------------------------------------
Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1531581|https://bugzilla.redhat.com/show_bug.cgi?id=1531581] from ON_QA to VERIFIED
> Google Spreadsheet translator NPE thrown on UPDATE
> --------------------------------------------------
>
> Key: TEIID-5203
> URL: https://issues.jboss.org/browse/TEIID-5203
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 8.12.x-6.4, 10.1, 10.0.3, 9.3.7
>
>
> There is a NPE thrown with UPDATE when there is a matching row (either no criteria or criteria matching at least one row).
> {code:sql}
> UPDATE SmallA SET IntNum=2
> {code}
> {code}
> 15:50:17,006 ERROR [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue71) Connector worker process failed for atomic-request=llOgHAYB6Yd3.31.2.96: java.lang.NullPointerException
> at com.google.gdata.data.spreadsheet.CustomElementCollection.getValue(CustomElementCollection.java:106) [gdata-spreadsheet-3.0.jar:]
> at org.teiid.resource.adapter.google.gdata.GDataClientLoginAPI.listFeedUpdate(GDataClientLoginAPI.java:175) [google-api-8.12.11.6_4-redhat-64-10.jar:8.12.11.6_4-redhat-64-10]
> at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.executeListFeedUpdate(SpreadsheetConnectionImpl.java:114)
> at org.teiid.translator.google.SpreadsheetUpdateExecution.executeUpdate(SpreadsheetUpdateExecution.java:76) [translator-google-8.12.11.6_4-redhat-64-10.jar:8.12.11.6_4-redhat-64-10]
> at org.teiid.translator.google.SpreadsheetUpdateExecution.execute(SpreadsheetUpdateExecution.java:67) [translator-google-8.12.11.6_4-redhat-64-10.jar:8.12.11.6_4-redhat-64-10]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:399)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:361)
> at sun.reflect.GeneratedMethodAccessor209.invoke(Unknown Source) [:1.8.0_151]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_151]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_151]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy79.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:142)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:391)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)
> at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92)
> at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:616)
> at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:69)
> at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:389)
> at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:298)
> at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:270)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.proc.ForEachRowPlan.nextBatch(ForEachRowPlan.java:147)
> at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_151]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_151]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_151]
> 15:50:17,011 WARN [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue71) TEIID30020 Processing exception for request llOgHAYB6Yd3.31 'TEIID30504 Source: null'. Originally TeiidProcessingException CustomElementCollection.java:106. Enable more detailed logging to see the entire stacktrace.
> {code}
> COMMAND LOG:
> {code}
> 15:53:50,025 INFO [org.teiid.COMMAND_LOG] (New I/O worker #1) llOgHAYB6Yd3 START USER COMMAND: startTime=2018-01-05 15:53:50.025 requestID=llOgHAYB6Yd3.33 txID=null sessionID=llOgHAYB6Yd3 applicationName=JDBC principal=user@teiid-security vdbName=googlespreadsheetcrud vdbVersion=1 sql=UPDATE SmallA SET IntNum=2
> 15:53:50,033 DEBUG [org.teiid.COMMAND_LOG] (Worker9_QueryProcessorQueue76) llOgHAYB6Yd3 START DATA SRC COMMAND: startTime=2018-01-05 15:53:50.033 requestID=llOgHAYB6Yd3.33 sourceCommandID=1 executionID=98 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:63850a7c:5a4f89f7:80 status: ActionStatus.RUNNING > modelName=Source translatorName=google-spreadsheet sessionID=llOgHAYB6Yd3 principal=user@teiid-security sql=SELECT Source.smalla.intkey, Source.smalla.stringkey, Source.smalla.intnum, Source.smalla.stringnum, Source.smalla.floatnum, Source.smalla.longnum, Source.smalla.doublenum, Source.smalla.bytenum, Source.smalla.datevalue, Source.smalla.timevalue, Source.smalla.timestampvalue, Source.smalla.booleanvalue, Source.smalla.charvalue, Source.smalla.shortvalue, Source.smalla.bigintegervalue, Source.smalla.bigdecimalvalue, Source.smalla.objectvalue FROM Source.smalla
> 15:53:51,128 DEBUG [org.teiid.COMMAND_LOG] (Worker9_QueryProcessorQueue76) llOgHAYB6Yd3 END SRC COMMAND: endTime=2018-01-05 15:53:51.128 requestID=llOgHAYB6Yd3.33 sourceCommandID=1 executionID=98 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:63850a7c:5a4f89f7:80 status: ActionStatus.RUNNING > modelName=Source translatorName=google-spreadsheet sessionID=llOgHAYB6Yd3 principal=user@teiid-security finalRowCount=30 cpuTime(ns)=37690048
> 15:53:51,129 DEBUG [org.teiid.COMMAND_LOG] (Worker9_QueryProcessorQueue76) llOgHAYB6Yd3 START DATA SRC COMMAND: startTime=2018-01-05 15:53:51.129 requestID=llOgHAYB6Yd3.33 sourceCommandID=2 executionID=99 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:63850a7c:5a4f89f7:80 status: ActionStatus.RUNNING > modelName=Source translatorName=google-spreadsheet sessionID=llOgHAYB6Yd3 principal=user@teiid-security sql=UPDATE Source.smalla SET intkey = 2, stringkey = '2', intnum = 2, stringnum = '812376', floatnum = -27810.0, longnum = 9, doublenum = -1349305.33, bytenum = -121, datevalue = {d'2012-01-26'}, timevalue = null, timestampvalue = null, booleanvalue = FALSE, charvalue = '5', shortvalue = 13825, bigintegervalue = 27147783, bigdecimalvalue = 1703662.0300000, objectvalue = '-106.0' WHERE intkey = 2
> 15:53:51,740 DEBUG [org.teiid.COMMAND_LOG] (Worker9_QueryProcessorQueue76) llOgHAYB6Yd3 ERROR SRC COMMAND: endTime=2018-01-05 15:53:51.74 requestID=llOgHAYB6Yd3.33 sourceCommandID=2 executionID=99 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:63850a7c:5a4f89f7:80 status: ActionStatus.RUNNING > modelName=Source translatorName=google-spreadsheet sessionID=llOgHAYB6Yd3 principal=user@teiid-security
> 15:53:51,746 DEBUG [org.teiid.COMMAND_LOG] (Worker9_QueryProcessorQueue76) llOgHAYB6Yd3 END SRC COMMAND: endTime=2018-01-05 15:53:51.746 requestID=llOgHAYB6Yd3.33 sourceCommandID=2 executionID=99 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:63850a7c:5a4f89f7:80 status: ActionStatus.RUNNING > modelName=Source translatorName=google-spreadsheet sessionID=llOgHAYB6Yd3 principal=user@teiid-security finalRowCount=0 cpuTime(ns)=13526883
> 15:53:51,746 INFO [org.teiid.COMMAND_LOG] (Worker9_QueryProcessorQueue76) llOgHAYB6Yd3 ERROR USER COMMAND: endTime=2018-01-05 15:53:51.746 requestID=llOgHAYB6Yd3.33 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:63850a7c:5a4f89f7:80 status: ActionStatus.RUNNING > sessionID=llOgHAYB6Yd3 principal=user@teiid-security vdbName=googlespreadsheetcrud vdbVersion=1 finalRowCount=null
> 15:53:51,747 INFO [org.teiid.COMMAND_LOG] (Worker9_QueryProcessorQueue76) llOgHAYB6Yd3 END USER COMMAND: endTime=2018-01-05 15:53:51.747 requestID=llOgHAYB6Yd3.33 txID=null sessionID=llOgHAYB6Yd3 principal=user@teiid-security vdbName=googlespreadsheetcrud vdbVersion=1 finalRowCount=0
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5140) Teiid 10 postgres driver version
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5140?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5140.
-----------------------------------
Fix Version/s: 10.0.3
(was: 10.0.1)
Resolution: Done
This is partially resolved for 10.0.1. The latest fix also adds TYPE and SEQUENCE table types to be omitted as tables.
> Teiid 10 postgres driver version
> --------------------------------
>
> Key: TEIID-5140
> URL: https://issues.jboss.org/browse/TEIID-5140
> Project: Teiid
> Issue Type: Bug
> Components: Documentation, JDBC Connector, ODBC
> Reporter: Lukáš Svačina
> Assignee: Steven Hawkins
> Fix For: 10.1, 10.0.3
>
>
> I tried several drivers from https://jdbc.postgresql.org/download.html and figured out that 9.4-1203 JDBC 42 is the newest working driver for my application.
>
> Newer drivers cause Teiid to fail on datasource creation with error "Reason:TEIID60011 No column found on table xxxx.pg_toast.pg_toast_16446 with name chunk_id"
> Please update docs about what driver version is recommended (or tested) and if there is any reason to update to newer postgres drivers (what benefits it brings and how teiid uses it).
> Might be good idea to ship driver within teiid package or at least keep updated _docs\teiid\datasources\postgresql\readme.txt_ to contain recommended driver name.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5226) Error when inserting a Geometry value into PostgreSQL
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5226?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5226.
-----------------------------------
Fix Version/s: 10.1
10.0.3
Resolution: Done
The parameter logic needed to account for the srid and use ST_GEOMFROMWKB function as well.
That does leave one case though unaccounted for - stored procedure parameters are limited in their ability currently to specify expressions, so using a function is not currently possible without some additional refactoring. This is something that we could work around for just postgresql by using an implicitly convertible character string or binary string format. However other databases do not support ewkb, so that's not a general solution.
> Error when inserting a Geometry value into PostgreSQL
> -----------------------------------------------------
>
> Key: TEIID-5226
> URL: https://issues.jboss.org/browse/TEIID-5226
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.12.6_3
> Reporter: Madou Coulibaly
> Assignee: Steven Hawkins
> Fix For: 10.1, 10.0.3
>
> Attachments: server.log
>
>
> Inserting a Geometry value into a PostgreSQL database using Teiid raises an error:
> ERROR: Geometry SRID (0) does not match column SRID (28992)
> Seems we do not take in account the SRID value during this operation.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months