I've tried surrounding the name XML in double quotes ("XML") but that
doesn't work.
It should work. I've used quoting in Derby in similar circumstances quite
successfully. Can you post more details about the exact statement
you issued and the exact error you received?
Note that if you enclose the table or column name in double quotes
you have to get the upper/lower case of the name EXACTLY RIGHT. If
you don't use quotes, table and column names are case-insensitive,
so it is easy to be somewhat inconsistent with upper and lower case,
but when you use quotation marks, you must get it exactly right.
thanks,
bryan
