13 Replies Latest reply on Jul 29, 2013 3:42 PM by Ramesh Reddy

    facing issue in exposing the VDB as web services

    forgetarun Newbie

      Am using Teiid 7.7.5 + Teiid Designer : 8.1.0.


      Hav created a VDB connecting to MySQL DB. Able to deploy VDB and the CXF WAR successfully. Able to access the WSDL file via endpoint. But getting the below error while trying to consume the service from a client.



      Exception in thread "main" org.apache.axis2.AxisFault: 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 '.getTest_Test('<?xml version="1.0" encoding="UTF-8"?><ns1:Test_Test_Input xmln' at line 1

      at org.apache.axis2.util.Utils.getInboundFaultFromMessageContext(Utils.java:531)

      at org.apache.axis2.description.OutInAxisOperationClient.handleResponse(OutInAxisOperation.java:375)

      at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:421)

      at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)

      at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)

      at org.teiid.NewVDBStub.getTest_Test(NewVDBStub.java:182)

      at com.abc.service.TestClient.main(TestClient.java:16)