Forum Discussion

Lens's avatar
Lens
Occasional Contributor
16 years ago

Datasource - JDBC - read in value of xml-type

Hi,

I'm trying to read a field of a table who has the value of a xml-type.

My driver and connection string are correctely filled in.
It is possible to read other fields (ex: select BALANCEOBJECTID from MOB_FU_CATALOG_B where BALANCEOBJECTID = 'BSCS24432443' --> BSCS24432443)

For the field (xmlchunk) with the xml-type, I use this statement:
select extract(XMLCHUNK,'/').getStringVal() from MOB_FU_CATALOG_B where BALANCEOBJECTID = 'BSCS24432443'

For the tool Oracle SQL+, it works and give me this result:

SQL> select extract(XMLCHUNK,'/').getStringVal() from MOB_FU_CATALOG_B where BALANCEOBJECTID = 'BSCS
24432443';

EXTRACT(XMLCHUNK,'/').GETSTRINGVAL()
--------------------------------------------------------------------------------
tp://mobistar.be/Common/v1" xmlns:fra="http://mobistar.be/Framework/v1" xmlns:ow
n="http://mobistar.be/own" xmlns:pro="http://mobistar.be/Customer/ProductDefinit
ion/v1" xmlns:qua="http://mobistar.be/Common/Quantity/v1" xmlns:xsi="http://www.
w3.org/2001/XMLSchema-instance">BSCS24432443>BalanceDefinition
uagestrings>My10F
R
My10om1:String>EN
string>My10NL
nguagestring>My10

EXTRACT(XMLCHUNK,'/').GETSTRINGVAL()
--------------------------------------------------------------------------------
DE
Bundle<>
ConsumptionMetric>Monetary<>
Metric>Monetary8.2645BaseC
urrency
8.26
al>Contracttrue
itialAmount>0<>
AmountUnit/>
T>8.2645

EXTRACT(XMLCHUNK,'/').GETSTRINGVAL()
--------------------------------------------------------------------------------
nt/>
21

wn:label lang="de">My10

ority>45



When I run the datasource, it gives me a blanco value.
The soapUI-log tells me that he got 1 row (Wed Apr 15 14:50:57 CEST 2009:INFO:Got 1 columns from resultset).

Can someone help me with this problem?

Regards,
Benny

2 Replies

  • manishgi's avatar
    manishgi
    Occasional Contributor

    I am also facing same issue, please suggest if there is any solution for this problem or it is a defect of soapui.

    • nmrao's avatar
      nmrao
      Champion Level 3
      Suggest you not to cross post. May be you can open a fresh topic with details.