WSO2 DSS: Issue in Creating Data services using an oracle Stored Procedure with Ref Cursor and other Scalar out parameter -

-

i learning wso2 dss. trying implement 1 of use case using dss , oracle stored procedure.

oracle stored procedure using has 1 input parameter , 2 scalar out parameter while 1 ref cursor.

database script

create table dss_dept     (         dept_id   varchar2(10),         dept_name varchar2(10)     );  create table dss_emp     (         emp_id varchar2(10),         fname  varchar2(10),         lname  varchar2(10),         title  varchar2(10)     );  create table dss_emp_dept     (         dept_id varchar2(10),         emp_id  varchar2(10)     );  create or replace procedure get_emp_data(         p_emp_id in dss_emp.emp_id%type,         p_emp_fname out dss_emp.fname%type,         p_emp_lname out dss_emp.lname%type,         p_dep_rset out sys_refcursor ) begin      select fname,         lname     p_emp_fname ,         p_emp_lname     dss_emp     emp_id = p_emp_id;      open p_dep_rset select dept_id dss_emp_dept emp_id = p_emp_id;  end; /

data insert script

insert dss_dept (dept_id,dept_name) values ('inv','inventory'); insert dss_dept (dept_id,dept_name) values ('sal','sales');   insert dss_emp (emp_id,fname,lname,title) values ('2','alpesh','b','se'); insert dss_emp (emp_id,fname,lname,title) values ('1','alps','b','se');  insert dss_emp_dept (dept_id,emp_id) values ('sal','1'); insert dss_emp_dept (dept_id,emp_id) values ('inv','2'); insert dss_emp_dept (dept_id,emp_id) values ('sal','2'); commit;

dss configuration:

<data name="mydsstest" transports="http https local">    <description>testing wso2 dss oracle</description>    <config enableodata="false" id="dbtest">       <property name="carbon_datasource_name">dbtest</property>    </config>    <query id="getempdata_qry" useconfig="edbtest">       <sql>call get_emp_data (:p_emp_id ,:p_emp_fname,:p_emp_lname,:p_dep_rset)</sql>       <result element="employees" rowname="employee">          <element name="p_emp_id" query-param="p_emp_id" xsdtype="string"/>          <element column="p_emp_fname" name="p_emp_fname" xsdtype="string"/>          <element column="p_emp_lname" name="p_emp_lname" xsdtype="string"/>          <element column="dept_id" name="dept_id" xsdtype="string"/>       </result>       <param name="p_emp_id" sqltype="string"/>       <param name="p_emp_fname" sqltype="string" type="out"/>       <param name="p_emp_lname" sqltype="string" type="out"/>       <param name="p_dep_rset" sqltype="oracle_ref_cursor" type="out"/>    </query>    <operation name="getempdata">       <call-query href="getempdata_qry">          <with-param name="p_emp_id" query-param="p_emp_id"/>       </call-query>    </operation>    <resource method="get" path="getempdata/{p_emp_id}">       <call-query href="getempdata_qry">          <with-param name="p_emp_id" query-param="p_emp_id"/>       </call-query>    </resource> </data>

result of rest call

<employees>   <employee>     <p_emp_id>2</p_emp_id>     <p_emp_fname>alpesh2</p_emp_fname>     <p_emp_lname>bhalodia2</p_emp_lname>     <dept_id>inv</dept_id>   </employee>   <employee>     <p_emp_id>2</p_emp_id>     <p_emp_fname>alpesh2</p_emp_fname>     <p_emp_lname>bhalodia2</p_emp_lname>     <dept_id>sal</dept_id>   </employee> </employees>

result format want

<employees>   <employee>     <p_emp_id>2</p_emp_id>     <p_emp_fname>alpesh2</p_emp_fname>     <p_emp_lname>bhalodia2</p_emp_lname>     <depts>       <dept_id>inv</dept_id>       <dept_id>sal</dept_id>     </depts>   </employee> </employees>

i want department values cursor exported complex element show above. tried different type of combination in setting output mapping in dss nothing worked.

i know can achieved using xslt on top of results don't want that.

am doing wrong in setting output mapping? how export cursor result array in dss?

this expected behavior. each dept_id in there employee row in result set.


Comments

Post a Comment

Popular posts from this blog

ios - Memory not freeing up after popping viewcontroller using ARC -

-
hi project arc based, using uinavigationcontroller make transition between viewcontroller. using profiler analyse happening behind scene memory. noticed when push viewcontroller allocate memory components , when pop not freeing allocated memory. since using arc unable implement dealloc or release component. have analysed in detail , there no memory leak in project. i not using strong property push viewcontroller. here how pushing viewcontroller. viewcontroller *obj = [[viewcontroller alloc] init]; [self.navigationcontroller pushviewcontroller:obj animated:no]; any clue whats going on? should free memory have consumed. please advise your description indicates have retain cycle, leads objects not being deallocated. typical source of retain cycles properties assigned loading nib files (usually declared iboutlet ). two strategies break them , release objects: declare property weak : @property (nonatomic, weak) iboutlet uilabel *statuslabel; set property nil in...
Read more

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more