I am trying to use sql binding .. I try to retrieve an account info from accounts table based on account_id ... I use a reference and its binding is:
<sca:reference name="GetAccountService" multiplicity="0..1" promote="SimpleRestServiceBean/GetAccountService">
<sca:interface.java interface="com.example.switchyard.switchyard_rest_example.SingleResultQueryService"/>
<sql:binding.sql>
<sql:query>select * from accounts where account_id = #</sql:query>
<sql:dataSourceRef>java:jboss/datasources/pmdmDS</sql:dataSourceRef>
</sql:binding.sql>
</sca:reference>
I can hit the db ok and see the account info retrieved ok. However, I'm having difficulty how to convert (or transform) the query result. When I look into the query result, it is a list of LinkedInsensitiveMap ... The conversion should be done automatically by providing the converter??
Thanks for your help in advance!!
You should be able to use a converter, yes. Can you attach your project?