Forum Discussion

fredzhu's avatar
New Contributor
12 months ago

How to get blank when JDBC step return xml empty element like <key/>

GetKey-JDBCRequest read data from DB, normally we get results like


<ResultSet fetchSize="128">

<Row rowNumber="1">






<Key>123</Key> means value:123, then we use  '${GetKey-JDBCRequest#ResponseAsXml#//Results[1]/ResultSet[1]/Row[1]/Key[1]}' for next step


But when it returns empty result, it becomes

<Key/>   instead of <Key></Key> so that  value of '${GetKey-JDBCRequest#ResponseAsXml#//Results[1]/ResultSet[1]/Row[1]/Key[1]}' is NOT "" but "</Key>"

That's not the result we want.


How to get correct blank/empty result and avoid the wrong one? I don't want to use Groovy to parse the value, is there any simple way to deal with it?

Like change a setting and force to output xml format as <Key></Key>, or a simple function to read out "" instead of "</Key>"


Thanks a lot

No RepliesBe the first to reply