12:28 p.m.
[
https://issues.jboss.org/browse/TEIID-4568?page=com.atlassian.jira.plugin...
]
Tom Johnston edited comment on TEIID-4568 at 11/9/16 1:27 PM:
--------------------------------------------------------------
12:25:22,628 WARN [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue1300) Connector
worker process failed for atomic-request=qD/tSvSAxBsT.617.0.126:
org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing
statement(s): [SQL: SELECT g_1."jcr:path", g_0."mode:localName",
g_2."jcr:name" FROM "relational:table" AS g_0 INNER JOIN
"relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN
"xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND
ISCHILDNODE(g_2, g_0)]
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
[translator-jdbc-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1]
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364)
at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source) [:1.7.0_71]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at
org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy93.execute(Unknown Source)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
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:262) [rt.jar:1.7.0_71]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
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:1145)
[rt.jar:1.7.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_71]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]
Caused by: java.sql.SQLException: The JCR-SQL2 query "SELECT
g_1."jcr:path", g_0."mode:localName", g_2."jcr:name" FROM
"relational:table" AS g_0 INNER JOIN "relational:column" AS g_1 ON
ISCHILDNODE(g_1, g_0) INNER JOIN "xmi:model" AS g_2 ON g_1."jcr:path"
= g_2."jcr:path" AND ISCHILDNODE(g_2, g_0)" is not well-formed: Unexpected
token 'AND' at line 1, column 209
at org.modeshape.jdbc.JcrStatement.execute(JcrStatement.java:433)
[modeshape-jdbc-local-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at org.modeshape.jdbc.JcrStatement.executeQuery(JcrStatement.java:479)
[modeshape-jdbc-local-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at
org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)
[translator-jdbc-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1]
... 17 more
Caused by: javax.jcr.query.InvalidQueryException: The JCR-SQL2 query "SELECT
g_1."jcr:path", g_0."mode:localName", g_2."jcr:name" FROM
"relational:table" AS g_0 INNER JOIN "relational:column" AS g_1 ON
ISCHILDNODE(g_1, g_0) INNER JOIN "xmi:model" AS g_2 ON g_1."jcr:path"
= g_2."jcr:path" AND ISCHILDNODE(g_2, g_0)" is not well-formed: Unexpected
token 'AND' at line 1, column 209
at org.modeshape.jcr.JcrQueryManager.createQuery(JcrQueryManager.java:149)
[modeshape-jcr-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at org.modeshape.jcr.JcrQueryManager.createQuery(JcrQueryManager.java:104)
[modeshape-jcr-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at
org.modeshape.jdbc.delegate.LocalRepositoryDelegate.execute(LocalRepositoryDelegate.java:139)
[modeshape-jdbc-local-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at org.modeshape.jdbc.JcrStatement.execute(JcrStatement.java:429)
[modeshape-jdbc-local-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
... 20 more
12:25:22,643 WARN [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue1301) TEIID30020
Processing exception for request qD/tSvSAxBsT.617 'TEIID30504 ModeShape: 0
TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_1."jcr:path",
g_0."mode:localName", g_2."jcr:name" FROM "relational:table"
AS g_0 INNER JOIN "relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN
"xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND
ISCHILDNODE(g_2, g_0)]'. Originally TeiidProcessingException 'The JCR-SQL2 query
"SELECT g_1."jcr:path", g_0."mode:localName",
g_2."jcr:name" FROM "relational:table" AS g_0 INNER JOIN
"relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN
"xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND
ISCHILDNODE(g_2, g_0)" is not well-formed: Unexpected token 'AND' at line 1,
column 209' JcrQueryManager.java:149. Enable more detailed logging to see the entire
stacktrace.
was (Author: virtualdatabase):
12:25:22,628 WARN [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue1300) Connector
worker process failed for atomic-request=qD/tSvSAxBsT.617.0.126:
org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing
statement(s): [SQL: SELECT g_1."jcr:path", g_0."mode:localName",
g_2."jcr:name" FROM "relational:table" AS g_0 INNER JOIN
"relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN
"xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND
ISCHILDNODE(g_2, g_0)]
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
[translator-jdbc-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1]
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364)
at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source) [:1.7.0_71]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at
org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy93.execute(Unknown Source)
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
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:262) [rt.jar:1.7.0_71]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
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:1145)
[rt.jar:1.7.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_71]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]
Caused by: java.sql.SQLException: The JCR-SQL2 query "SELECT
g_1."jcr:path", g_0."mode:localName", g_2."jcr:name" FROM
"relational:table" AS g_0 INNER JOIN "relational:column" AS g_1 ON
ISCHILDNODE(g_1, g_0) INNER JOIN "xmi:model" AS g_2 ON g_1."jcr:path"
= g_2."jcr:path" AND ISCHILDNODE(g_2, g_0)" is not well-formed: Unexpected
token 'AND' at line 1, column 209
at org.modeshape.jdbc.JcrStatement.execute(JcrStatement.java:433)
[modeshape-jdbc-local-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at org.modeshape.jdbc.JcrStatement.executeQuery(JcrStatement.java:479)
[modeshape-jdbc-local-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at
org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)
[translator-jdbc-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1]
... 17 more
Caused by: javax.jcr.query.InvalidQueryException: The JCR-SQL2 query "SELECT
g_1."jcr:path", g_0."mode:localName", g_2."jcr:name" FROM
"relational:table" AS g_0 INNER JOIN "relational:column" AS g_1 ON
ISCHILDNODE(g_1, g_0) INNER JOIN "xmi:model" AS g_2 ON g_1."jcr:path"
= g_2."jcr:path" AND ISCHILDNODE(g_2, g_0)" is not well-formed: Unexpected
token 'AND' at line 1, column 209
at org.modeshape.jcr.JcrQueryManager.createQuery(JcrQueryManager.java:149)
[modeshape-jcr-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at org.modeshape.jcr.JcrQueryManager.createQuery(JcrQueryManager.java:104)
[modeshape-jcr-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at
org.modeshape.jdbc.delegate.LocalRepositoryDelegate.execute(LocalRepositoryDelegate.java:139)
[modeshape-jdbc-local-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
at org.modeshape.jdbc.JcrStatement.execute(JcrStatement.java:429)
[modeshape-jdbc-local-3.8.4.GA-redhat-11.jar:3.8.4.GA-redhat-11]
... 20 more
12:25:22,643 WARN [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue1301) TEIID30020
Processing exception for request qD/tSvSAxBsT.617 'TEIID30504 ModeShape: 0
TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_1."jcr:path",
g_0."mode:localName", g_2."jcr:name" FROM "relational:table"
AS g_0 INNER JOIN "relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN
"xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND
ISCHILDNODE(g_2, g_0)]'. Originally TeiidProcessingException 'The JCR-SQL2 query
"SELECT g_1."jcr:path", g_0."mode:localName",
g_2."jcr:name" FROM "relational:table" AS g_0 INNER JOIN
"relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN
"xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND
ISCHILDNODE(g_2, g_0)" is not well-formed: Unexpected
Modeshape query
---------------
Key: TEIID-4568
URL: https://issues.jboss.org/browse/TEIID-4568
Project: Teiid
Issue Type: Bug
Reporter: Tom Johnston
Assignee: Steven Hawkins
Labels: modeshape
The following modeshape vdb query fails.
select a.jcr_path, a.table_name ,b.jcr_name
from "Relational_Model_View"."Table_Columns" a,
"ModeShape"."xmi_model" b
where a.jcr_path = b.jcr_path
the error is:
Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ModeShape: 0
TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_1."jcr:path",
g_0."mode:localName", g_2."jcr:name" FROM "relational:table"
AS g_0 INNER JOIN "relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN
"xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND
ISCHILDNODE(g_2, g_0)]
SQLState: 50000
ErrorCode: 30504
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
3433
days inactive
3433
days old
0 comments
1 participants
participants (1)
-
Tom Johnston (JIRA)