Result Not Mapping To OFS Column Name

[ZenithBringer]

Hi,

I have an OFS query that returns a result bu binding it to the result is causing an error.

The dataservice operation

   <operation name="GetAccountBalance">

      <description>Gets the current working balance for the specified account.</description>

      <call-query href="GetAccountBalance">

         <with-param name="id" query-param="id" />

      </call-query>

   </operation>

   

   <query id="GetAccountBalance" useConfig="t24">

      <sql>SELECT SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},%ACCOUNT

                        @ID:EQ  =   set ?1

                 END

        </sql>  

      

      <result element="GetAccountBalanceResponse" rowName="return" defaultNamespace="http://my.namespace">

         <element name="balance" column="ONLINE.ACTUAL.BAL" xsdType="xs:string" />

      </result>

      

      <param name="id" paramType="SCALAR" sqlType="STRING" type="IN" ordinal="1" />

   </query>

Below is the OFS response.

[2012-10-25 12:56:26,014]  INFO -  OFS_RES(c54aa3fb5ec54514,80065ms): ,@ID::Acco

unt Id/ACCOUNT.TITLE.1::Name/MNEMONIC::Mnemonic/ACCOUNT.OFFICER::Account Officer

/CATEGORY::Product/CURRENCY::Ccy/ONLINE.ACTUAL.BAL:CLASS-POSNEG:Online Actual Bal

/LIMIT.REF::Limit Ref/POSTING.RESTRICT::Posting Restrict/INT.NO.BOOKING::Int Bo

oking/CONDITION.GROUP::Condition Group/CATEGORY::Product,"  181016702627"

"HOTEL LIMITED-OPERATIONAL "   "ALHO   "    "BRAN"    "Curr Ac

ct      "       "GHS"   "        -467,986.56"   "    100.01"    "  "    "

 "      "  11"  "  1000"

[2012-10-25 12:56:26,018] ERROR -  DS Fault Message: Error in 'StaticOutputEleme

nt.execute', cannot find Param with type:column name:ONLINE.ACTUAL.BAL

Source Data Service:-

Name: T24Services

Location: C:\wso2\WSO2DA~1.0\bin\..\repository\deployment\server\dataservices\T2

4Services.dbs

Description: Temenos Test for DataServices 2.5.1 for BSL

Default Namespace: http://my.namespace

Current Request Name: GetAccountBalance

Current Params: {id=181016702627}

Any help will be appreciated

Thank you

[Dmitry Lukyanov]

From your message I see the following column headers

@ID::Account Id/
ACCOUNT.TITLE.1::Name/
MNEMONIC::Mnemonic/
ACCOUNT.OFFICER::Account Officer/
CATEGORY::Product/
CURRENCY::Ccy/

ONLINE.ACTUAL.BAL:CLASS-POSNEG:Online Actual Bal/
LIMIT.REF::Limit Ref/
POSTING.RESTRICT::Posting Restrict/
INT.NO.BOOKING::Int Booking/
CONDITION.GROUP::Condition Group/
CATEGORY::Product

From each header the first part of column is taken divided by ::
but `ONLINE.ACTUAL.BAL:CLASS-POSNEG:Online Actual Bal`
does not have :: ...

according to the code you can access this column by full name:
http://code.google.com/p/temenos-ofs-jdbc/source/browse/trunk/src/org/t24/driver/T24ResultSet.java#255

so, this should work:
<element name="balance" column="ONLINE.ACTUAL.BAL:CLASS-POSNEG:Online Actual Bal" xsdType="xs:string" />

if you know, tell me what is it: `CLASS-POSNEG` ?
maybe it's a bug and tokenizer should take name before the first colon.

Dmitry