[JBoss JIRA] (TEIID-3907) Support compensating transactions for updatable non-XA sources
by Van Halbert (JIRA)
Van Halbert created TEIID-3907:
----------------------------------
Summary: Support compensating transactions for updatable non-XA sources
Key: TEIID-3907
URL: https://issues.jboss.org/browse/TEIID-3907
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 9.x
Reporter: Van Halbert
Assignee: Steven Hawkins
From: "Steven Hawkins" <shawkins(a)redhat.com>
To: "Steve Tran" <stran(a)redhat.com>
Cc: "Frederic Hornain" <fhornain(a)redhat.com>, "sme-dataservicesplatform" <sme-dataservicesplatform(a)redhat.com>
Sent: Monday, January 18, 2016 8:30:49 AM
Subject: Re: [RHB] Atomic and distributed transaction
The transaction manager will fully support xa with all xa sources and a single local transaction resource. Beyond that however there is no built-in support for compensating transactions with non-XA sources. There has been work in Narayana on compensating transactions though that could be used by custom web apps consuming Teiid. We would like to eventually offer compensating options for some of our updatable non-XA sources, but it hasn't had sufficient priority yet.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3904) TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" on openquery update command
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3904?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3904:
----------------------------------
Fix Version/s: 8.13
(was: 9.0)
> TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" on openquery update command
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-3904
> URL: https://issues.jboss.org/browse/TEIID-3904
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Fix For: 8.13
>
>
> Getting an error when attempting to update an Oracle Table that was virtualized in JDV.
> Here's the query
> update A
> set do_not_use = 1
> FROM OPENQUERY(HSI, 'SELECT * FROM hsi_DW_ebl.hsi_tm_pd where do_not_use is null') A
> where do_not_use is null;
> {code}
> [Server:cdtssoa126d-jdv-one] 21:14:35,311 WARN [org.teiid.ODBC] (Worker975_QueryProcessorQueue8734224) TEIID40020 Error occurred: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" at line 1, column 1.
> [Server:cdtssoa126d-jdv-one] Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1001) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" at line 1, column 1.
> [Server:cdtssoa126d-jdv-one] Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:164) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:140) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:279) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:363) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] ... 8 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-3871 at 1/17/16 9:15 PM:
-------------------------------------------------------------
h2. Quick Overview
Quick overview: [https://teiid.gitbooks.io/documents/content/index.html]
Sources Content link: [https://github.com/teiid/teiid-documents]
h2.Document Migration Status
||Name||Status||link||
|Embedded Guide |Done |[https://www.gitbook.com/book/teiid/embedded-guide/details] |
|Security Guide |Done |[https://www.gitbook.com/book/teiid/security-guide/details] |
|Caching Guide |Done |[https://www.gitbook.com/book/teiid/caching-guide/details] |
|Administrator's Guide |Done |[https://www.gitbook.com/book/teiid/administrator-s-guide/details] |
|Client Developer's Guide |Done |[https://www.gitbook.com/book/teiid/client-developer-guide/details] |
|Developer's Guide |Done |[https://www.gitbook.com/book/teiid/developer-s-guide/details] |
|Reference Guide |Pending |- |
{color:#d04437}*Note that*{color}: Once a doc in '*Done*' status, please update doc via submit to Github, rather than edit Conference pages.
was (Author: kylin):
h2. Quick Overview
Quick overview: [https://teiid.gitbooks.io/documents/content/index.html]
Sources Content link: [https://github.com/teiid/teiid-documents]
h2.Document Migration Status
||Name||Status||link||
|Embedded Guide |Done |[https://www.gitbook.com/book/teiid/embedded-guide/details] |
|Security Guide |Done |[https://www.gitbook.com/book/teiid/security-guide/details] |
|Caching Guide |Done |[https://www.gitbook.com/book/teiid/caching-guide/details] |
|Administrator's Guide |Done |[https://www.gitbook.com/book/teiid/administrator-s-guide/details] |
|Client Developer's Guide |Pending |- |
|Developer's Guide |Pending |- |
|Reference Guide |Scheduled |- |
{color:#d04437}*Note that*{color}: Once a doc in '*Done*' status, please update doc via submit to Github, rather than edit Conference pages.
> moving documentation from confluence to gitbook
> -------------------------------------------------
>
> Key: TEIID-3871
> URL: https://issues.jboss.org/browse/TEIID-3871
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> From Teiid DV 7 F2F Notes,
> " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible."
> This issue will address this.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3904) TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" on openquery update command
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3904?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3904.
-----------------------------------
Fix Version/s: 9.0
Resolution: Done
Updated the pg emulation to look for FORWARD in fetches and FORWARD/BACKWARD in moves. This can be expanded further if needed.
> TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" on openquery update command
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-3904
> URL: https://issues.jboss.org/browse/TEIID-3904
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> Getting an error when attempting to update an Oracle Table that was virtualized in JDV.
> Here's the query
> update A
> set do_not_use = 1
> FROM OPENQUERY(HSI, 'SELECT * FROM hsi_DW_ebl.hsi_tm_pd where do_not_use is null') A
> where do_not_use is null;
> {code}
> [Server:cdtssoa126d-jdv-one] 21:14:35,311 WARN [org.teiid.ODBC] (Worker975_QueryProcessorQueue8734224) TEIID40020 Error occurred: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" at line 1, column 1.
> [Server:cdtssoa126d-jdv-one] Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1001) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" at line 1, column 1.
> [Server:cdtssoa126d-jdv-one] Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:164) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:140) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:279) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:363) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] ... 8 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3869) Enable Teiid to be exposed as a GIS compliant data source
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3869?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIID-3869 at 1/15/16 9:23 AM:
----------------------------------------------------------------
Added an initial commit for 9.0 that will backport cleanly. The functions added are:
ST_SIMPLIFY
ST_FORCE_2D (currently just a dummy function)
ST_ENVELOPE
ST_WITHIN
ST_DWITHIN
ST_EXTENT (aggregate function)
ST_HASARC (currently just a dummy function)
&& (operator that we only support with geometry arguments)
ST_GEOMFROMEWKT
ST_ASEWKB
ST_GEOMFROMEWKB
To run with Geoserver you can setup a postgis instance - http://docs.geoserver.org/stable/en/user/gettingstarted/postgis-quickstar...
The instructions are a little out of date, you may just use psql to add the postgis extensions - http://postgis.net/docs/postgis_installation.html
Run Teiid and add that postgresl/postgis instance as a source:
For example in embedded:
ModelMetaData mmd = new ModelMetaData();
mmd.setName("public");
mmd.setModelType(Model.Type.PHYSICAL);
mmd.addSourceMapping("pg", "pg", "pg");
mmd.addProperty("importer.useQualifiedName", "false");
mmd.addProperty("importer.schemaPattern", "public");
mmd.addProperty("importer.excludeTables", "geometry_columns");
es.deployVDB("nyc", mmd);
Note that useQualifiedNames is off and we specifically exclude geometry_columns from the source - this is because Geoserver makes unqualified queries that reference geometry_columns and we need it to resolve against our system table, rather that being ambiguous. You'll also need the pg/ODBC transport to be enabled:
EmbeddedConfiguration ec = new EmbeddedConfiguration();
SocketConfiguration sc = new SocketConfiguration();
sc.setProtocol(WireProtocol.pg);
sc.setPortNumber(5433);
ec.addTransport(sc);
Also org.teiid.backslashDefaultMatchEscape must be set to true as geoserver will issue pg (non-ansi) queries with like predicates assuming \ as the escape.
>From there just follow the instructions from the rest of http://docs.geoserver.org/stable/en/user/gettingstarted/postgis-quickstar... but point it to the Teiid port instead of postgresl.
was (Author: shawkins):
Added an initial commit for 9.0 that will backport cleanly. The functions added are:
ST_SIMPLIFY
ST_FORCE_2D (currently just a dummy function)
ST_ENVELOPE
ST_WITHIN
ST_DWITHIN
ST_EXTENT (aggregate function)
ST_HASARC (currently just a dummy function)
&& (operator that we only support with geometry arguments)
ST_GEOMFROMEWKT
ST_ASEWKB
ST_GEOMFROMEWKB
To run with Geoserver you can setup a postgis instance - http://docs.geoserver.org/stable/en/user/gettingstarted/postgis-quickstar...
The instructions are a little out of date, you may just use psql to add the postgis extensions - http://postgis.net/docs/postgis_installation.html
Run Teiid and add that postgresl/postgis instance as a source:
For example in embedded:
ModelMetaData mmd = new ModelMetaData();
mmd.setName("public");
mmd.setModelType(Model.Type.PHYSICAL);
mmd.addSourceMapping("pg", "pg", "pg");
mmd.addProperty("importer.useQualifiedName", "false");
mmd.addProperty("importer.schemaPattern", "public");
mmd.addProperty("importer.excludeTables", "geometry_columns");
es.deployVDB("nyc", mmd);
Note that useQualifiedNames is off and we specifically exclude geometry_columns from the source - this is because Geoserver makes unqualified queries that reference geometry_columns and we need it to resolve against our system table, rather that being ambiguous. You'll also need the pg/ODBC transport to be enabled:
EmbeddedConfiguration ec = new EmbeddedConfiguration();
SocketConfiguration sc = new SocketConfiguration();
sc.setProtocol(WireProtocol.pg);
sc.setPortNumber(5433);
ec.addTransport(sc);
>From there just follow the instructions from the rest of http://docs.geoserver.org/stable/en/user/gettingstarted/postgis-quickstar... but point it to the Teiid port instead of postgresl.
> Enable Teiid to be exposed as a GIS compliant data source
> ---------------------------------------------------------
>
> Key: TEIID-3869
> URL: https://issues.jboss.org/browse/TEIID-3869
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver, OData, ODBC
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> See
> http://www.esri.com/~/media/Files/Pdfs/library/whitepapers/pdfs/supported...
> WMS - http://www.opengeospatial.org/standards/wms
> WFS - http://www.opengeospatial.org/standards/wfs
> Using MapViewer to show maps based on WMS services. The WMS services are provided by a GeoServer like ArcGIS or GeoServer.
> OData has also some capabilities in the Geo space especially on the .Net libraries side.
> See http://www.odata.org/libraries/ for Microsoft.Spatial (OData v4) and System.Spatial (OData v1-3)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3905) ODBC openquery permission issues when insert oracle date field
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3905?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIID-3905 at 1/15/16 8:14 AM:
----------------------------------------------------------------
OPENQUERY looks to require updatable cursors, which are not supported. You can retry the updateable cursors disabled - http://www.postgresql.org/message-id/attachment/15329/config.html
was (Author: shawkins):
OPENQUERY looks to require updatable cursors, which are not supported.
> ODBC openquery permission issues when insert oracle date field
> --------------------------------------------------------------
>
> Key: TEIID-3905
> URL: https://issues.jboss.org/browse/TEIID-3905
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Priority: Critical
>
> Getting an error when attempting to insert a new row into an virtualized Oracle Table in JDV.
> Here's the query
> INSERT INTO OPENQUERY(testb, 'SELECT * FROM TestVBL.HSI_AGGR_PROC_LK')
> VALUES ('TEST 1:18am', cast (getdate() as date))
> {code}
> OLE DB provider "MSDASQL" for linked server "testb" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
> Msg 7344, Level 16, State 1, Line 1
> The OLE DB provider "MSDASQL" for linked server "testb" could not INSERT INTO table "[MSDASQL]" because of column "LK_DT". The user did not have permission to write to the column.
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3904) TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" on openquery update command
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3904?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3904:
----------------------------------
Priority: Major (was: Critical)
There is currently only support for move rows in cursor (as that is the cursoring syntax primarily used by the postgres odbc driver)
We can implement support for move backward (and other direction options), but this will not in general enable updatable cursors over teiid pg/odbc - there is a lot of pg internals that the pg driver utilizes to implement updatable cursors, so it's a complex feature for us to support.
> TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" on openquery update command
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-3904
> URL: https://issues.jboss.org/browse/TEIID-3904
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> Getting an error when attempting to update an Oracle Table that was virtualized in JDV.
> Here's the query
> update A
> set do_not_use = 1
> FROM OPENQUERY(HSI, 'SELECT * FROM hsi_DW_ebl.hsi_tm_pd where do_not_use is null') A
> where do_not_use is null;
> {code}
> [Server:cdtssoa126d-jdv-one] 21:14:35,311 WARN [org.teiid.ODBC] (Worker975_QueryProcessorQueue8734224) TEIID40020 Error occurred: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" at line 1, column 1.
> [Server:cdtssoa126d-jdv-one] Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1001) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]move[*] backward 5831" at line 1, column 1.
> [Server:cdtssoa126d-jdv-one] Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:164) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:140) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:279) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:363) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
> [Server:cdtssoa126d-jdv-one] ... 8 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3905) ODBC openquery permission issues when insert oracle date field
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3905?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3905:
---------------------------------------
OPENQUERY looks to require updatable cursors, which are not supported.
> ODBC openquery permission issues when insert oracle date field
> --------------------------------------------------------------
>
> Key: TEIID-3905
> URL: https://issues.jboss.org/browse/TEIID-3905
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Priority: Critical
>
> Getting an error when attempting to insert a new row into an virtualized Oracle Table in JDV.
> Here's the query
> INSERT INTO OPENQUERY(testb, 'SELECT * FROM TestVBL.HSI_AGGR_PROC_LK')
> VALUES ('TEST 1:18am', cast (getdate() as date))
> {code}
> OLE DB provider "MSDASQL" for linked server "testb" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
> Msg 7344, Level 16, State 1, Line 1
> The OLE DB provider "MSDASQL" for linked server "testb" could not INSERT INTO table "[MSDASQL]" because of column "LK_DT". The user did not have permission to write to the column.
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months