1 2 3 4 5 Previous Next 66 Replies Latest reply: Oct 12, 2012 12:35 PM by Ramesh Reddy Go to original post Branched to a new discussion. RSS
      • 30. Re: From relational to XML (conforming to xschema)
        Steven Hawkins Master

        Luca,

         

        Now we are finally to a someone else's issue.  Squirrel does not handle the SQL/XML type, so instead it's showing you the jdbc type code 2009.  You could workaround this with "SELECT XMLSERIALIZE("xml" AS CLOB) FROM (SELECT * FROM libro.bookListingDocument) AS x", that would give you a clob instead.

         

        Steve

        • 31. Re: From relational to XML (conforming to xschema)
          luca gioppo Novice

          Wanderful all runs smoothly now.

          Soon a tutorial on all this.

          Luca

          • 32. Re: From relational to XML (conforming to xschema)
            luca gioppo Novice

            Another question on this topic.

            Should I want to publish the XML from a web service?

            How can I get the XML document and create a data service?

            Is it possible?

            Thanks

            Luca

            • 34. Re: From relational to XML (conforming to xschema)
              luca gioppo Novice

              I've run into another problem:

               

              11:29:58,953 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB libri.1 is set to "active"

              11:29:58,984 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-1) Add Service

              id=libro_bookListingDocument

              address=http://localhost:8080/libri/libro_bookListingDocument

              implementor=org.teiid.soap.provider.libro_bookListingDocument

              invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

              serviceName={http://teiid.org}libri

              portName={http://teiid.org}libro_bookListingDocument

              wsdlLocation=null

              mtomEnabled=false

              11:29:58,984 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-1) Add Service

              id=local_book_aria_authors

              address=http://localhost:8080/libri/local_book_aria_authors

              implementor=org.teiid.soap.provider.local_book_aria_authors

              invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

              serviceName={http://teiid.org}libri

              portName={http://teiid.org}local_book_aria_authors

              wsdlLocation=null

              mtomEnabled=false

              11:29:59,000 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-1) Add Service

              id=local_book_aria_books

              address=http://localhost:8080/libri/local_book_aria_books

              implementor=org.teiid.soap.provider.local_book_aria_books

              invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

              serviceName={http://teiid.org}libri

              portName={http://teiid.org}local_book_aria_books

              wsdlLocation=null

              mtomEnabled=false

              11:29:59,000 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-1) Add Service

              id=local_book_aria_book_authors

              address=http://localhost:8080/libri/local_book_aria_book_authors

              implementor=org.teiid.soap.provider.local_book_aria_book_authors

              invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

              serviceName={http://teiid.org}libri

              portName={http://teiid.org}local_book_aria_book_authors

              wsdlLocation=null

              mtomEnabled=false

              11:29:59,000 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-1) Add Service

              id=local_book_aria_publishers

              address=http://localhost:8080/libri/local_book_aria_publishers

              implementor=org.teiid.soap.provider.local_book_aria_publishers

              invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

              serviceName={http://teiid.org}libri

              portName={http://teiid.org}local_book_aria_publishers

              wsdlLocation=null

              mtomEnabled=false

              11:29:59,953 INFO  [org.apache.cxf.service.factory.ReflectionServiceFactoryBean] (MSC service thread 1-1) Creating Service {http://teiid.org}libri from WSDL: libri.wsdl

              11:30:01,046 INFO  [org.apache.cxf.endpoint.ServerImpl] (MSC service thread 1-1) Setting the server's publish address to be http://localhost:8080/libri/libro_bookListingDocument

              11:30:01,328 INFO  [org.jboss.wsf.stack.cxf.deployment.WSDLFilePublisher] (MSC service thread 1-1) WSDL published to: file:/L:/jboss-as-7.1.1.Final/standalone/data/wsdl/libri.war/libri.wsdl

              11:30:01,375 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-1) MSC00001: Failed to start service jboss.deployment.unit."libri.war".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."libri.war".INSTALL: Failed to process phase INSTALL of deployment "libri.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: java.lang.RuntimeException: Cannot publish wsdl to: L:\jboss-as-7.1.1.Final\standalone\data\wsdl\libri.war\libri.wsdl

                  at org.jboss.wsf.stack.cxf.deployment.WSDLFilePublisher.publishWsdlFiles(WSDLFilePublisher.java:107)

                  at org.jboss.wsf.stack.cxf.deployment.EndpointImpl.publishContractToFilesystem(EndpointImpl.java:222)

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

                  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: java.io.IOException: Could not find WEB-INF/wsdl/Books.xsd in the additional metadatafiles!

                  at org.jboss.ws.common.deployment.ResourceResolverImpl.resolve(ResourceResolverImpl.java:124)

                  at org.jboss.ws.common.utils.AbstractWSDLFilePublisher.publishSchemaImports(AbstractWSDLFilePublisher.java:223)

                  at org.jboss.ws.common.utils.AbstractWSDLFilePublisher.publishSchemaImports(AbstractWSDLFilePublisher.java:250)

                  at org.jboss.ws.common.utils.AbstractWSDLFilePublisher.publishSchemaImports(AbstractWSDLFilePublisher.java:250)

                  at org.jboss.wsf.stack.cxf.deployment.WSDLFilePublisher.publishWsdlFiles(WSDLFilePublisher.java:94)

                  ... 14 more

               

              Obviously I had to follow something different from the example since is only possible to create a WS from a relational model and not from an XML one (Why????)

              So I generated a WS from the original relational model and than added an operation and addedd the XML element as outputdata adn so on.

              Doing so (and after forcing eclipse to use JDK and not JRE) I generated the WAR.

              Do not know if it needs a VBD deployed (I suppose so since in the war there are no VBD stuff around) so left the VDB deployed and added the war on my deployment folder in the standalone (I've not yet had the heart to try clustered env).

              The result is that above.

              It seems that it cannot find that damn XSD.

              Let me know

               

              As usual:

              AS 7.1.1, TEIID 8.0, TEIID designer 7.6

              Thanks

              Luca

               

              P.S.

              if you need the war let me know

              • 35. Re: From relational to XML (conforming to xschema)
                Ted Jones Expert

                Luca,

                 

                The generated WAR has not been tested with JBossWS-CXF 4.x, which I believe is the default version with AS 7. If you want to give me the WAR, I can modify it's contents to work with that version. I will also modify the generation process to allow for different targeted CXF versions for the next release.

                 

                Thanks,

                Ted

                • 36. Re: From relational to XML (conforming to xschema)
                  Ramesh Reddy Master

                  Luca,

                   

                  Can you do a quick test and see if this WAR works in Teiid 7.7 with JBoss AS 5.1.0?

                   

                  Ramesh..

                  • 37. Re: From relational to XML (conforming to xschema)
                    Ramesh Reddy Master

                    Luca,

                    Obviously I had to follow something different from the example since is only possible to create a WS from a relational model and not from an XML one (Why????)

                    That seems to be a defect, can log JIRA on Teiid Designer. If not we will clarify why that is not supported there.

                     

                    Do not know if it needs a VBD deployed (I suppose so since in the war there are no VBD stuff around) so left the VDB deployed and added the war on my deployment folder in the standalone (I've not yet had the heart to try clustered env).

                    P.S.

                    if you need the war let me know

                    Yes, VDB still need to be deployed. VDB will act as source the webservice. yes, please attach the WAR file, I can test it.

                     

                    Ramesh..

                    • 38. Re: From relational to XML (conforming to xschema)
                      luca gioppo Novice

                      Here is the war file.

                      • 39. Re: From relational to XML (conforming to xschema)
                        Ted Jones Expert

                        Thanks Luca. The war deploys successfully on AS 5.1 with Teiid 7.7. I will make the changes required to deploy to JBossWS-CXF 4.x and repost the war.

                         

                        Ted

                        • 40. Re: From relational to XML (conforming to xschema)
                          Ted Jones Expert

                          Luca,

                           

                          The attached war deploys on AS 7.1.1 using JBossWS-CXF 4.x. The difference is that the WSDL is expected to be in WEB-INF/wsdl.

                           

                          As I said, this will be corrected in the next release of Teiid Designer. Here is the Jira if you would like to follow: https://issues.jboss.org/browse/TEIIDDES-1141

                           

                          Thanks,

                          Ted

                          • 41. Re: From relational to XML (conforming to xschema)
                            Ramesh Reddy Master

                            Ted,

                             

                            Thanks. Is moving of the WSDL file under "WEB-INF/wsdl" directory along with any ".xsd" is all that needed to make it work in JBoss AS7 which uses the JBoss-cxf 4.0.x? That way if anybody else want to rebuild mean while Teiid Designer fixed they can do that.

                             

                            Also, do you know if the WAR with the new directory structure works in CXF 3.2 which we recommend for JBoss 5.1.0?

                             

                            Ramesh..

                            • 42. Re: From relational to XML (conforming to xschema)
                              Ted Jones Expert

                              Ramesh,

                               

                              Yes... moving the WSDL and ".xsd" under "WEB-INF/wsdl" is all that is needed for AS 7 with JBossWS-CXF 4.x.

                               

                              This structure does not work with JBossWS-CXF 3.2 on AS 5.1.0 however. The solution may be to be to add an option to target a version in the WAR generation wizard and build accordingly. Unless I can build a WAR that works on both versions, which is ideal.

                               

                              Thanks,

                              Ted

                              • 43. Re: From relational to XML (conforming to xschema)
                                luca gioppo Novice

                                Still no luck

                                The strange thing is that it complains on a mySQL error, but the requested method call the XML document that map the MySQL DB and that mapping works since if I call the VDB from squirrel it returns the XML document.

                                It seems a problem in the connection between the WS and the XML document.

                                Consider that I had to create the WS starting from the relational MySQL model and than added the operation for using also the XML model (hoping of having done things correctly, thing that I start to doubt).

                                For this reason I propose to make a couple of steps behind.

                                How to create a WS from a XML document model?

                                If I do a left click under modelling there is no option for generation WS.

                                Could this be the problem?

                                 

                                 

                                15:22:11,080 GRAVE [org.teiid.soap] (http--127.0.0.1-8080-1) Exception in executeDataservice: {0}: java.lang.Throwable: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null()' at line 1

                                    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: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null()' at line 1

                                    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

                                    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

                                    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)

                                    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)

                                    at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)

                                    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)

                                    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:794)

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

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

                                    ... 41 more

                                 

                                15:22:11,267 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: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null()' at line 1

                                    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: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null()' at line 1

                                    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

                                 

                                15:22:11,330 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: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null()' at line 1

                                    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: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null()' at line 1

                                    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

                                • 44. Re: From relational to XML (conforming to xschema)
                                  Ted Jones Expert

                                  Luca,

                                   

                                  You are so close! You are getting the MySQL error because the JNDI name you used for WAR generation is the underying MySQL datasource. Its JNDI name should represent the connection to your VDB, not the underlying source. So, create a datasource for your VDB (you can do this from Designer by right-clicking on the VDB in the Teiid view and selecting "Create Data Source"), then whatever JNDI name you usefor that just update the teiidsoap.properties file (in the classes directory of the war and also in the WEB-INF/wsdl directory in your case) with that value. That way you won't have to regenerate the WAR.

                                   

                                  As far as web service models for XML document models, we don't support that yet but if you want to log a Jira for it, we would be glad to make it happen.

                                   

                                  Thanks,

                                  Ted