1 2 3 4 5 Previous Next 66 Replies Latest reply on Oct 12, 2012 12:35 PM by rareddy Go to original post Branched to a new discussion.
      • 45. Re: From relational to XML (conforming to xschema)
        rareddy

        May be you can wrap the XML document in relational procedure and generate WAR with that?

        • 46. Re: From relational to XML (conforming to xschema)
          gioppoluca

          There are no options for creating data sources.

          I'm afraid that since I'm on TEIID 8 there is no chance of connecting to a TEIID instance from the designer.

          Any other way to create the data source?

          Maybe from the AS consolle?

          • 47. Re: From relational to XML (conforming to xschema)
            gioppoluca

            One step ahead and another error

            mind that I changed the VBD name into new_libri since I had the impression that having the WAR with the same name than the VDB was not a wise doing.

            I did not regenerated the WAR in any case so if the name change in the VDB call for some mods in the WAR this could be the problem.

             

            The VDB works since I can call it from squirrelSQL.

             

            Also I removed models that were created for the WS from the VDB do not know if is correct or not.

            I attache the files:

             

             

            11:13:57,406 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue6) TEIID30020 Processing exception 'Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

                ' for request PrfnUBPdQmS1.0.  Exception type org.teiid.api.exception.query.QueryParserException thrown from org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:194). Enable more detailed logging to see the entire stacktrace.

            11:13:57,437 GRAVE [org.teiid.soap] (http--127.0.0.1-8080-1) Exception in executeDataservice: {0}: java.lang.Throwable: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:194) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                at org.teiid.soap.provider.libro_bookListingDocument.invoke(libro_bookListingDocument.java:22) [classes:]

                at org.teiid.soap.provider.libro_bookListingDocument.invoke(libro_bookListingDocument.java:15) [classes:]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_04]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_04]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_04]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_04]

                at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_04]

                at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

            Caused by: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                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:654)

                at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

                at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:565)

                at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

                at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

                at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

                at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)

                at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_04]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_04]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_04]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_04]

                at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:102)

                at $Proxy37.read(Unknown Source)    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)

                at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:574)

                at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:201)

                at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124) [classes:]

                ... 41 more

            Caused by: [TeiidProcessingException]Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:194)

                at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:148)

                at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:124)

                at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:300)

                at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:376)

                at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:154)

                at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449)

                at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534)

                at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278)

                at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

                at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217)

                at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241)

                at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)

                at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)

                at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_04]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_04]

                ... 1 more

             

            11:13:57,609 ERROR [org.jboss.ws.common.invocation.InvocationHandlerJAXWS] (http--127.0.0.1-8080-1) Method invocation failed with exception: null: java.lang.reflect.InvocationTargetException

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_04]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_04]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_04]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_04]

                at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_04]

                at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

            Caused by: java.lang.RuntimeException: javax.xml.ws.soap.SOAPFaultException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:318) [classes:]

                at org.teiid.soap.provider.libro_bookListingDocument.invoke(libro_bookListingDocument.java:22) [classes:]

                at org.teiid.soap.provider.libro_bookListingDocument.invoke(libro_bookListingDocument.java:15) [classes:]

                ... 38 more

            Caused by: javax.xml.ws.soap.SOAPFaultException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                ... 40 more

             

            11:13:57,656 AVVERTENZA [org.apache.cxf.phase.PhaseInterceptorChain] (http--127.0.0.1-8080-1) Application {http://teiid.org}libri has thrown exception, unwinding now: org.apache.cxf.binding.soap.SoapFault: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.jboss.wsf.stack.cxf.JBossWSInvoker.createFault(JBossWSInvoker.java:237)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:201)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_04]

                at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

            Caused by: javax.xml.ws.soap.SOAPFaultException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                at org.teiid.soap.provider.libro_bookListingDocument.invoke(libro_bookListingDocument.java:22) [classes:]

                at org.teiid.soap.provider.libro_bookListingDocument.invoke(libro_bookListingDocument.java:15) [classes:]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_04]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_04]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_04]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_04]

                at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                ... 32 more

             

            11:16:06,453 WARN  [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue7) TEIID30020 Processing exception 'Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

                ' for request PrfnUBPdQmS1.1.  Exception type org.teiid.api.exception.query.QueryParserException thrown from org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:194). Enable more detailed logging to see the entire stacktrace.

            11:16:06,468 GRAVE [org.teiid.soap] (http--127.0.0.1-8080-1) Exception in executeDataservice: {0}: java.lang.Throwable: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:194) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                at org.teiid.soap.provider.local_book_aria_book_authors.invoke(local_book_aria_book_authors.java:22) [classes:]

                at org.teiid.soap.provider.local_book_aria_book_authors.invoke(local_book_aria_book_authors.java:15) [classes:]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_04]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_04]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_04]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_04]

                at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_04]

                at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

            Caused by: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                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:654)

                at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

                at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:565)

                at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

                at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

                at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

                at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)

                at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_04]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_04]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_04]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_04]

                at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:102)

                at $Proxy37.read(Unknown Source)    at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)

                at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:574)

                at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:201)

                at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124) [classes:]

                ... 41 more

            Caused by: [TeiidProcessingException]Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:194)

                at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:148)

                at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:124)

                at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:300)

                at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:376)

                at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:154)

                at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449)

                at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534)

                at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278)

                at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

                at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217)

                at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241)

                at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)

                at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)

                at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_04]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_04]

                ... 1 more

             

            11:16:06,531 ERROR [org.jboss.ws.common.invocation.InvocationHandlerJAXWS] (http--127.0.0.1-8080-1) Method invocation failed with exception: null: java.lang.reflect.InvocationTargetException

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_04]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_04]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_04]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_04]

                at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_04]

                at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

            Caused by: java.lang.RuntimeException: javax.xml.ws.soap.SOAPFaultException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:318) [classes:]

                at org.teiid.soap.provider.local_book_aria_book_authors.invoke(local_book_aria_book_authors.java:22) [classes:]

                at org.teiid.soap.provider.local_book_aria_book_authors.invoke(local_book_aria_book_authors.java:15) [classes:]

                ... 38 more

            Caused by: javax.xml.ws.soap.SOAPFaultException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                ... 40 more

             

            11:16:06,562 AVVERTENZA [org.apache.cxf.phase.PhaseInterceptorChain] (http--127.0.0.1-8080-1) Application {http://teiid.org}libri has thrown exception, unwinding now: org.apache.cxf.binding.soap.SoapFault: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.jboss.wsf.stack.cxf.JBossWSInvoker.createFault(JBossWSInvoker.java:237)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:201)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_04]

                at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_04]

                at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

            Caused by: javax.xml.ws.soap.SOAPFaultException: Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "null" at line 1, column 6.

            Was expecting:

                <ID> ...

             

                at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201) [classes:]

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                at org.teiid.soap.provider.local_book_aria_book_authors.invoke(local_book_aria_book_authors.java:22) [classes:]

                at org.teiid.soap.provider.local_book_aria_book_authors.invoke(local_book_aria_book_authors.java:15) [classes:]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_04]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_04]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_04]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_04]

                at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                ... 32 more

            • 48. Re: From relational to XML (conforming to xschema)
              gioppoluca

              This is the datasource created in standalone-teiid.xml

               

                          <datasource jndi-name="java:/my_teiid" pool-name="my-teiid" enabled="true" use-java-context="true">
                              <connection-url>jdbc:teiid:new_libri@mm://localhost:31000</connection-url>
                              <driver-class>org.teiid.jdbc.TeiidDriver</driver-class>
                              <driver>teiid</driver>
                              <pool>
                                  <prefill>false</prefill>
                                  <use-strict-min>false</use-strict-min>
                                  <flush-strategy>FailingConnectionOnly</flush-strategy>
                              </pool>
                              <security>
                                  <user-name>user</user-name>
                                  <password>user</password>
                              </security>
                          </datasource>
              • 49. Re: From relational to XML (conforming to xschema)
                gioppoluca

                Tryed to rebuild all from scratch:

                now VDB is called new_libri

                the relational model from where the WS is created is local_book

                the CXF generated from the VDB is called liber (it proposed new_libri, but I preferred to use another name for understanding sake)

                Now we got some new errors the war does not deploy it looks for a new_libri service (that I suppose is not the VBD, but some reference based on the fact it proposed that name):

                 

                 

                2:22:36,062 INFO  [org.apache.cxf.service.factory.ReflectionServiceFactoryBean] (MSC service thread 1-1) Creating Service {http://teiid.org}new_libri from WSDL: liber.wsdl

                12:22:36,156 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-1) MSC00001: Failed to start service jboss.deployment.unit."liber.war".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."liber.war".INSTALL: Failed to process phase INSTALL of deployment "liber.war"

                    at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]

                    at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_04]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_04]

                    at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

                Caused by: javax.xml.ws.WebServiceException: org.apache.cxf.service.factory.ServiceConstructionException: Could not find definition for service {http://teiid.org}new_libri.

                    at org.apache.cxf.jaxws.EndpointImpl.doPublish(EndpointImpl.java:350)

                    at org.jboss.wsf.stack.cxf.deployment.EndpointImpl.doPublish(EndpointImpl.java:88)

                    at org.apache.cxf.jaxws.EndpointImpl.publish(EndpointImpl.java:239)

                    at org.apache.cxf.jaxws.EndpointImpl.publish(EndpointImpl.java:509)

                    at org.jboss.wsf.stack.cxf.configuration.NonSpringBusHolder.configure(NonSpringBusHolder.java:117)

                    at org.jboss.wsf.stack.cxf.deployment.aspect.BusDeploymentAspect.startDeploymentBus(BusDeploymentAspect.java:113)

                    at org.jboss.wsf.stack.cxf.deployment.aspect.BusDeploymentAspect.start(BusDeploymentAspect.java:66)

                    at org.jboss.as.webservices.deployers.AspectDeploymentProcessor.deploy(AspectDeploymentProcessor.java:74)

                    at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]

                    ... 5 more

                Caused by: org.apache.cxf.service.factory.ServiceConstructionException: Could not find definition for service {http://teiid.org}new_libri.

                    at org.apache.cxf.wsdl11.WSDLServiceFactory.create(WSDLServiceFactory.java:139)

                    at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.buildServiceFromWSDL(ReflectionServiceFactoryBean.java:382)

                    at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.initializeServiceModel(ReflectionServiceFactoryBean.java:505)

                    at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.create(ReflectionServiceFactoryBean.java:241)

                    at org.apache.cxf.jaxws.support.JaxWsServiceFactoryBean.create(JaxWsServiceFactoryBean.java:205)

                    at org.apache.cxf.frontend.AbstractWSDLBasedEndpointFactory.createEndpoint(AbstractWSDLBasedEndpointFactory.java:101)

                    at org.apache.cxf.frontend.ServerFactoryBean.create(ServerFactoryBean.java:157)

                    at org.apache.cxf.jaxws.JaxWsServerFactoryBean.create(JaxWsServerFactoryBean.java:203)

                    at org.apache.cxf.jaxws.EndpointImpl.getServer(EndpointImpl.java:433)

                    at org.apache.cxf.jaxws.EndpointImpl.doPublish(EndpointImpl.java:322)

                    ... 13 more

                 

                12:22:36,187 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS015870: Deploy of deployment "liber.war" was rolled back with failure message {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"liber.war\".INSTALL" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"liber.war\".INSTALL: Failed to process phase INSTALL of deployment \"liber.war\""}}

                12:22:36,187 INFO  [org.jboss.as.controller] (DeploymentScanner-threads - 1) JBAS014774: Service status report

                JBAS014777:   Services which failed to start:      service jboss.deployment.unit."liber.war".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."liber.war".INSTALL: Failed to process phase INSTALL of deployment "liber.war"

                 

                12:22:36,187 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 2) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"liber.war\".INSTALL" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"liber.war\".INSTALL: Failed to process phase INSTALL of deployment \"liber.war\""}}}}

                12:22:36,234 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015877: Stopped deployment liber.war in 45ms

                • 50. Re: From relational to XML (conforming to xschema)
                  rareddy

                  Luca,

                   

                  I believe the JBoss AS deployer is saying that the "liber.wsdl" is not found. I see you have them in "wsdl" directory under "WEB-INF" as Ted suggested. Did the modified "libri.war" provided by Ted, with datasource configured works? I am sure this all will be whole lot easier once we have Teiid Designer for Teiid 8.

                   

                  Ramesh..

                  • 51. Re: From relational to XML (conforming to xschema)
                    gioppoluca

                    The WAR provided by Ted worked.

                    I tryed to build a new one as descibed before and placed the stuff in the correct folder as by Ted instructions ... there must be some secret he's not revealing

                    If you look at the local_book_aria_books.java

                    you find:

                    @WebServiceProvider(targetNamespace = "http://teiid.org", portName = "local_book_aria_books", serviceName = "new_libri", wsdlLocation = "liber.wsdl")

                     

                    I think that this is the cause of the error.

                    Maybe Designer proposed the usage of name getting it from the VDB, but when I changed it in the input field (since it is editable) it forgot to update things here.

                    Maybe a difficult burg to end into since most of the time you keep the proposed name.

                     

                    Let me know

                    Luca

                    • 52. Re: From relational to XML (conforming to xschema)
                      tejones

                      Luca,

                       

                      Yes... it looks like a refactor issue since the generated code is using the new name, but the WSDL has the old VDB name in it. Refactoring is a constant thorn in Designer.

                       

                      I believe it is finding your WSDL though. Can you try creating a new VDB, adding your models and generating the WAR instead of renaming?

                       

                      Thanks,

                      Ted

                      • 53. Re: From relational to XML (conforming to xschema)
                        gioppoluca

                        Ummmm .... that is exactly what I've done.

                        Created a new VBD and created a new WS but since the cxf generation proposed the VDB name I decided to change it and it changed it only in some places (I suppose) but kept its idea on other parts.

                        Will try to let it do its way and see if it works.

                        Luca

                        • 54. Re: From relational to XML (conforming to xschema)
                          tejones

                          Apologies Luca... I misunderstood your steps. I was able to reproduce and will correct this behavior in the next release. Please let us know how leaving the default values worked for you.

                           

                          Thanks,

                          Ted

                          • 55. Re: From relational to XML (conforming to xschema)
                            tejones

                            Luca,

                             

                            FYI... https://issues.jboss.org/browse/TEIIDDES-1141 and https://issues.jboss.org/browse/TEIIDDES-1401 were logged and resolved in the Teiid Designer 7.7.x branch. If you want to run Designer from the 7.7.x source to get those changes, you will be able to build and deploy your WAR to AS 7.1.1 without any additional voodoo.

                             

                            Thanks,

                            Ted

                            • 56. Re: From relational to XML (conforming to xschema)
                              gioppoluca

                              Can I just get the lates working jbosstools-teiid-designer_trunk-Update-SNAPSHOT.zip from hudson site, add the site.xml (that is missing and couild be nice to have it inside) and install it into eclipse?

                              I'm not so good to compile th4e designer from source.

                              Thanks

                              Luca

                              • 57. Re: From relational to XML (conforming to xschema)
                                rareddy

                                Luca,

                                 

                                You can use http://download.jboss.org/jbosstools/updates/nightly/soa-tooling/trunk/ as the update site to get latest nightly.

                                 

                                Ramesh..

                                • 58. Re: From relational to XML (conforming to xschema)
                                  tejones

                                  Luca,

                                   

                                  Using this update site... http://download.jboss.org/jbosstools/builds/nightly/soa-tooling/3.3.0.Beta3/2012-06-06_12-09-54-H4/all/repo/ and loading into a clean Eclipse 3.7.2 install will get you the bits that include these fixes.

                                   

                                  Thanks,

                                  Ted

                                  • 59. Re: From relational to XML (conforming to xschema)
                                    gioppoluca

                                    Still no luck:

                                    Here is the error

                                     

                                    12:43:04,211 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC00001: Failed to start service jboss.deployment.unit."bookdb.war".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."bookdb.war".INSTALL: Failed to process phase INSTALL of deployment "bookdb.war"

                                        at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]

                                        at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                                        at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                                        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_04]

                                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_04]

                                        at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

                                    Caused by: javax.xml.ws.WebServiceException: org.apache.cxf.service.factory.ServiceConstructionException: Failed to create service.

                                        at org.apache.cxf.jaxws.EndpointImpl.doPublish(EndpointImpl.java:350)

                                        at org.jboss.wsf.stack.cxf.deployment.EndpointImpl.doPublish(EndpointImpl.java:88)

                                        at org.apache.cxf.jaxws.EndpointImpl.publish(EndpointImpl.java:239)

                                        at org.apache.cxf.jaxws.EndpointImpl.publish(EndpointImpl.java:509)

                                        at org.jboss.wsf.stack.cxf.configuration.NonSpringBusHolder.configure(NonSpringBusHolder.java:117)

                                        at org.jboss.wsf.stack.cxf.deployment.aspect.BusDeploymentAspect.startDeploymentBus(BusDeploymentAspect.java:113)

                                        at org.jboss.wsf.stack.cxf.deployment.aspect.BusDeploymentAspect.start(BusDeploymentAspect.java:66)

                                        at org.jboss.as.webservices.deployers.AspectDeploymentProcessor.deploy(AspectDeploymentProcessor.java:74)

                                        at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]

                                        ... 5 more

                                    Caused by: org.apache.cxf.service.factory.ServiceConstructionException: Failed to create service.

                                        at org.apache.cxf.wsdl11.WSDLServiceFactory.<init>(WSDLServiceFactory.java:94)

                                        at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.buildServiceFromWSDL(ReflectionServiceFactoryBean.java:369)

                                        at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.initializeServiceModel(ReflectionServiceFactoryBean.java:505)

                                        at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.create(ReflectionServiceFactoryBean.java:241)

                                        at org.apache.cxf.jaxws.support.JaxWsServiceFactoryBean.create(JaxWsServiceFactoryBean.java:205)

                                        at org.apache.cxf.frontend.AbstractWSDLBasedEndpointFactory.createEndpoint(AbstractWSDLBasedEndpointFactory.java:101)

                                        at org.apache.cxf.frontend.ServerFactoryBean.create(ServerFactoryBean.java:157)

                                        at org.apache.cxf.jaxws.JaxWsServerFactoryBean.create(JaxWsServerFactoryBean.java:203)

                                        at org.apache.cxf.jaxws.EndpointImpl.getServer(EndpointImpl.java:433)

                                        at org.apache.cxf.jaxws.EndpointImpl.doPublish(EndpointImpl.java:322)

                                        ... 13 more

                                    Caused by: javax.wsdl.WSDLException: WSDLException (at /definitions/types/xsd:schema): faultCode=PARSER_ERROR: Problem parsing 'newbook_Output.xsd'.: java.io.FileNotFoundException: L:\jboss-as-7.1.1.Final\bin\newbook_Output.xsd (Impossibile trovare il file specificato)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.getDocument(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseTypes(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseDefinitions(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(Unknown Source)

                                        at org.apache.cxf.wsdl11.WSDLManagerImpl.loadDefinition(WSDLManagerImpl.java:242)

                                        at org.apache.cxf.wsdl11.WSDLManagerImpl.getDefinition(WSDLManagerImpl.java:191)

                                        at org.apache.cxf.wsdl11.WSDLServiceFactory.<init>(WSDLServiceFactory.java:92)

                                        ... 22 more

                                    Caused by: java.io.FileNotFoundException: L:\jboss-as-7.1.1.Final\bin\newbook_Output.xsd (Impossibile trovare il file specificato)

                                        at java.io.FileInputStream.open(Native Method) [rt.jar:1.6.0_04]

                                        at java.io.FileInputStream.<init>(FileInputStream.java:106) [rt.jar:1.6.0_04]

                                        at java.io.FileInputStream.<init>(FileInputStream.java:66) [rt.jar:1.6.0_04]

                                        at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:70) [rt.jar:1.6.0_04]

                                        at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:161) [rt.jar:1.6.0_04]

                                        at org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(XMLEntityManager.java:962)

                                        at org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(XMLVersionDetector.java:143)

                                        at org.apache.xerces.parsers.XML11Configuration.parse(XML11Configuration.java:802)

                                        at org.apache.xerces.parsers.XML11Configuration.parse(XML11Configuration.java:768)

                                        at org.apache.xerces.parsers.XMLParser.parse(XMLParser.java:108)

                                        at org.apache.xerces.parsers.DOMParser.parse(DOMParser.java:230)

                                        at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:285)

                                        ... 32 more

                                     

                                    It appears it misses to add the required XSD to the WAR so some vodoo still needed.

                                    Than I added the missing XSD in the WSDL folder but ...

                                     

                                    12:47:43,648 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC00001: Failed to start service jboss.deployment.unit."bookdb.war".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."bookdb.war".INSTALL: Failed to process phase INSTALL of deployment "bookdb.war"

                                        at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]

                                        at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                                        at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                                        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_04]

                                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_04]

                                        at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

                                    Caused by: javax.xml.ws.WebServiceException: org.apache.cxf.service.factory.ServiceConstructionException: Failed to create service.

                                        at org.apache.cxf.jaxws.EndpointImpl.doPublish(EndpointImpl.java:350)

                                        at org.jboss.wsf.stack.cxf.deployment.EndpointImpl.doPublish(EndpointImpl.java:88)

                                        at org.apache.cxf.jaxws.EndpointImpl.publish(EndpointImpl.java:239)

                                        at org.apache.cxf.jaxws.EndpointImpl.publish(EndpointImpl.java:509)

                                        at org.jboss.wsf.stack.cxf.configuration.NonSpringBusHolder.configure(NonSpringBusHolder.java:117)

                                        at org.jboss.wsf.stack.cxf.deployment.aspect.BusDeploymentAspect.startDeploymentBus(BusDeploymentAspect.java:113)

                                        at org.jboss.wsf.stack.cxf.deployment.aspect.BusDeploymentAspect.start(BusDeploymentAspect.java:66)

                                        at org.jboss.as.webservices.deployers.AspectDeploymentProcessor.deploy(AspectDeploymentProcessor.java:74)

                                        at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]

                                        ... 5 more

                                    Caused by: org.apache.cxf.service.factory.ServiceConstructionException: Failed to create service.

                                        at org.apache.cxf.wsdl11.WSDLServiceFactory.<init>(WSDLServiceFactory.java:94)

                                        at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.buildServiceFromWSDL(ReflectionServiceFactoryBean.java:369)

                                        at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.initializeServiceModel(ReflectionServiceFactoryBean.java:505)

                                        at org.apache.cxf.service.factory.ReflectionServiceFactoryBean.create(ReflectionServiceFactoryBean.java:241)

                                        at org.apache.cxf.jaxws.support.JaxWsServiceFactoryBean.create(JaxWsServiceFactoryBean.java:205)

                                        at org.apache.cxf.frontend.AbstractWSDLBasedEndpointFactory.createEndpoint(AbstractWSDLBasedEndpointFactory.java:101)

                                        at org.apache.cxf.frontend.ServerFactoryBean.create(ServerFactoryBean.java:157)

                                        at org.apache.cxf.jaxws.JaxWsServerFactoryBean.create(JaxWsServerFactoryBean.java:203)

                                        at org.apache.cxf.jaxws.EndpointImpl.getServer(EndpointImpl.java:433)

                                        at org.apache.cxf.jaxws.EndpointImpl.doPublish(EndpointImpl.java:322)

                                        ... 13 more

                                    Caused by: javax.wsdl.WSDLException: WSDLException (at /definitions/types/xsd:schema/xs:schema): faultCode=PARSER_ERROR: Problem parsing 'http://www.metamatrix.com/metamodels/SimpleDatatypes-instance'.: org.xml.sax.SAXParseException: White spaces are required between publicId and systemId.

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.getDocument(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseTypes(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.parseDefinitions(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(Unknown Source)

                                        at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(Unknown Source)

                                        at org.apache.cxf.wsdl11.WSDLManagerImpl.loadDefinition(WSDLManagerImpl.java:242)

                                        at org.apache.cxf.wsdl11.WSDLManagerImpl.getDefinition(WSDLManagerImpl.java:191)

                                        at org.apache.cxf.wsdl11.WSDLServiceFactory.<init>(WSDLServiceFactory.java:92)

                                        ... 22 more

                                    Caused by: org.xml.sax.SAXParseException: White spaces are required between publicId and systemId.

                                        at org.apache.xerces.parsers.DOMParser.parse(DOMParser.java:244)

                                        at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:285)

                                        ... 33 more

                                     

                                     

                                    Sigh    :-(

                                    Luca