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 Apprentice

    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 Apprentice

    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 Apprentice

    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 Apprentice

    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 Apprentice

    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