tag:blogger.com,1999:blog-9023262881452307990.post1599357364772699759..comments2016-02-22T09:11:15.562-08:00Comments on Dinusha's Blog: How to use result of a one operation as input to another operation using WSO2 Data Services Server ?Dinushahttp://www.blogger.com/profile/08040437234230433433noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-9023262881452307990.post-43331366154977200852015-05-10T08:27:17.431-07:002015-05-10T08:27:17.431-07:00This is a very helpful post, thanks very much. The...This is a very helpful post, thanks very much. The only question I had outstanding was how to use Boxcar from a service call. For those with the same question, there are new operations added to your service, simply call Begin before your operations and End when done or Abort if you wish to roll back.Anonymoushttps://www.blogger.com/profile/03426796865873494551noreply@blogger.comtag:blogger.com,1999:blog-9023262881452307990.post-31041135787044304412013-05-02T00:04:45.683-07:002013-05-02T00:04:45.683-07:00Hi Dinusha,
I am using Mac-Os(10.7.5) and WSO2 ES...Hi Dinusha,<br /><br />I am using Mac-Os(10.7.5) and WSO2 ESB 4.0.3 and in this added DataService Hosting3.2.2 feature. <br />I have one query which I am using to create data service(Using TeraData as Db):<br /><br />SELECT a.TNr,<br />c.DNr,<br />b.EventName,<br />b.EVENT_DATE_GMT,<br />b.RCd,<br />b.RDesc<br />FROM LOGISTICS.ST a<br />INNER JOIN<br />LOGISTICS.ACT b ON (b.SId=a.SId)<br />INNER JOIN<br />SupplyChain.Dnumber c ON (c.Id=b.SId)<br />WHERE b.EventPhase_Cd='Actual' AND b.Rcd IS NOT NULL AND c.DNr='XXXXXXXX' or<br />TNr = 'XXXXXXXXX'QUALIFY Row_number() OVER (PARTITION BY b.SId ORDER BY b.EVENT_DATE_GMT Desc)=1<br /><br />and giving all the selected item's present in query as output mapping.<br />Added TeraJdbc4_All.jar and tdgssconfig.jar in /repository/components/lib.<br /><br />But while trying to run it's giving following error.<br />"Input stream is null" in "tryIt" response window<br />and in terminal"Polling prepared statement failed"<br /><br />Please help me on this.<br />It's urgent.<br /><br />Thanks,<br />Saurabh SumanTesthttps://www.blogger.com/profile/06399151377617324834noreply@blogger.comtag:blogger.com,1999:blog-9023262881452307990.post-9874834862465294382013-04-03T06:03:17.831-07:002013-04-03T06:03:17.831-07:00Hi Dinusha,
I have one Query
Here i am sending th...Hi Dinusha,<br /><br />I have one Query<br />Here i am sending the my GIT URL which contain my Query<br /><br />https://gist.github.com/anonymous/5300686<br /><br />Could you please help me.<br />Thanks in Advance<br />Anil<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9023262881452307990.post-44144530356197143012012-07-28T21:51:21.267-07:002012-07-28T21:51:21.267-07:00Hi,
In try-it you need to pass them as separate e...Hi,<br /><br />In try-it you need to pass them as separate elements by repeating the 'employeeNumbers' parameter. Please refer to the "Array representation in the message" section in the following document [1]. It shows exactly what you need.<br /><br />[1] http://wso2.org/project/data-services/2.6.3/docs/array_data_type.htmlDinushahttps://www.blogger.com/profile/08040437234230433433noreply@blogger.comtag:blogger.com,1999:blog-9023262881452307990.post-80743216564921129962012-07-27T07:22:04.289-07:002012-07-27T07:22:04.289-07:00Hi Dinusha,
your blog is very useful.I have a que...Hi Dinusha,<br /><br />your blog is very useful.I have a question,I wanted to know how to pass the input parameter which has multiple values<br /><br />example: employee id is the input and it has multiple values.<br /><br />Query:select empname,mail_id from employee where empid in('vs23445','bk55576') groupby empname;<br /><br />I tried declaring the emp id as below in wso2esb-datasource<br /><br />param name="employeeNumbers" paramType="ARRAY" sqlType="INTEGER" type="IN" ordinal="1" <br /><br /><br />but not sure how to pass the values in Try it(comma separated ,separate param)<br /><br />The service is HTTP GET() request.Anonymousnoreply@blogger.com