[JBoss JIRA] (TEIID-2271) Timing issue when processing data from an XML stream
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2271?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-2271:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=969257
> Timing issue when processing data from an XML stream
> ----------------------------------------------------
>
> Key: TEIID-2271
> URL: https://issues.jboss.org/browse/TEIID-2271
> Project: Teiid
> Issue Type: Bug
> Components: XML Connector
> Affects Versions: 8.2
> Reporter: Paul Richardson
> Assignee: Steven Hawkins
> Labels: 8.4CR2
> Fix For: 8.4
>
> Attachments: server.log
>
>
> Running a preview on an XML datasource causes a freezing of the gui. The main thread is stuck trying {{SocketInputStream.socketRead0}}, which never returns.
> The jboss log indicates a BlockedException has occurred and only when designer is forcibly terminated does the input stream read get cancelled.
> Discussions over the log indicate ...
> '... a timing issue where the asynch processing thread notifies after the processing thread has been detached and there's no other action that restarts the plan'
> Server log snippet attached.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2518) Delete statement with having UDF functions in its inline view is giving issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2518?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2518.
-----------------------------------
Resolution: Done
Addressed with proper detection of non-pushable subqueries. An enhancement would be needed for this and similar situations involving non-correlated non-scalar subqueries such that we could evaluate them and push the resulting operation down - however this is slightly complex as unless we have marked the need for a transaction, we'd be limited to a single update/batched update and due to criteria restrictions the result may span several source queries.
> Delete statement with having UDF functions in its inline view is giving issues
> ------------------------------------------------------------------------------
>
> Key: TEIID-2518
> URL: https://issues.jboss.org/browse/TEIID-2518
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.1
> Reporter: Rajasekhar Kota
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.4
>
> Attachments: DeleteWithInlineQuery.java, ErrorMessage.txt, TeiidUDFExecutionFactory.java
>
>
> Delete queries having UDF function in it's inline view is giving issues.
> Please find the attached test cases to reproduce the issue.
> Here is the problematic query and where primary_key is an UDF function.
> delete from testSchema.tableA where policyfkeyxml not in (select primary_key('testSchema.tableB','policyID',policyID) as expr from testSchema.tableB)
> Here is the exception that we are getting when we run above query from a test case.
> WARNING: Connector worker process failed for atomic-request=tmG/kv17VS0S.0.0.0
> org.teiid.translator.jdbc.JDBCExecutionException: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:211)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:71)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:290)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:257)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:425)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:270)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:279)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:386)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:131)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:129)
> at $Proxy11.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:506)
> at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:334)
> at com.ca.chorus.teiid.customfunctions.DeleteWithInlineQuery.testFailingInlineViewInDeleteQuery(DeleteWithInlineQuery.java:130)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
> at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
> at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
> at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
> at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
> Caused by: org.h2.jdbc.JdbcSQLException: Function "PRIMARY_KEY" not found; SQL statement:
> DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB") [90022-168]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
> at org.h2.message.DbException.get(DbException.java:169)
> at org.h2.message.DbException.get(DbException.java:146)
> at org.h2.command.Parser.readJavaFunction(Parser.java:2122)
> at org.h2.command.Parser.readFunction(Parser.java:2174)
> at org.h2.command.Parser.readTerm(Parser.java:2476)
> at org.h2.command.Parser.readFactor(Parser.java:2046)
> at org.h2.command.Parser.readSum(Parser.java:2033)
> at org.h2.command.Parser.readConcat(Parser.java:2006)
> at org.h2.command.Parser.readCondition(Parser.java:1871)
> at org.h2.command.Parser.readAnd(Parser.java:1852)
> at org.h2.command.Parser.readExpression(Parser.java:1844)
> at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1757)
> at org.h2.command.Parser.parseSelectSimple(Parser.java:1789)
> at org.h2.command.Parser.parseSelectSub(Parser.java:1684)
> at org.h2.command.Parser.parseSelectUnion(Parser.java:1527)
> at org.h2.command.Parser.parseSelect(Parser.java:1515)
> at org.h2.command.Parser.readCondition(Parser.java:1921)
> at org.h2.command.Parser.readAnd(Parser.java:1852)
> at org.h2.command.Parser.readExpression(Parser.java:1844)
> at org.h2.command.Parser.parseDelete(Parser.java:738)
> at org.h2.command.Parser.parsePrepared(Parser.java:336)
> at org.h2.command.Parser.parse(Parser.java:279)
> at org.h2.command.Parser.parse(Parser.java:251)
> at org.h2.command.Parser.prepareCommand(Parser.java:217)
> at org.h2.engine.Session.prepareLocal(Session.java:415)
> at org.h2.engine.Session.prepareCommand(Session.java:364)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
> at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
> at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:264)
> at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:181)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:168)
> ... 55 more
> May 28, 2013 7:14:51 PM org.teiid.logging.JavaLogger log
> WARNING: TEIID30020 Processing exception 'TEIID30504 h2Translator: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]' for request tmG/kv17VS0S.0. Exception type org.teiid.core.TeiidProcessingException thrown from org.h2.message.DbException.getJdbcSQLException(DbException.java:329). Enable more detailed logging to see the entire stacktrace.
> org.teiid.jdbc.TeiidSQLException: TEIID30504 h2Translator: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:656)
> at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:512)
> at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:508)
> at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:334)
> at com.ca.chorus.teiid.customfunctions.DeleteWithInlineQuery.testFailingInlineViewInDeleteQuery(DeleteWithInlineQuery.java:130)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
> at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
> at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
> at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
> at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30504 h2Translator: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:502)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:289)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:279)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:386)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:131)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:129)
> at $Proxy11.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:506)
> ... 26 more
> Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:211)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:71)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:290)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:257)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:425)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:270)
> ... 50 more
> Caused by: org.h2.jdbc.JdbcSQLException: Function "PRIMARY_KEY" not found; SQL statement:
> DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB") [90022-168]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
> at org.h2.message.DbException.get(DbException.java:169)
> at org.h2.message.DbException.get(DbException.java:146)
> at org.h2.command.Parser.readJavaFunction(Parser.java:2122)
> at org.h2.command.Parser.readFunction(Parser.java:2174)
> at org.h2.command.Parser.readTerm(Parser.java:2476)
> at org.h2.command.Parser.readFactor(Parser.java:2046)
> at org.h2.command.Parser.readSum(Parser.java:2033)
> at org.h2.command.Parser.readConcat(Parser.java:2006)
> at org.h2.command.Parser.readCondition(Parser.java:1871)
> at org.h2.command.Parser.readAnd(Parser.java:1852)
> at org.h2.command.Parser.readExpression(Parser.java:1844)
> at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1757)
> at org.h2.command.Parser.parseSelectSimple(Parser.java:1789)
> at org.h2.command.Parser.parseSelectSub(Parser.java:1684)
> at org.h2.command.Parser.parseSelectUnion(Parser.java:1527)
> at org.h2.command.Parser.parseSelect(Parser.java:1515)
> at org.h2.command.Parser.readCondition(Parser.java:1921)
> at org.h2.command.Parser.readAnd(Parser.java:1852)
> at org.h2.command.Parser.readExpression(Parser.java:1844)
> at org.h2.command.Parser.parseDelete(Parser.java:738)
> at org.h2.command.Parser.parsePrepared(Parser.java:336)
> at org.h2.command.Parser.parse(Parser.java:279)
> at org.h2.command.Parser.parse(Parser.java:251)
> at org.h2.command.Parser.prepareCommand(Parser.java:217)
> at org.h2.engine.Session.prepareLocal(Session.java:415)
> at org.h2.engine.Session.prepareCommand(Session.java:364)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
> at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
> at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:264)
> at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:181)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:168)
> ... 55 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2518) Delete statement with having UDF functions in its inline view is giving issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2518?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2518:
----------------------------------
Fix Version/s: 8.4
Looking at this a bit more. The logic is functioning correctly in the pushdown allowed case in which it's entirely expected for you to see the exception that you are getting from h2. However the logic is not appropriately detecting/compensating if the function is marked as pushdown not allowed. In this particular case even after this is addressed you will still receive an exception as testSchema.tableA does not have a unique key defined in the metadata.
> Delete statement with having UDF functions in its inline view is giving issues
> ------------------------------------------------------------------------------
>
> Key: TEIID-2518
> URL: https://issues.jboss.org/browse/TEIID-2518
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.1
> Reporter: Rajasekhar Kota
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.4
>
> Attachments: DeleteWithInlineQuery.java, ErrorMessage.txt, TeiidUDFExecutionFactory.java
>
>
> Delete queries having UDF function in it's inline view is giving issues.
> Please find the attached test cases to reproduce the issue.
> Here is the problematic query and where primary_key is an UDF function.
> delete from testSchema.tableA where policyfkeyxml not in (select primary_key('testSchema.tableB','policyID',policyID) as expr from testSchema.tableB)
> Here is the exception that we are getting when we run above query from a test case.
> WARNING: Connector worker process failed for atomic-request=tmG/kv17VS0S.0.0.0
> org.teiid.translator.jdbc.JDBCExecutionException: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:211)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:71)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:290)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:257)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:425)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:270)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:279)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:386)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:131)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:129)
> at $Proxy11.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:506)
> at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:334)
> at com.ca.chorus.teiid.customfunctions.DeleteWithInlineQuery.testFailingInlineViewInDeleteQuery(DeleteWithInlineQuery.java:130)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
> at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
> at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
> at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
> at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
> Caused by: org.h2.jdbc.JdbcSQLException: Function "PRIMARY_KEY" not found; SQL statement:
> DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB") [90022-168]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
> at org.h2.message.DbException.get(DbException.java:169)
> at org.h2.message.DbException.get(DbException.java:146)
> at org.h2.command.Parser.readJavaFunction(Parser.java:2122)
> at org.h2.command.Parser.readFunction(Parser.java:2174)
> at org.h2.command.Parser.readTerm(Parser.java:2476)
> at org.h2.command.Parser.readFactor(Parser.java:2046)
> at org.h2.command.Parser.readSum(Parser.java:2033)
> at org.h2.command.Parser.readConcat(Parser.java:2006)
> at org.h2.command.Parser.readCondition(Parser.java:1871)
> at org.h2.command.Parser.readAnd(Parser.java:1852)
> at org.h2.command.Parser.readExpression(Parser.java:1844)
> at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1757)
> at org.h2.command.Parser.parseSelectSimple(Parser.java:1789)
> at org.h2.command.Parser.parseSelectSub(Parser.java:1684)
> at org.h2.command.Parser.parseSelectUnion(Parser.java:1527)
> at org.h2.command.Parser.parseSelect(Parser.java:1515)
> at org.h2.command.Parser.readCondition(Parser.java:1921)
> at org.h2.command.Parser.readAnd(Parser.java:1852)
> at org.h2.command.Parser.readExpression(Parser.java:1844)
> at org.h2.command.Parser.parseDelete(Parser.java:738)
> at org.h2.command.Parser.parsePrepared(Parser.java:336)
> at org.h2.command.Parser.parse(Parser.java:279)
> at org.h2.command.Parser.parse(Parser.java:251)
> at org.h2.command.Parser.prepareCommand(Parser.java:217)
> at org.h2.engine.Session.prepareLocal(Session.java:415)
> at org.h2.engine.Session.prepareCommand(Session.java:364)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
> at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
> at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:264)
> at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:181)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:168)
> ... 55 more
> May 28, 2013 7:14:51 PM org.teiid.logging.JavaLogger log
> WARNING: TEIID30020 Processing exception 'TEIID30504 h2Translator: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]' for request tmG/kv17VS0S.0. Exception type org.teiid.core.TeiidProcessingException thrown from org.h2.message.DbException.getJdbcSQLException(DbException.java:329). Enable more detailed logging to see the entire stacktrace.
> org.teiid.jdbc.TeiidSQLException: TEIID30504 h2Translator: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:656)
> at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:512)
> at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:508)
> at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:334)
> at com.ca.chorus.teiid.customfunctions.DeleteWithInlineQuery.testFailingInlineViewInDeleteQuery(DeleteWithInlineQuery.java:130)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
> at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
> at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
> at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
> at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
> at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
> at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
> Caused by: org.teiid.core.TeiidProcessingException: TEIID30504 h2Translator: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:502)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:289)
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:279)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:148)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:386)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:131)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:129)
> at $Proxy11.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:506)
> ... 26 more
> Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 90022 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB")]
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:211)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.execute(JDBCUpdateExecution.java:71)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:290)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:257)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:425)
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:270)
> ... 50 more
> Caused by: org.h2.jdbc.JdbcSQLException: Function "PRIMARY_KEY" not found; SQL statement:
> DELETE FROM "MEM"."TESTSCHEMA"."TABLEA" WHERE "MEM"."TESTSCHEMA"."TABLEA"."POLICYFKEYXML" NOT IN (SELECT primary_key('testSchema.tableB', 'policyID', "MEM"."TESTSCHEMA"."TABLEB"."POLICYID") AS expr FROM "MEM"."TESTSCHEMA"."TABLEB") [90022-168]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
> at org.h2.message.DbException.get(DbException.java:169)
> at org.h2.message.DbException.get(DbException.java:146)
> at org.h2.command.Parser.readJavaFunction(Parser.java:2122)
> at org.h2.command.Parser.readFunction(Parser.java:2174)
> at org.h2.command.Parser.readTerm(Parser.java:2476)
> at org.h2.command.Parser.readFactor(Parser.java:2046)
> at org.h2.command.Parser.readSum(Parser.java:2033)
> at org.h2.command.Parser.readConcat(Parser.java:2006)
> at org.h2.command.Parser.readCondition(Parser.java:1871)
> at org.h2.command.Parser.readAnd(Parser.java:1852)
> at org.h2.command.Parser.readExpression(Parser.java:1844)
> at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1757)
> at org.h2.command.Parser.parseSelectSimple(Parser.java:1789)
> at org.h2.command.Parser.parseSelectSub(Parser.java:1684)
> at org.h2.command.Parser.parseSelectUnion(Parser.java:1527)
> at org.h2.command.Parser.parseSelect(Parser.java:1515)
> at org.h2.command.Parser.readCondition(Parser.java:1921)
> at org.h2.command.Parser.readAnd(Parser.java:1852)
> at org.h2.command.Parser.readExpression(Parser.java:1844)
> at org.h2.command.Parser.parseDelete(Parser.java:738)
> at org.h2.command.Parser.parsePrepared(Parser.java:336)
> at org.h2.command.Parser.parse(Parser.java:279)
> at org.h2.command.Parser.parse(Parser.java:251)
> at org.h2.command.Parser.prepareCommand(Parser.java:217)
> at org.h2.engine.Session.prepareLocal(Session.java:415)
> at org.h2.engine.Session.prepareCommand(Session.java:364)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
> at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
> at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:264)
> at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:181)
> at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:168)
> ... 55 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2519) Odata Table Query Not Workng
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2519:
-------------------------------------
Still no good, I do not see any tables in your model at all. Where are other system models like System and PG show up fine. If you want you can issue
http://localhost:8080/odata/portfolio.1/SYS.Tables
and see results. I still think there is an issue with your source. Again, use SquirreL to log into Teiid VDB and see if you have tables under "schoolsMySQL" model. Can you issue a "select * from {table}" from SquirreL?
if all else fails deploy this VDB
{code:title=loopy-vdb.xml}
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="Loopy" version="1">
<model name="MarketData">
<source name="connector" translator-name="loopback" />
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE G1 (e1 string, e2 integer);
CREATE FOREIGN TABLE G2 (e1 string, e2 integer) OPTIONS (UPDATABLE 'true');
]]> </metadata>
</model>
</vdb>
{code}
and then go to
{code}
http://localhost:8080/odata/loopy.1/MarketData.G1
{code}
did that work?
> Odata Table Query Not Workng
> ----------------------------
>
> Key: TEIID-2519
> URL: https://issues.jboss.org/browse/TEIID-2519
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.3
> Environment: CentOS, JBOSS AS 7.1.1, Teiid 8.3.
> Reporter: devin pinkston
> Assignee: Ramesh Reddy
> Priority: Minor
> Labels: odata,, service,, web
> Fix For: 8.4
>
> Attachments: metadata.txt, portfolio-vdb.xml, portfolio-vdb.xml
>
>
> When trying to query a table through Odata, a error is diplayed: EdmEntitySet refinedSalariesModel.refinedSalaries is not found
> When issuing the query:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel.refinedSalaries
> We have also tried using:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries
> When issuing the second query, this error is thrown:
> <error><code/><message lang="en-US">Could not find resource for relative : /refinedSalariesModel/refinedSalaries of full path: http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries</message></error>
> We can successfully display the metadata and see the details of the VDB by using:
> http://localhost:8080/odata/Portfolio.1/$metadata
> Please let me know if you need any more information
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2519) Odata Table Query Not Workng
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin... ]
Ramesh Reddy edited comment on TEIID-2519 at 5/30/13 2:20 PM:
--------------------------------------------------------------
Still no good, I do not see any tables in your model at all. Where are other system models like System and PG show up fine. If you want you can issue
http://localhost:8080/odata/portfolio.1/SYS.Tables
and see results. I still think there is an issue with your source. Again, use SquirreL to log into Teiid VDB and see if you have tables under "schoolsMySQL" model. Can you issue a "select * from <table>" from SquirreL?
if all else fails deploy this VDB
{code:title=loopy-vdb.xml}
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="Loopy" version="1">
<model name="MarketData">
<source name="connector" translator-name="loopback" />
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE G1 (e1 string, e2 integer);
CREATE FOREIGN TABLE G2 (e1 string, e2 integer) OPTIONS (UPDATABLE 'true');
]]> </metadata>
</model>
</vdb>
{code}
and then go to
{code}
http://localhost:8080/odata/loopy.1/MarketData.G1
{code}
did that work?
was (Author: rareddy):
Still no good, I do not see any tables in your model at all. Where are other system models like System and PG show up fine. If you want you can issue
http://localhost:8080/odata/portfolio.1/SYS.Tables
and see results. I still think there is an issue with your source. Again, use SquirreL to log into Teiid VDB and see if you have tables under "schoolsMySQL" model. Can you issue a "select * from {table}" from SquirreL?
if all else fails deploy this VDB
{code:title=loopy-vdb.xml}
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="Loopy" version="1">
<model name="MarketData">
<source name="connector" translator-name="loopback" />
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE G1 (e1 string, e2 integer);
CREATE FOREIGN TABLE G2 (e1 string, e2 integer) OPTIONS (UPDATABLE 'true');
]]> </metadata>
</model>
</vdb>
{code}
and then go to
{code}
http://localhost:8080/odata/loopy.1/MarketData.G1
{code}
did that work?
> Odata Table Query Not Workng
> ----------------------------
>
> Key: TEIID-2519
> URL: https://issues.jboss.org/browse/TEIID-2519
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.3
> Environment: CentOS, JBOSS AS 7.1.1, Teiid 8.3.
> Reporter: devin pinkston
> Assignee: Ramesh Reddy
> Priority: Minor
> Labels: odata,, service,, web
> Fix For: 8.4
>
> Attachments: metadata.txt, portfolio-vdb.xml, portfolio-vdb.xml
>
>
> When trying to query a table through Odata, a error is diplayed: EdmEntitySet refinedSalariesModel.refinedSalaries is not found
> When issuing the query:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel.refinedSalaries
> We have also tried using:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries
> When issuing the second query, this error is thrown:
> <error><code/><message lang="en-US">Could not find resource for relative : /refinedSalariesModel/refinedSalaries of full path: http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries</message></error>
> We can successfully display the metadata and see the details of the VDB by using:
> http://localhost:8080/odata/Portfolio.1/$metadata
> Please let me know if you need any more information
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2519) Odata Table Query Not Workng
by devin pinkston (JIRA)
[ https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin... ]
devin pinkston updated TEIID-2519:
----------------------------------
Attachment: portfolio-vdb.xml
I attached a new VDB with just a mysql data source which includes a source model "schoolsMySQL" The result of my metadata:
<edmx:Edmx Version="1.0"><edmx:DataServices m:DataServiceVersion="2.0"><Schema Namespace="schoolsMySQL"><EntityContainer Name="schoolsMySQL" m:IsDefaultEntityContainer="false"/></Schema><Schema Namespace="SYS"><EntityType Name="Columns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="false"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DataType" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="Scale" Type="Edm.Int32" Nullable="false"/><Property Name="Length" Type="Edm.Int32" Nullable="false"/><Property Name="IsLengthFixed" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsSelect" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsUpdates" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCaseSensitive" Type="Edm.Boolean" Nullable="false"/><Property Name="IsSigned" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCurrency" Type="Edm.Boolean" Nullable="false"/><Property Name="IsAutoIncremented" Type="Edm.Boolean" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="MinRange" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="MaxRange" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="DistinctCount" Type="Edm.Int32" Nullable="true"/><Property Name="NullCount" Type="Edm.Int32" Nullable="true"/><Property Name="SearchType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="Format" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DefaultValue" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="JavaClass" Type="Edm.String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="CharOctetLength" Type="Edm.Int32" Nullable="true"/><Property Name="Radix" Type="Edm.Int32" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.Columns_FK0" FromRole="Columns" ToRole="Tables"/><NavigationProperty Name="DataTypes" Relationship="SYS.Columns_FK1" FromRole="Columns" ToRole="DataTypes"/></EntityType><EntityType Name="DataTypes"><Key><PropertyRef Name="Name"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="IsStandard" Type="Edm.Boolean" Nullable="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="true"/><Property Name="TypeName" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="JavaClass" Type="Edm.String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true"/><Property Name="Scale" Type="Edm.Int32" Nullable="true"/><Property Name="TypeLength" Type="Edm.Int32" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="IsSigned" Type="Edm.Boolean" Nullable="false"/><Property Name="IsAutoIncremented" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCaseSensitive" Type="Edm.Boolean" Nullable="false"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="Radix" Type="Edm.Int32" Nullable="true"/><Property Name="SearchType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="RuntimeType" Type="Edm.String" Nullable="true" MaxLength="64" FixedLength="false" Unicode="true"/><Property Name="BaseType" Type="Edm.String" Nullable="true" MaxLength="64" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Columns" Relationship="SYS.Columns_FK1" FromRole="DataTypes" ToRole="Columns"/><NavigationProperty Name="ProcedureParams" Relationship="SYS.ProcedureParams_FK1" FromRole="DataTypes" ToRole="ProcedureParams"/></EntityType><EntityType Name="KeyColumns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="2048" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="KeyName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="KeyType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="RefKeyUID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.KeyColumns_FK0" FromRole="KeyColumns" ToRole="Tables"/></EntityType><EntityType Name="Keys"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="2048" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="IsIndexed" Type="Edm.Boolean" Nullable="false"/><Property Name="RefKeyUID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.Keys_FK0" FromRole="Keys" ToRole="Tables"/></EntityType><EntityType Name="ProcedureParams"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="ProcedureName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="ProcedureName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DataType" Type="Edm.String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="false"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="Optional" Type="Edm.Boolean" Nullable="false"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="TypeLength" Type="Edm.Int32" Nullable="false"/><Property Name="Scale" Type="Edm.Int32" Nullable="false"/><Property Name="Radix" Type="Edm.Int32" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Procedures" Relationship="SYS.ProcedureParams_FK0" FromRole="ProcedureParams" ToRole="Procedures"/><NavigationProperty Name="DataTypes" Relationship="SYS.ProcedureParams_FK1" FromRole="ProcedureParams" ToRole="DataTypes"/></EntityType><EntityType Name="Procedures"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="ReturnsResults" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="ProcedureParams" Relationship="SYS.ProcedureParams_FK0" FromRole="Procedures" ToRole="ProcedureParams"/><NavigationProperty Name="Schemas" Relationship="SYS.Procedures_FK0" FromRole="Procedures" ToRole="Schemas"/></EntityType><EntityType Name="Properties"><Key><PropertyRef Name="UID"/><PropertyRef Name="Name"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Value" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><Property Name="ClobValue" Type="Edm.Binary" Nullable="true"/></EntityType><EntityType Name="Schemas"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="PrimaryMetamodelURI" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Procedures" Relationship="SYS.Procedures_FK0" FromRole="Schemas" ToRole="Procedures"/><NavigationProperty Name="Tables" Relationship="SYS.Tables_FK0" FromRole="Schemas" ToRole="Tables"/></EntityType><EntityType Name="Tables"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsUpdates" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="false"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsSystem" Type="Edm.Boolean" Nullable="true"/><Property Name="IsMaterialized" Type="Edm.Boolean" Nullable="false"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Columns" Relationship="SYS.Columns_FK0" FromRole="Tables" ToRole="Columns"/><NavigationProperty Name="KeyColumns" Relationship="SYS.KeyColumns_FK0" FromRole="Tables" ToRole="KeyColumns"/><NavigationProperty Name="Keys" Relationship="SYS.Keys_FK0" FromRole="Tables" ToRole="Keys"/><NavigationProperty Name="Schemas" Relationship="SYS.Tables_FK0" FromRole="Tables" ToRole="Schemas"/></EntityType><EntityType Name="VirtualDatabases"><Key><PropertyRef Name="Name"/><PropertyRef Name="Version"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Version" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/></EntityType><ComplexType Name="getXMLSchemas_RSParam"><Property Name="schema" Type="Edm.Binary" Nullable="true"/></ComplexType><Association Name="Columns_FK0"><End Type="SYS.Columns" Multiplicity="*" Role="Columns"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Columns"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="Columns_FK1"><End Type="SYS.Columns" Multiplicity="*" Role="Columns"/><End Type="SYS.DataTypes" Multiplicity="0..1" Role="DataTypes"/><ReferentialConstraint><Principal Role="DataTypes"><PropertyRef Name="Name"/></Principal><Dependent Role="Columns"><PropertyRef Name="DataType"/></Dependent></ReferentialConstraint></Association><Association Name="KeyColumns_FK0"><End Type="SYS.KeyColumns" Multiplicity="*" Role="KeyColumns"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="KeyColumns"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="Keys_FK0"><End Type="SYS.Keys" Multiplicity="*" Role="Keys"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Keys"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="ProcedureParams_FK0"><End Type="SYS.ProcedureParams" Multiplicity="*" Role="ProcedureParams"/><End Type="SYS.Procedures" Multiplicity="0..1" Role="Procedures"/><ReferentialConstraint><Principal Role="Procedures"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="ProcedureParams"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="ProcedureName"/></Dependent></ReferentialConstraint></Association><Association Name="ProcedureParams_FK1"><End Type="SYS.ProcedureParams" Multiplicity="*" Role="ProcedureParams"/><End Type="SYS.DataTypes" Multiplicity="0..1" Role="DataTypes"/><ReferentialConstraint><Principal Role="DataTypes"><PropertyRef Name="Name"/></Principal><Dependent Role="ProcedureParams"><PropertyRef Name="DataType"/></Dependent></ReferentialConstraint></Association><Association Name="Procedures_FK0"><End Type="SYS.Procedures" Multiplicity="*" Role="Procedures"/><End Type="SYS.Schemas" Multiplicity="0..1" Role="Schemas"/><ReferentialConstraint><Principal Role="Schemas"><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Procedures"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/></Dependent></ReferentialConstraint></Association><Association Name="Tables_FK0"><End Type="SYS.Tables" Multiplicity="*" Role="Tables"/><End Type="SYS.Schemas" Multiplicity="0..1" Role="Schemas"/><ReferentialConstraint><Principal Role="Schemas"><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/></Dependent></ReferentialConstraint></Association><EntityContainer Name="SYS" m:IsDefaultEntityContainer="false"><EntitySet Name="Columns" EntityType="SYS.Columns"/><EntitySet Name="DataTypes" EntityType="SYS.DataTypes"/><EntitySet Name="KeyColumns" EntityType="SYS.KeyColumns"/><EntitySet Name="Keys" EntityType="SYS.Keys"/><EntitySet Name="ProcedureParams" EntityType="SYS.ProcedureParams"/><EntitySet Name="Procedures" EntityType="SYS.Procedures"/><EntitySet Name="Properties" EntityType="SYS.Properties"/><EntitySet Name="Schemas" EntityType="SYS.Schemas"/><EntitySet Name="Tables" EntityType="SYS.Tables"/><EntitySet Name="VirtualDatabases" EntityType="SYS.VirtualDatabases"/><AssociationSet Name="Columns_FK0" Association="SYS.Columns_FK0"><End EntitySet="Columns" Role="Columns"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="Columns_FK1" Association="SYS.Columns_FK1"><End EntitySet="Columns" Role="Columns"/><End EntitySet="DataTypes" Role="DataTypes"/></AssociationSet><AssociationSet Name="KeyColumns_FK0" Association="SYS.KeyColumns_FK0"><End EntitySet="KeyColumns" Role="KeyColumns"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="Keys_FK0" Association="SYS.Keys_FK0"><End EntitySet="Keys" Role="Keys"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="ProcedureParams_FK0" Association="SYS.ProcedureParams_FK0"><End EntitySet="ProcedureParams" Role="ProcedureParams"/><End EntitySet="Procedures" Role="Procedures"/></AssociationSet><AssociationSet Name="ProcedureParams_FK1" Association="SYS.ProcedureParams_FK1"><End EntitySet="ProcedureParams" Role="ProcedureParams"/><End EntitySet="DataTypes" Role="DataTypes"/></AssociationSet><AssociationSet Name="Procedures_FK0" Association="SYS.Procedures_FK0"><End EntitySet="Procedures" Role="Procedures"/><End EntitySet="Schemas" Role="Schemas"/></AssociationSet><AssociationSet Name="Tables_FK0" Association="SYS.Tables_FK0"><End EntitySet="Tables" Role="Tables"/><End EntitySet="Schemas" Role="Schemas"/></AssociationSet><FunctionImport Name="getXMLSchemas" ReturnType="Collection(SYS.getXMLSchemas_RSParam)" m:HttpMethod="GET"><Parameter Name="document" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport></EntityContainer></Schema><Schema Namespace="SYSADMIN"><EntityType Name="MatViews"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TargetSchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TargetName" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Valid" Type="Edm.Boolean" Nullable="true"/><Property Name="LoadState" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Updated" Type="Edm.DateTime" Nullable="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="true"/></EntityType><EntityType Name="VDBResources"><Key><PropertyRef Name="resourcePath"/></Key><Property Name="resourcePath" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="contents" Type="Edm.Binary" Nullable="true"/></EntityType><EntityContainer Name="SYSADMIN" m:IsDefaultEntityContainer="false"><EntitySet Name="MatViews" EntityType="SYSADMIN.MatViews"/><EntitySet Name="VDBResources" EntityType="SYSADMIN.VDBResources"/><FunctionImport Name="isLoggable" m:HttpMethod="POST"><Parameter Name="loggable" Type="Edm.Boolean" Nullable="false"/><Parameter Name="level" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="context" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="logMsg" m:HttpMethod="POST"><Parameter Name="logged" Type="Edm.Boolean" Nullable="false"/><Parameter Name="level" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="context" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="msg" Type="Edm.Binary" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="refreshMatView" m:HttpMethod="POST"><Parameter Name="RowsUpdated" Type="Edm.Int32" Nullable="false"/><Parameter Name="ViewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Invalidate" Type="Edm.Boolean" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="refreshMatViewRow" m:HttpMethod="POST"><Parameter Name="RowsUpdated" Type="Edm.Int32" Nullable="false"/><Parameter Name="ViewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Key" Type="Edm.Binary" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="setColumnStats" m:HttpMethod="POST"><Parameter Name="tableName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="columnName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="distinctCount" Type="Edm.Int32" Mode="In" Nullable="true"/><Parameter Name="nullCount" Type="Edm.Int32" Mode="In" Nullable="true"/><Parameter Name="max" Type="Edm.String" Mode="In" Nullable="true"/><Parameter Name="min" Type="Edm.String" Mode="In" Nullable="true"/></FunctionImport><FunctionImport Name="setProperty" m:HttpMethod="POST"><Parameter Name="OldValue" Type="Edm.Binary" Nullable="false"/><Parameter Name="UID" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Name" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Value" Type="Edm.Binary" Mode="In" Nullable="true"/></FunctionImport><FunctionImport Name="setTableStats" m:HttpMethod="POST"><Parameter Name="tableName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="cardinality" Type="Edm.Int32" Mode="In" Nullable="false"/></FunctionImport></EntityContainer></Schema><Schema Namespace="pg_catalog"><EntityType Name="matpg_datatype"><Key><PropertyRef Name="oid"/><PropertyRef Name="name"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="typname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="name" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="uid" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="typlen" Type="Edm.Int16" Nullable="true"/></EntityType><EntityType Name="matpg_relatt"><Key><PropertyRef Name="attname"/><PropertyRef Name="relname"/><PropertyRef Name="nspname"/></Key><Property Name="attrelid" Type="Edm.Int32" Nullable="true"/><Property Name="attnum" Type="Edm.Int16" Nullable="true"/><Property Name="attname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="relname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="nspname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="autoinc" Type="Edm.Boolean" Nullable="true"/><Property Name="typoid" Type="Edm.Int32" Nullable="true"/></EntityType><EntityType Name="pg_attribute"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="attrelid" Type="Edm.Int32" Nullable="true"/><Property Name="attname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="atttypid" Type="Edm.Int32" Nullable="true"/><Property Name="attlen" Type="Edm.Int16" Nullable="true"/><Property Name="attnum" Type="Edm.Int16" Nullable="true"/><Property Name="atttypmod" Type="Edm.Int32" Nullable="true"/><Property Name="attnotnull" Type="Edm.Boolean" Nullable="true"/><Property Name="attisdropped" Type="Edm.Boolean" Nullable="true"/><Property Name="atthasdef" Type="Edm.Boolean" Nullable="true"/></EntityType><EntityType Name="pg_class"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="relname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="relnamespace" Type="Edm.Int32" Nullable="true"/><Property Name="relkind" Type="Edm.String" Nullable="true"/><Property Name="relam" Type="Edm.Int32" Nullable="true"/><Property Name="reltuples" Type="Edm.Single" Nullable="true"/><Property Name="relpages" Type="Edm.Int32" Nullable="true"/><Property Name="relhasrules" Type="Edm.Boolean" Nullable="true"/><Property Name="relhasoids" Type="Edm.Boolean" Nullable="true"/></EntityType><EntityType Name="pg_index"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="indexrelid" Type="Edm.Int32" Nullable="true"/><Property Name="indrelid" Type="Edm.Int32" Nullable="true"/><Property Name="indnatts" Type="Edm.Int16" Nullable="true"/><Property Name="indisclustered" Type="Edm.Boolean" Nullable="true"/><Property Name="indisunique" Type="Edm.Boolean" Nullable="true"/><Property Name="indisprimary" Type="Edm.Boolean" Nullable="true"/><Property Name="indexprs" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="indkey" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/></EntityType><EntityType Name="pg_proc"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="proname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="proretset" Type="Edm.Boolean" Nullable="true"/><Property Name="prorettype" Type="Edm.Int32" Nullable="true"/><Property Name="pronargs" Type="Edm.Int16" Nullable="true"/><Property Name="proargtypes" Type="Edm.Binary" Nullable="true"/><Property Name="proargnames" Type="Edm.Binary" Nullable="true"/><Property Name="proargmodes" Type="Edm.Binary" Nullable="true"/><Property Name="proallargtypes" Type="Edm.Binary" Nullable="true"/><Property Name="pronamespace" Type="Edm.Int32" Nullable="true"/></EntityType><EntityContainer Name="pg_catalog" m:IsDefaultEntityContainer="false"><EntitySet Name="matpg_datatype" EntityType="pg_catalog.matpg_datatype"/><EntitySet Name="matpg_relatt" EntityType="pg_catalog.matpg_relatt"/><EntitySet Name="pg_attribute" EntityType="pg_catalog.pg_attribute"/><EntitySet Name="pg_class" EntityType="pg_catalog.pg_class"/><EntitySet Name="pg_index" EntityType="pg_catalog.pg_index"/><EntitySet Name="pg_proc" EntityType="pg_catalog.pg_proc"/></EntityContainer></Schema></edmx:DataServices></edmx:Edmx>
> Odata Table Query Not Workng
> ----------------------------
>
> Key: TEIID-2519
> URL: https://issues.jboss.org/browse/TEIID-2519
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.3
> Environment: CentOS, JBOSS AS 7.1.1, Teiid 8.3.
> Reporter: devin pinkston
> Assignee: Ramesh Reddy
> Priority: Minor
> Labels: odata,, service,, web
> Fix For: 8.4
>
> Attachments: metadata.txt, portfolio-vdb.xml, portfolio-vdb.xml
>
>
> When trying to query a table through Odata, a error is diplayed: EdmEntitySet refinedSalariesModel.refinedSalaries is not found
> When issuing the query:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel.refinedSalaries
> We have also tried using:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries
> When issuing the second query, this error is thrown:
> <error><code/><message lang="en-US">Could not find resource for relative : /refinedSalariesModel/refinedSalaries of full path: http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries</message></error>
> We can successfully display the metadata and see the details of the VDB by using:
> http://localhost:8080/odata/Portfolio.1/$metadata
> Please let me know if you need any more information
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2519) Odata Table Query Not Workng
by devin pinkston (JIRA)
[ https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin... ]
devin pinkston edited comment on TEIID-2519 at 5/30/13 1:45 PM:
----------------------------------------------------------------
I attached a new VDB with just a mysql data source which includes a source model "schoolsMySQL" The result of my metadata:
<edmx:Edmx Version="1.0"><edmx:DataServices m:DataServiceVersion="2.0"><Schema Namespace="schoolsMySQL"><EntityContainer Name="schoolsMySQL" m:IsDefaultEntityContainer="false"/></Schema><Schema Namespace="SYS"><EntityType Name="Columns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key>
was (Author: pinkstondevin):
I attached a new VDB with just a mysql data source which includes a source model "schoolsMySQL" The result of my metadata:
<edmx:Edmx Version="1.0"><edmx:DataServices m:DataServiceVersion="2.0"><Schema Namespace="schoolsMySQL"><EntityContainer Name="schoolsMySQL" m:IsDefaultEntityContainer="false"/></Schema><Schema Namespace="SYS"><EntityType Name="Columns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="false"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DataType" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="Scale" Type="Edm.Int32" Nullable="false"/><Property Name="Length" Type="Edm.Int32" Nullable="false"/><Property Name="IsLengthFixed" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsSelect" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsUpdates" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCaseSensitive" Type="Edm.Boolean" Nullable="false"/><Property Name="IsSigned" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCurrency" Type="Edm.Boolean" Nullable="false"/><Property Name="IsAutoIncremented" Type="Edm.Boolean" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="MinRange" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="MaxRange" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="DistinctCount" Type="Edm.Int32" Nullable="true"/><Property Name="NullCount" Type="Edm.Int32" Nullable="true"/><Property Name="SearchType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="Format" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DefaultValue" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="JavaClass" Type="Edm.String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="CharOctetLength" Type="Edm.Int32" Nullable="true"/><Property Name="Radix" Type="Edm.Int32" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.Columns_FK0" FromRole="Columns" ToRole="Tables"/><NavigationProperty Name="DataTypes" Relationship="SYS.Columns_FK1" FromRole="Columns" ToRole="DataTypes"/></EntityType><EntityType Name="DataTypes"><Key><PropertyRef Name="Name"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="IsStandard" Type="Edm.Boolean" Nullable="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="true"/><Property Name="TypeName" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="JavaClass" Type="Edm.String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true"/><Property Name="Scale" Type="Edm.Int32" Nullable="true"/><Property Name="TypeLength" Type="Edm.Int32" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="IsSigned" Type="Edm.Boolean" Nullable="false"/><Property Name="IsAutoIncremented" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCaseSensitive" Type="Edm.Boolean" Nullable="false"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="Radix" Type="Edm.Int32" Nullable="true"/><Property Name="SearchType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="RuntimeType" Type="Edm.String" Nullable="true" MaxLength="64" FixedLength="false" Unicode="true"/><Property Name="BaseType" Type="Edm.String" Nullable="true" MaxLength="64" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Columns" Relationship="SYS.Columns_FK1" FromRole="DataTypes" ToRole="Columns"/><NavigationProperty Name="ProcedureParams" Relationship="SYS.ProcedureParams_FK1" FromRole="DataTypes" ToRole="ProcedureParams"/></EntityType><EntityType Name="KeyColumns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="2048" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="KeyName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="KeyType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="RefKeyUID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.KeyColumns_FK0" FromRole="KeyColumns" ToRole="Tables"/></EntityType><EntityType Name="Keys"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="2048" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="IsIndexed" Type="Edm.Boolean" Nullable="false"/><Property Name="RefKeyUID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.Keys_FK0" FromRole="Keys" ToRole="Tables"/></EntityType><EntityType Name="ProcedureParams"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="ProcedureName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="ProcedureName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DataType" Type="Edm.String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="false"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="Optional" Type="Edm.Boolean" Nullable="false"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="TypeLength" Type="Edm.Int32" Nullable="false"/><Property Name="Scale" Type="Edm.Int32" Nullable="false"/><Property Name="Radix" Type="Edm.Int32" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Procedures" Relationship="SYS.ProcedureParams_FK0" FromRole="ProcedureParams" ToRole="Procedures"/><NavigationProperty Name="DataTypes" Relationship="SYS.ProcedureParams_FK1" FromRole="ProcedureParams" ToRole="DataTypes"/></EntityType><EntityType Name="Procedures"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="ReturnsResults" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="ProcedureParams" Relationship="SYS.ProcedureParams_FK0" FromRole="Procedures" ToRole="ProcedureParams"/><NavigationProperty Name="Schemas" Relationship="SYS.Procedures_FK0" FromRole="Procedures" ToRole="Schemas"/></EntityType><EntityType Name="Properties"><Key><PropertyRef Name="UID"/><PropertyRef Name="Name"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Value" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><Property Name="ClobValue" Type="Edm.Binary" Nullable="true"/></EntityType><EntityType Name="Schemas"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="PrimaryMetamodelURI" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Procedures" Relationship="SYS.Procedures_FK0" FromRole="Schemas" ToRole="Procedures"/><NavigationProperty Name="Tables" Relationship="SYS.Tables_FK0" FromRole="Schemas" ToRole="Tables"/></EntityType><EntityType Name="Tables"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsUpdates" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="false"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsSystem" Type="Edm.Boolean" Nullable="true"/><Property Name="IsMaterialized" Type="Edm.Boolean" Nullable="false"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Columns" Relationship="SYS.Columns_FK0" FromRole="Tables" ToRole="Columns"/><NavigationProperty Name="KeyColumns" Relationship="SYS.KeyColumns_FK0" FromRole="Tables" ToRole="KeyColumns"/><NavigationProperty Name="Keys" Relationship="SYS.Keys_FK0" FromRole="Tables" ToRole="Keys"/><NavigationProperty Name="Schemas" Relationship="SYS.Tables_FK0" FromRole="Tables" ToRole="Schemas"/></EntityType><EntityType Name="VirtualDatabases"><Key><PropertyRef Name="Name"/><PropertyRef Name="Version"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Version" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/></EntityType><ComplexType Name="getXMLSchemas_RSParam"><Property Name="schema" Type="Edm.Binary" Nullable="true"/></ComplexType><Association Name="Columns_FK0"><End Type="SYS.Columns" Multiplicity="*" Role="Columns"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Columns"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="Columns_FK1"><End Type="SYS.Columns" Multiplicity="*" Role="Columns"/><End Type="SYS.DataTypes" Multiplicity="0..1" Role="DataTypes"/><ReferentialConstraint><Principal Role="DataTypes"><PropertyRef Name="Name"/></Principal><Dependent Role="Columns"><PropertyRef Name="DataType"/></Dependent></ReferentialConstraint></Association><Association Name="KeyColumns_FK0"><End Type="SYS.KeyColumns" Multiplicity="*" Role="KeyColumns"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="KeyColumns"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="Keys_FK0"><End Type="SYS.Keys" Multiplicity="*" Role="Keys"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Keys"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="ProcedureParams_FK0"><End Type="SYS.ProcedureParams" Multiplicity="*" Role="ProcedureParams"/><End Type="SYS.Procedures" Multiplicity="0..1" Role="Procedures"/><ReferentialConstraint><Principal Role="Procedures"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="ProcedureParams"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="ProcedureName"/></Dependent></ReferentialConstraint></Association><Association Name="ProcedureParams_FK1"><End Type="SYS.ProcedureParams" Multiplicity="*" Role="ProcedureParams"/><End Type="SYS.DataTypes" Multiplicity="0..1" Role="DataTypes"/><ReferentialConstraint><Principal Role="DataTypes"><PropertyRef Name="Name"/></Principal><Dependent Role="ProcedureParams"><PropertyRef Name="DataType"/></Dependent></ReferentialConstraint></Association><Association Name="Procedures_FK0"><End Type="SYS.Procedures" Multiplicity="*" Role="Procedures"/><End Type="SYS.Schemas" Multiplicity="0..1" Role="Schemas"/><ReferentialConstraint><Principal Role="Schemas"><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Procedures"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/></Dependent></ReferentialConstraint></Association><Association Name="Tables_FK0"><End Type="SYS.Tables" Multiplicity="*" Role="Tables"/><End Type="SYS.Schemas" Multiplicity="0..1" Role="Schemas"/><ReferentialConstraint><Principal Role="Schemas"><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/></Dependent></ReferentialConstraint></Association><EntityContainer Name="SYS" m:IsDefaultEntityContainer="false"><EntitySet Name="Columns" EntityType="SYS.Columns"/><EntitySet Name="DataTypes" EntityType="SYS.DataTypes"/><EntitySet Name="KeyColumns" EntityType="SYS.KeyColumns"/><EntitySet Name="Keys" EntityType="SYS.Keys"/><EntitySet Name="ProcedureParams" EntityType="SYS.ProcedureParams"/><EntitySet Name="Procedures" EntityType="SYS.Procedures"/><EntitySet Name="Properties" EntityType="SYS.Properties"/><EntitySet Name="Schemas" EntityType="SYS.Schemas"/><EntitySet Name="Tables" EntityType="SYS.Tables"/><EntitySet Name="VirtualDatabases" EntityType="SYS.VirtualDatabases"/><AssociationSet Name="Columns_FK0" Association="SYS.Columns_FK0"><End EntitySet="Columns" Role="Columns"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="Columns_FK1" Association="SYS.Columns_FK1"><End EntitySet="Columns" Role="Columns"/><End EntitySet="DataTypes" Role="DataTypes"/></AssociationSet><AssociationSet Name="KeyColumns_FK0" Association="SYS.KeyColumns_FK0"><End EntitySet="KeyColumns" Role="KeyColumns"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="Keys_FK0" Association="SYS.Keys_FK0"><End EntitySet="Keys" Role="Keys"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="ProcedureParams_FK0" Association="SYS.ProcedureParams_FK0"><End EntitySet="ProcedureParams" Role="ProcedureParams"/><End EntitySet="Procedures" Role="Procedures"/></AssociationSet><AssociationSet Name="ProcedureParams_FK1" Association="SYS.ProcedureParams_FK1"><End EntitySet="ProcedureParams" Role="ProcedureParams"/><End EntitySet="DataTypes" Role="DataTypes"/></AssociationSet><AssociationSet Name="Procedures_FK0" Association="SYS.Procedures_FK0"><End EntitySet="Procedures" Role="Procedures"/><End EntitySet="Schemas" Role="Schemas"/></AssociationSet><AssociationSet Name="Tables_FK0" Association="SYS.Tables_FK0"><End EntitySet="Tables" Role="Tables"/><End EntitySet="Schemas" Role="Schemas"/></AssociationSet><FunctionImport Name="getXMLSchemas" ReturnType="Collection(SYS.getXMLSchemas_RSParam)" m:HttpMethod="GET"><Parameter Name="document" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport></EntityContainer></Schema><Schema Namespace="SYSADMIN"><EntityType Name="MatViews"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TargetSchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TargetName" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Valid" Type="Edm.Boolean" Nullable="true"/><Property Name="LoadState" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Updated" Type="Edm.DateTime" Nullable="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="true"/></EntityType><EntityType Name="VDBResources"><Key><PropertyRef Name="resourcePath"/></Key><Property Name="resourcePath" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="contents" Type="Edm.Binary" Nullable="true"/></EntityType><EntityContainer Name="SYSADMIN" m:IsDefaultEntityContainer="false"><EntitySet Name="MatViews" EntityType="SYSADMIN.MatViews"/><EntitySet Name="VDBResources" EntityType="SYSADMIN.VDBResources"/><FunctionImport Name="isLoggable" m:HttpMethod="POST"><Parameter Name="loggable" Type="Edm.Boolean" Nullable="false"/><Parameter Name="level" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="context" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="logMsg" m:HttpMethod="POST"><Parameter Name="logged" Type="Edm.Boolean" Nullable="false"/><Parameter Name="level" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="context" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="msg" Type="Edm.Binary" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="refreshMatView" m:HttpMethod="POST"><Parameter Name="RowsUpdated" Type="Edm.Int32" Nullable="false"/><Parameter Name="ViewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Invalidate" Type="Edm.Boolean" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="refreshMatViewRow" m:HttpMethod="POST"><Parameter Name="RowsUpdated" Type="Edm.Int32" Nullable="false"/><Parameter Name="ViewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Key" Type="Edm.Binary" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="setColumnStats" m:HttpMethod="POST"><Parameter Name="tableName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="columnName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="distinctCount" Type="Edm.Int32" Mode="In" Nullable="true"/><Parameter Name="nullCount" Type="Edm.Int32" Mode="In" Nullable="true"/><Parameter Name="max" Type="Edm.String" Mode="In" Nullable="true"/><Parameter Name="min" Type="Edm.String" Mode="In" Nullable="true"/></FunctionImport><FunctionImport Name="setProperty" m:HttpMethod="POST"><Parameter Name="OldValue" Type="Edm.Binary" Nullable="false"/><Parameter Name="UID" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Name" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Value" Type="Edm.Binary" Mode="In" Nullable="true"/></FunctionImport><FunctionImport Name="setTableStats" m:HttpMethod="POST"><Parameter Name="tableName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="cardinality" Type="Edm.Int32" Mode="In" Nullable="false"/></FunctionImport></EntityContainer></Schema><Schema Namespace="pg_catalog"><EntityType Name="matpg_datatype"><Key><PropertyRef Name="oid"/><PropertyRef Name="name"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="typname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="name" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="uid" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="typlen" Type="Edm.Int16" Nullable="true"/></EntityType><EntityType Name="matpg_relatt"><Key><PropertyRef Name="attname"/><PropertyRef Name="relname"/><PropertyRef Name="nspname"/></Key><Property Name="attrelid" Type="Edm.Int32" Nullable="true"/><Property Name="attnum" Type="Edm.Int16" Nullable="true"/><Property Name="attname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="relname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="nspname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="autoinc" Type="Edm.Boolean" Nullable="true"/><Property Name="typoid" Type="Edm.Int32" Nullable="true"/></EntityType><EntityType Name="pg_attribute"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="attrelid" Type="Edm.Int32" Nullable="true"/><Property Name="attname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="atttypid" Type="Edm.Int32" Nullable="true"/><Property Name="attlen" Type="Edm.Int16" Nullable="true"/><Property Name="attnum" Type="Edm.Int16" Nullable="true"/><Property Name="atttypmod" Type="Edm.Int32" Nullable="true"/><Property Name="attnotnull" Type="Edm.Boolean" Nullable="true"/><Property Name="attisdropped" Type="Edm.Boolean" Nullable="true"/><Property Name="atthasdef" Type="Edm.Boolean" Nullable="true"/></EntityType><EntityType Name="pg_class"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="relname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="relnamespace" Type="Edm.Int32" Nullable="true"/><Property Name="relkind" Type="Edm.String" Nullable="true"/><Property Name="relam" Type="Edm.Int32" Nullable="true"/><Property Name="reltuples" Type="Edm.Single" Nullable="true"/><Property Name="relpages" Type="Edm.Int32" Nullable="true"/><Property Name="relhasrules" Type="Edm.Boolean" Nullable="true"/><Property Name="relhasoids" Type="Edm.Boolean" Nullable="true"/></EntityType><EntityType Name="pg_index"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="indexrelid" Type="Edm.Int32" Nullable="true"/><Property Name="indrelid" Type="Edm.Int32" Nullable="true"/><Property Name="indnatts" Type="Edm.Int16" Nullable="true"/><Property Name="indisclustered" Type="Edm.Boolean" Nullable="true"/><Property Name="indisunique" Type="Edm.Boolean" Nullable="true"/><Property Name="indisprimary" Type="Edm.Boolean" Nullable="true"/><Property Name="indexprs" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="indkey" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/></EntityType><EntityType Name="pg_proc"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="proname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="proretset" Type="Edm.Boolean" Nullable="true"/><Property Name="prorettype" Type="Edm.Int32" Nullable="true"/><Property Name="pronargs" Type="Edm.Int16" Nullable="true"/><Property Name="proargtypes" Type="Edm.Binary" Nullable="true"/><Property Name="proargnames" Type="Edm.Binary" Nullable="true"/><Property Name="proargmodes" Type="Edm.Binary" Nullable="true"/><Property Name="proallargtypes" Type="Edm.Binary" Nullable="true"/><Property Name="pronamespace" Type="Edm.Int32" Nullable="true"/></EntityType><EntityContainer Name="pg_catalog" m:IsDefaultEntityContainer="false"><EntitySet Name="matpg_datatype" EntityType="pg_catalog.matpg_datatype"/><EntitySet Name="matpg_relatt" EntityType="pg_catalog.matpg_relatt"/><EntitySet Name="pg_attribute" EntityType="pg_catalog.pg_attribute"/><EntitySet Name="pg_class" EntityType="pg_catalog.pg_class"/><EntitySet Name="pg_index" EntityType="pg_catalog.pg_index"/><EntitySet Name="pg_proc" EntityType="pg_catalog.pg_proc"/></EntityContainer></Schema></edmx:DataServices></edmx:Edmx>
> Odata Table Query Not Workng
> ----------------------------
>
> Key: TEIID-2519
> URL: https://issues.jboss.org/browse/TEIID-2519
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.3
> Environment: CentOS, JBOSS AS 7.1.1, Teiid 8.3.
> Reporter: devin pinkston
> Assignee: Ramesh Reddy
> Priority: Minor
> Labels: odata,, service,, web
> Fix For: 8.4
>
> Attachments: metadata.txt, portfolio-vdb.xml, portfolio-vdb.xml
>
>
> When trying to query a table through Odata, a error is diplayed: EdmEntitySet refinedSalariesModel.refinedSalaries is not found
> When issuing the query:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel.refinedSalaries
> We have also tried using:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries
> When issuing the second query, this error is thrown:
> <error><code/><message lang="en-US">Could not find resource for relative : /refinedSalariesModel/refinedSalaries of full path: http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries</message></error>
> We can successfully display the metadata and see the details of the VDB by using:
> http://localhost:8080/odata/Portfolio.1/$metadata
> Please let me know if you need any more information
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2519) Odata Table Query Not Workng
by devin pinkston (JIRA)
[ https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin... ]
devin pinkston updated TEIID-2519:
----------------------------------
Attachment: metadata.txt
> Odata Table Query Not Workng
> ----------------------------
>
> Key: TEIID-2519
> URL: https://issues.jboss.org/browse/TEIID-2519
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.3
> Environment: CentOS, JBOSS AS 7.1.1, Teiid 8.3.
> Reporter: devin pinkston
> Assignee: Ramesh Reddy
> Priority: Minor
> Labels: odata,, service,, web
> Fix For: 8.4
>
> Attachments: metadata.txt, portfolio-vdb.xml, portfolio-vdb.xml
>
>
> When trying to query a table through Odata, a error is diplayed: EdmEntitySet refinedSalariesModel.refinedSalaries is not found
> When issuing the query:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel.refinedSalaries
> We have also tried using:
> http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries
> When issuing the second query, this error is thrown:
> <error><code/><message lang="en-US">Could not find resource for relative : /refinedSalariesModel/refinedSalaries of full path: http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries</message></error>
> We can successfully display the metadata and see the details of the VDB by using:
> http://localhost:8080/odata/Portfolio.1/$metadata
> Please let me know if you need any more information
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2249) Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2249?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2249:
---------------------------------------
What should be in scope for 8.4.1 is an initial form of 1.a, 1.b, with the ability provide other possibly arbitrary hinting information.
I would propose that all other parts of the issue would be out of scope as to limit support exposure with a possibly incomplete feature. However it will still be possible through an extended translator to implement the desired functionality.
> There should also be a configurable restiction threshold to prevent the use of temp table if the tuple width is too wide
The current logic only passes key information to the source queries, so width isn't a consideration unless there is an odd key type or some extreme composite key - which I don't think he's referring to. The other possibility is that he means the entirety of the independent/driving side of the join would be shipped to form the temporary table such that the complete results are read by Teiid instead of a secondary in-Teiid join being performed. That would be an entirely new mode of operation and would be out of scope as well.
> Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS
> ----------------------------------------------------------------------------------------------------------
>
> Key: TEIID-2249
> URL: https://issues.jboss.org/browse/TEIID-2249
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 8.4.1
>
>
> Our proposal is to allow for the more efficient use of large ad-hoc result-sets by rather than creating a long 'IN' list, inserting them in to a temporary table - for example a # table in Sybase and SQL Server - and then generating an SQL join to that instead.
> One of the difference to materialized views (or at least my understanding), is that this work happens at a data-source rather than within the Teiid server.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months
[JBoss JIRA] (TEIID-2249) Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2249?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIID-2249 at 5/30/13 1:03 PM:
----------------------------------------------------------------
Customer's responses to Steve request for specifics:
* explicitly what triggers the default dependent join handling vs. the use of a temp table (row count, number of source queries etc.)?
- in an ideal world they would implement their temp table strategy given the current capability for dependent join pushdown and contribute back the implementation (showing type mapping, index generation, table naming strategy, etc.) and provide us with empirically what makes sense in terms of when the temp table strategy should be used.
Answer 1) The use of temp table could be trigger either on
a) The row count of the temp table. A configurable threshold
b) Hinting on the main query to toggle on/off
There should also be a configurable restiction threshold to prevent the use of temp table if the tuple width is too wide
Just have to ensure it will clear the data in the temp table when the source system request has completed
* can an example of the desired query hint and options (this could include a source hint, control over adding an index, etc.) be provided?
Answer 2) I wont be able to provide the syntax of what it should look like but the hints and options are stated in 1) and 4).
* what sources will be targeted?
Answer 3) Definitely Oracle 10g & 11g and Sybase ASE 12 & 15. Potentially Sybase IQ and ParAccel
* under what conditions should an index be added to the generated temp table or would this just be directed via a hint?
Answer 4) Index creation should be configurable [hinted] and index should be on the joining key(s). For simplicity, I would expect just a simple non unique index
even though oracle offers different types of indexes. Source hints should also be available to hint the source system query to ensure good execution
plan is generated while joining to the temp table.
was (Author: dsteigne):
Customer's responses to Steve request for specifics:
* explicitly what triggers the default dependent join handling vs. the use of a temp table (row count, number of source queries etc.)?
- in an ideal world they would implement their temp table strategy given the current capability for dependent join pushdown and contribute back the implementation (showing type mapping, index generation, table naming strategy, etc.) and provide us with empirically what makes sense in terms of when the temp table strategy should be used.
Answer 1) The use of temp table could be trigger either on
a) The row count of the temp table. A configurable threshold
b) Hinting on the main query to toggle on/off
There should also be a configurable restiction threshold to prevent the use of temp table if the tuple width is too wide
Just have to ensure it will clear the data in the temp table when the source system request has completed
* can an example of the desired query hint and options (this could include a source hint, control over adding an index, etc.) be provided?
Answer 2) I wont be able to provide the syntax of what it should look like but the hints and options are stated in 1) and 4).
* what sources will be targeted? (presumably for RBS just Oracle)
Answer 3) Definitely Oracle 10g & 11g and Sybase ASE 12 & 15. Potentially Sybase IQ and ParAccel
* under what conditions should an index be added to the generated temp table or would this just be directed via a hint?
Answer 4) Index creation should be configurable [hinted] and index should be on the joining key(s). For simplicity, I would expect just a simple non unique index
even though oracle offers different types of indexes. Source hints should also be available to hint the source system query to ensure good execution
plan is generated while joining to the temp table.
> Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS
> ----------------------------------------------------------------------------------------------------------
>
> Key: TEIID-2249
> URL: https://issues.jboss.org/browse/TEIID-2249
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 8.4.1
>
>
> Our proposal is to allow for the more efficient use of large ad-hoc result-sets by rather than creating a long 'IN' list, inserting them in to a temporary table - for example a # table in Sybase and SQL Server - and then generating an SQL join to that instead.
> One of the difference to materialized views (or at least my understanding), is that this work happens at a data-source rather than within the Teiid server.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 11 months