1 Reply Latest reply on Jun 11, 2013 7:44 AM by Keith Babo

    sql binding question

    seungchan.lee-evault.com Newbie

      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!!