John,
Yes, I'm set for now. Thanks. Is the difference between execute and executeQuery going to break someone else's use?
The only problem I think may exist is that executeQuery may limit you to a single ResultSet. What I plan to do is, use the execute function
if multiple-results-set has been enabled and executeQuery if it is
disabled. The default is disabled, so it should work fine for everyone.
BTW, I've another mod to the Xalan.jar which you might want to know about, but not include. It turns out that early versions of our application allowed users to inadvertently enter "bad" characters (0x00,0x01,...) into certain fields in the database. For the most part they are at the end of strings and are otherwise invisible to users. However, From the database they can be selected into variables in Xalan and written to an XML file. XML files with "bad" characters cannot be opened by Xalan/Xerces! So I've hacked org.apache.xalan.xslt.Process to filter the "bad" characters on the way in.
I have actually seen this problem, someone was entering data into a
MSSQL Server through a linked table in Access. The text for their description columns originated from a .txt file that was opened in
Wordpad. When the data was inserted, some of the characters such as
quote were stored as some Windows font char. When the query was executed,
Xalan would happily reproduce the bad characters but when the XML stream
was delivered to the next process, we got this message "Invalid byte 1 of 1-byte UTF-8 sequence". Needless to say to took a while to debug.
We just corrected the data because I was surprised that MSSQL actually allowed binary data in a varchar field and unsure what type of filter to implement that would not kill performance.
Regards John G
Regards, Phil Friedman - Terralink Software - 1-207-772-6500 x101
John Gentilin wrote:
Phil,
Thank you for the remote debugging effort. My in box is a bit stacked up at
the moment, can I assume that you can proceed with your modified copy. I
noted the change and will make it official in a week or so. If you can,
add the bug into Bugzilla, cc me, I will close it once the change
is implemented.
Regards John G Phil Friedman wrote:
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
