[teiid-issues] [JBoss JIRA] (TEIID-4568) Modeshape query

Tom Johnston (JIRA) issues at jboss.org
Wed Nov 9 13:28:00 EST 2016 

    [ https://issues.jboss.org/browse/TEIID-4568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13319836#comment-13319836 ] 

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)

More information about the teiid-issues mailing list