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.
      • 30. Re: From relational to XML (conforming to xschema)
        shawkins

        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)
          gioppoluca

          Wanderful all runs smoothly now.

          Soon a tutorial on all this.

          Luca

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

            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

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

              Luca,

               

              Yes, Pls see this https://community.jboss.org/docs/DOC-15891

               

              Ramesh..

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

                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)
                  tejones

                  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)
                    rareddy

                    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)
                      rareddy

                      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)
                        gioppoluca

                        Here is the war file.

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

                          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)
                            tejones

                            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)
                              rareddy

                              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)
                                tejones

                                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)
                                  gioppoluca

                                  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)
                                    tejones

                                    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