facing issue in exposing the VDB as web services

[forgetarun]

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)

[rareddy]

I suggest you try to access the WebService first with tools like SOAP-UI, then once you make sure that that is working then try your own client.

Ramesh..

[forgetarun]

Hi Ramesh,

Thanks. Hav tried that but still facing the same issue.

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

   <soap:Body>

      <soap:Fault>

         <faultcode>soap:Server</faultcode>

         <faultstring>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"?><tes:Test_Test_Input xmln' at line 1</faultstring>

      </soap:Fault>

   </soap:Body>

</soap:Envelope>

[shawkins]

The error message suggests that the datasource you are accessing is MySQL and not Teiid.  You'll want to make sure that the JNDI name the WAR is using is correct.

Steve

[forgetarun]

Hi Steve,

Checked it. JNDI name in teiidsoap.properties (inside WAR file) and the JNDI name of the VDB are same.

Arun.

[shawkins]

Just to clarify what are your Teiid vdb and MySQL JNDI names and what is the JNDI name in the teiidsoap.properties?

[rareddy]

1) teiidsoap.properties should have JNDI name that points to the Teiid as the data source with given VDB name, and the data source configuration in the standalone-teiid.xml file.

2) There should be another JNDI name for mysql used in the VDB file, with its corresponding configuration in the standalone-teiid.xml file.

we think you have (2) JNDI name in the teiidsoap.properties, which is not correct.

[forgetarun]

Hi Ramesh/Steve,

Thanks for your help. I was able to resolve it by redoing the entire thing again in Eclipse Juno+Teiid Designer 8.1.0.

Earlier was using JBoss studio 4.1.2 + Teiid Designer 8.2...faced problems in generating a deployable war file so switched to Eclipse Juno. After getting the mysql problem , I redid from scratch on Eclipse.

Thanks again.

Arun.

[forgetarun]

found the problem while trying to create project, somehow the data source xml generated for the VDB and the DB both had MySQL configuration.

That is the below was present in the VDB's datasource xml

<driver-class>com.mysql.jdbc.Driver</driver-class>

<connection-url>jdbc:mysql://hostname:port/database</connection-url>

instead of 

<driver-class>org.teiid.jdbc.TeiidDriver</driver-class>

<connection-url>jdbc:teiid:abcws@mm://localhost:31000</connection-url>

Arun.

[shawkins]

It's not required, but you can improve performance by using a local connection (dropping the host/port - jdbc:teiid:abcws) if your Teiid instance is in the same VM as the WAR.

[rareddy]

if I created "local" connection with passthrough (I had http basic turned on the web service WAR) the REST framework was failing that it needs remote connection. I have to redo example to capture the exact error, it looked like during the deployment of the WAR file, it tries to make connection and since it is passthrough, it does not have any credentials and fails. I am not sure what is need to make connection to Teiid during the deployment of WAR?

[shawkins]

> I am not sure what is need to make connection to Teiid during the deployment of WAR

You were getting that error even with a min pool size of 0?  If so then yes that does seem odd that a connection is being obtained during deployment.  Can we determine why this is happening and if an anonymous connection is needed as a fall-back?

[rareddy]

Good point, I did not pay attention to "min-pool" size, either way the exception message was saying to not to use "passthrough", which I thought was odd. It was on Van's machine I need to re-create the example on my machine.

Ramesh..

[rareddy]

Ok, it was my mistake on the above. I had forgotten that when the "passthough" is turned on "local" connections, the "embedded" transport must be configured with a "security-domain" (by default, it does not) thus the above suspicious error, which is correct.