When I use the SQL/EQSL taglib or the SQL procesor, I get an exception DOM-002: Illegal Character – what does this mean?
Cocoon creates XML elements based on the field names returned in the result set. If these returned field names contain characters that are disallowed by the XML specification, this exception will be thrown. This can happen in two main ways. Firstly, if you use a SQL function such as COUNT, which does not return a literal field, but a calculation. Secondly, if you have non-English characters in your field names (this is probably because some JDBC drivers are not properly internationalised). In both cases, the solution is the same – use the SQL ‘AS’ keyword to rename a field or a calculation to something that is a valid XML element name and only contains English characters. (Make sure to also change your stylesheet, if necessary, to match on the new element name.
Cocoon creates XML elements based on the field names returned in the result set. If these returned field names contain characters that are disallowed by the XML specification, this exception will be thrown. This can happen in two main ways. Firstly, if you use a SQL function such as COUNT, which does not return a literal field, but a calculation. Secondly, if you have non-English characters in your field names (this is probably because some JDBC drivers are not properly internationalised). In both cases, the solution is the same – use the SQL ‘AS’ keyword to rename a field or a calculation to something that is a valid XML element name and only contains English characters.
Related Questions
- When I use the SQL/EQSL taglib or the SQL procesor, I get an exception DOM-002: Illegal Character - what does this mean?
- I get a SQL Exception error from the tray icon of IM Client when I start it the first time. What does that mean?
- After uploading my scans and printing the exception report, what does "inactive barcode " mean?
