Datasource - JDBC - read in value of xml-type

[Lens]

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
RMy10om1:String>EN
string>My10NLnguagestring>My10

EXTRACT(XMLCHUNK,'/').GETSTRINGVAL()
--------------------------------------------------------------------------------
DEBundle<>
ConsumptionMetric>Monetary<>
Metric>Monetary8.2645BaseC
urrency8.26al>Contracttrue
itialAmount>0<>
AmountUnit/>
T>8.2645

EXTRACT(XMLCHUNK,'/').GETSTRINGVAL()
--------------------------------------------------------------------------------
nt/>21My10My10
wn:label lang="de">My10My10
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

[manishgi]

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

[nmrao]

Suggest you not to cross post. May be you can open a fresh topic with details.