cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

sql query service. no result in return while calling in mashup

SOLVED
Aquamarine

sql query service. no result in return while calling in mashup

i have an sql query service which returns me an infotable. the service is working fine. when I call the service in my mashup, there is no return data (expecting the result infotable)

1 ACCEPTED SOLUTION

Accepted Solutions

Re: sql query service. no result in return while calling in mashup

the problem was resolved by associating a data shape to the sql service. One important thing that I noted here is that the field definitions on the data shape should match with the database column name. I'm not sure if this is mandatory though

3 REPLIES 3

Re: sql query service. no result in return while calling in mashup

@asekar Is there any error in script or application log? Make sure you have bind the service invoke call with some event to trigger as sometime it happens the required service is not getting invoked/triggered .

 

-Durgesh

Highlighted

Re: sql query service. no result in return while calling in mashup

there isn't any error as such. I brought the same service in mashup but I don't see anything under returned data..

 

What do you mean by invoking the service ? I call the service in mashup which will in turn query from database

Re: sql query service. no result in return while calling in mashup

the problem was resolved by associating a data shape to the sql service. One important thing that I noted here is that the field definitions on the data shape should match with the database column name. I'm not sure if this is mandatory though