[JBoss JIRA] (TEIID-3825) Add a wildfly-swarm-teiid Fraction for running teiid as an uberjar
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3825?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-3825 at 11/23/16 10:13 PM:
---------------------------------------------------------------
h2. How to Test
1. build swarm teiid(teiid/wildfly-swarm-teiid)
2. build swarm teiid example(teiid/wildfly-swarm-teiid-examples)
3. start uberjar like
{code}
java -jar vdb-datafederation/target/vdb-datafederation-swarm.jar
java -jar vdb-materialization/target/vdb-materialization-swarm.jar
java -jar rdbms-as-datasource/target/rdbms-as-datasource-swarm.jar
java -jar loopback-source/target/loopback-source-swarm.jar
{code}
Each module has a readme which contain more depictions and how to run.
I believe there will be some suggestions once you finished the test, for build swarm teiid, I am not configure the swarm related plugin in project, I use wildfly-swarm as parent instead
{code}
<parent>
<groupId>org.wildfly.swarm</groupId>
<artifactId>wildfly-swarm</artifactId>
<version>2016.8.1</version>
</parent>
<artifactId>teiid</artifactId>
<name>Teiid</name>
{code}
If take Bob's suggestions, put the swarm teiid together with others, I doubt there may have risk, because wildfly swarm is a sub-project of wildfly, the wildfly feature pack and config api swarm used are always base on latest wildfly version, for example:
* the least version of swarm base on wildfly 10.0.0 is 2016.8.1(swarm start from 2016.9 use wildfly 10.1)
* the teiid master still use wildfly 10.0.0
was (Author: kylin):
h2. How to Test
1. build teiid master
2. build swarm teiid(teiid/wildfly-swarm-teiid)
3. build swarm teiid example(teiid/wildfly-swarm-teiid-examples)
4. start uberjar like
{code}
java -jar vdb-datafederation/target/vdb-datafederation-swarm.jar
java -jar vdb-materialization/target/vdb-materialization-swarm.jar
java -jar rdbms-as-datasource/target/rdbms-as-datasource-swarm.jar
java -jar loopback-source/target/loopback-source-swarm.jar
{code}
Each module has a readme which contain more depictions and how to run.
I believe there will be some suggestions once you finished the test, for build swarm teiid, I am not configure the swarm related plugin in project, I use wildfly-swarm as parent instead
{code}
<parent>
<groupId>org.wildfly.swarm</groupId>
<artifactId>wildfly-swarm</artifactId>
<version>2016.8.1</version>
</parent>
<artifactId>teiid</artifactId>
<name>Teiid</name>
{code}
If take Bob's suggestions, put the swarm teiid together with others, I doubt there may have risk, because wildfly swarm is a sub-project of wildfly, the wildfly feature pack and config api swarm used are always base on latest wildfly version, for example:
* the least version of swarm base on wildfly 10.0.0 is 2016.8.1(swarm start from 2016.9 use wildfly 10.1)
* the teiid master still use wildfly 10.0.0
> Add a wildfly-swarm-teiid Fraction for running teiid as an uberjar
> ------------------------------------------------------------------
>
> Key: TEIID-3825
> URL: https://issues.jboss.org/browse/TEIID-3825
> Project: Teiid
> Issue Type: Feature Request
> Components: Embedded
> Affects Versions: 9.0
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.2
>
>
> Fractions within WildFly Swarm are roughly equivalent to subsystems within WildFly, we have teiid subsystem in Server mode, so I think a Fraction is necessary to run teiid with Swarm.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4598) Source function for Greenplum data source doesn't get pushdown
by Anu Saji (JIRA)
Anu Saji created TEIID-4598:
-------------------------------
Summary: Source function for Greenplum data source doesn't get pushdown
Key: TEIID-4598
URL: https://issues.jboss.org/browse/TEIID-4598
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.12.x
Reporter: Anu Saji
Assignee: Steven Hawkins
Fix For: 8.12
In customers exact words
when executing the following
~~~
USER COMMAND:
SELECT GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month") FROM GPDBDEV.kr_cust_team_target
~~~
Gives NPE
11:59:38,611 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue3) TEIID30019 Unexpected exception for request BWIVpfi0IyEK.0: java.lang.NullPointerException
at org.teiid.query.function.FunctionDescriptor.newInstance(FunctionDescriptor.java:91) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.function.aggregate.UserDefined.<init>(UserDefined.java:44) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.GroupingNode.initAccumulator(GroupingNode.java:291) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.WindowFunctionProjectNode.initializeAccumulators(WindowFunctionProjectNode.java:414) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.WindowFunctionProjectNode.buildResults(WindowFunctionProjectNode.java:339) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.WindowFunctionProjectNode.nextBatchDirect(WindowFunctionProjectNode.java:232) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4597) Issue loading staging table
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4597?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4597:
-------------------------------
Description:
In the metadata processor, the loading of the staging table doesn't get loaded due to the isStaging() method return false.
This jira is created so that this issue is documented, as the fix is included in the commit for TEIID-4588 because this has to be fixed in order to see the duplicate column issue in TEIID-4588.
was:
In the metadata processor, the loading of the staging table doesn't get loaded due to the isStaging() method return false.
This jira is created so that this issue is documented, as the fix is included in the commit for TEIID-4588
> Issue loading staging table
> ---------------------------
>
> Key: TEIID-4597
> URL: https://issues.jboss.org/browse/TEIID-4597
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.x
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Blocker
> Fix For: 9.2, 8.12.8.6_3
>
>
> In the metadata processor, the loading of the staging table doesn't get loaded due to the isStaging() method return false.
> This jira is created so that this issue is documented, as the fix is included in the commit for TEIID-4588 because this has to be fixed in order to see the duplicate column issue in TEIID-4588.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4597) Issue loading staging table
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4597?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-4597:
----------------------------------
Assignee: Van Halbert (was: Steven Hawkins)
> Issue loading staging table
> ---------------------------
>
> Key: TEIID-4597
> URL: https://issues.jboss.org/browse/TEIID-4597
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.x
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Blocker
> Fix For: 9.2, 8.12.8.6_3
>
>
> In the metadata processor, the loading of the staging table doesn't get loaded due to the isStaging() method return false.
> This jira is created so that this issue is documented, as the fix is included in the commit for TEIID-4588
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4597) Issue loading staging table
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4597?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4597:
-------------------------------
Affects Version/s: 8.12.x
(was: 8.12.8.6_3)
> Issue loading staging table
> ---------------------------
>
> Key: TEIID-4597
> URL: https://issues.jboss.org/browse/TEIID-4597
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.x
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.2, 8.12.8.6_3
>
>
> In the metadata processor, the loading of the staging table doesn't get loaded due to the isStaging() method return false.
> This jira is created so that this issue is documented, as the fix is included in the commit for TEIID-4588
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4597) Issue loading staging table
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4597?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4597:
-------------------------------
Fix Version/s: 9.2
8.12.8.6_3
> Issue loading staging table
> ---------------------------
>
> Key: TEIID-4597
> URL: https://issues.jboss.org/browse/TEIID-4597
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.x
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.2, 8.12.8.6_3
>
>
> In the metadata processor, the loading of the staging table doesn't get loaded due to the isStaging() method return false.
> This jira is created so that this issue is documented, as the fix is included in the commit for TEIID-4588
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4597) Issue loading staging table
by Van Halbert (JIRA)
Van Halbert created TEIID-4597:
----------------------------------
Summary: Issue loading staging table
Key: TEIID-4597
URL: https://issues.jboss.org/browse/TEIID-4597
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.12.8.6_3
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Blocker
In the metadata processor, the loading of the staging table doesn't get loaded due to the isStaging() method return false.
This jira is created so that this issue is documented, as the fix is included in the commit for TEIID-4588
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months
[JBoss JIRA] (TEIID-4595) Wrong pushdown of several spatial functions to Oracle
by Andrej Šmigala (JIRA)
Andrej Šmigala created TEIID-4595:
-------------------------------------
Summary: Wrong pushdown of several spatial functions to Oracle
Key: TEIID-4595
URL: https://issues.jboss.org/browse/TEIID-4595
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12.x
Reporter: Andrej Šmigala
Assignee: Steven Hawkins
There are several geospatial functions that are wrongly pushed down to oracle
# {{ST_DISTANCE}} is pushed as {{SDO_GEOM.DISTANCE}} which does not exist, should be {{SDO_GEOM.SDO_DISTANCE}}. This results in runtime error.
# {{ST_CROSSES}} and {{ST_OVERLAPS}} are both pushed as {{SDO_RELATE}} with mask {{"overlapbydisjoint"}} which does not exists, should be {{"overlapbdydisjoint"}} (sic} for {{ST_CROSSES}} and {{"overlapbdyintersect"}} for {{ST_OVERLAPS}}. This results in {{false}} being returned for all calls to the two functions
# Using {{ST_DISJOINT}} in the select clause (but not in criteria) results in the following error when evaluating to true:
{noformat}
org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 SpatialModel: 99999 Unexpected exception while translating results: Fail to convert to internal representation
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:706)
at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64)
at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:545)
at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135)
at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40)
at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79)
at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:268)
at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:306)
at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
at com.sun.proxy.$Proxy18.read(Unknown Source)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:405)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:554)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1060)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:323)
at org.jboss.bqt.framework.AbstractQuery.execute(AbstractQuery.java:208)
at org.jboss.bqt.client.testcase.ProcessResults.executeTest(ProcessResults.java:280)
at org.jboss.bqt.client.testcase.ProcessResults.runTestCase(ProcessResults.java:166)
at org.jboss.bqt.client.TestClient.runScenario(TestClient.java:209)
at org.jboss.bqt.client.TestClient.runTest(TestClient.java:132)
at org.jboss.bqt.client.TestClient.runTest(TestClient.java:113)
at org.jboss.qe.bqt.BQTHelper.startTest(BQTHelper.java:59)
at org.jboss.dv.test.bqt.Utils.runScenarioTest(Utils.java:185)
at org.jboss.dv.test.bqt.TestPassRDBMS.testRdbms(TestPassRDBMS.java:210)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:86)
at org.testng.internal.MethodInvocationHelper$1.runTestMethod(MethodInvocationHelper.java:197)
at org.jboss.qe.DVQETestListener.run(DVQETestListener.java:266)
at org.testng.internal.MethodInvocationHelper.invokeHookable(MethodInvocationHelper.java:209)
at org.testng.internal.Invoker.invokeMethod(Invoker.java:639)
at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:820)
at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1128)
at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:129)
at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:112)
at org.testng.TestRunner.privateRun(TestRunner.java:782)
at org.testng.TestRunner.run(TestRunner.java:632)
at org.testng.SuiteRunner.runTest(SuiteRunner.java:366)
at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:361)
at org.testng.SuiteRunner.privateRun(SuiteRunner.java:319)
at org.testng.SuiteRunner.run(SuiteRunner.java:268)
at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
at org.testng.TestNG.runSuitesSequentially(TestNG.java:1244)
at org.testng.TestNG.runSuitesLocally(TestNG.java:1169)
at org.testng.TestNG.run(TestNG.java:1064)
at org.apache.maven.surefire.testng.TestNGExecutor.run(TestNGExecutor.java:70)
at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.execute(TestNGDirectoryTestSuite.java:108)
at org.apache.maven.surefire.testng.TestNGProvider.invoke(TestNGProvider.java:111)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164)
at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110)
at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:172)
at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:104)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:70)
Caused by: org.teiid.core.TeiidProcessingException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 SpatialModel: 99999 Unexpected exception while translating results: Fail to convert to internal representation
at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401)
at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161)
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:391)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.teiid.core.TeiidException: 99999 Remote org.teiid.translator.TranslatorException: 99999 Unexpected exception while translating results: Fail to convert to internal representation
at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:351)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:436)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236)
at sun.reflect.GeneratedMethodAccessor88.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy47.more(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
... 6 more
Caused by: java.sql.SQLException: Remote java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getBoolean(CharCommonAccessor.java:183)
at oracle.jdbc.driver.GeneratedStatement.getBoolean(GeneratedStatement.java:129)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getBoolean(GeneratedScrollableResultSet.java:232)
at org.jboss.jca.adapters.jdbc.WrappedResultSet.getBoolean(WrappedResultSet.java:594)
at org.teiid.translator.jdbc.JDBCExecutionFactory.retrieveValue(JDBCExecutionFactory.java:1068)
at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:344)
... 18 more
{noformat}
This is because it is pushed down as {{SDO_GEOM.RELATE}} with mask {{"disjoint"}}, which in oracle returns the string {{'DISJOINT'}} instead of the more expected {{'TRUE'}}.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 4 months