Koopman_Interna
14 years agoContributor
To entitize or not to entitize JDBC result
I am comparing the contents of 2 tables by looping through one of them (JDBC datasource) and fetching the corresponding record from the other table by key with a JDBC fetch request.
The JDBC fetch results seems to entitize the result when a & is in the string. For example:
So to get the test working, I also set Entitize to on for the JDBC Data Source.
But when an apostrophe is part of the string, the JDBC request does not entitize it:
But the JDBC datasource is entitizing as follows:
Z's Trading Company Limited
Questions:
- Is this a bug in entitizing?
- Is there a way to not entitize the result of a JDBC request?
The JDBC fetch results seems to entitize the result when a & is in the string. For example:
<Results>
<ResultSet fetchSize="0">
<Row rowNumber="1">
<SUPPLIER_ID>2335</SUPPLIER_ID>
<NAME>Example Arts & Crafts Imp. & Exp Corp.</NAME>
</Row>
</ResultSet>
</Results>
So to get the test working, I also set Entitize to on for the JDBC Data Source.
But when an apostrophe is part of the string, the JDBC request does not entitize it:
<Results>
<ResultSet fetchSize="0">
<Row rowNumber="1">
<SUPPLIER_ID>2386</SUPPLIER_ID>
<NAME>Z's Trading Company Limited </NAME>
</Row>
</ResultSet>
</Results>
But the JDBC datasource is entitizing as follows:
Z's Trading Company Limited
Questions:
- Is this a bug in entitizing?
- Is there a way to not entitize the result of a JDBC request?