Hey guys,
I am not sure if anyone using MS SQL server :) but
I get an SQL error when there is a ' (single quote)
symbol in the log message, I cant format it in my code
because the message comes from Tomcat.
Error looks like:
log4j:ERROR Failed to excute sql
java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC][SQLServer]Lin
e 1: Incorrect syntax near 'org'.
at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source
)
at
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
....................
Any ideas? I know that in order to insert a single
quote into MS SQL it needs to be escaped, is there a
switch to enable than in log4j?
Thanks,
Fedor
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
