internetworkers AT lists.ibiblio.org

Subject: Internetworkers: http://www.ibiblio.org/internetworkers/

List archive

Re: [internetworkers] mySql JDBC driver not properly escaping characters

From: Kevin Sonney <ksonney AT gmail.com>
To: "Internetworkers: http://www.ibiblio.org/internetworkers/" <internetworkers AT lists.ibiblio.org>
Subject: Re: [internetworkers] mySql JDBC driver not properly escaping characters
Date: Fri, 20 Aug 2004 10:21:10 -0400

On Fri, 20 Aug 2004 10:01:50 -0400, Tony Spencer <tony AT tonyspencer.com> wrote:
> Isn't it the duty of my JDBC driver to handle proper escaping of characters
> before performing an insert into my mySQl database?

Not if you are building the query/insert as a string and using a
standard Statement object. Using a preparedStatement instead will
allow you to do what you want easily.

--
-- Kevin Sonney
-- ksonney AT gmail.com

[internetworkers] mySql JDBC driver not properly escaping characters, Tony Spencer, 08/20/2004
- Re: [internetworkers] mySql JDBC driver not properly escaping characters, Kevin Sonney, 08/20/2004
  - RE: [internetworkers] mySql JDBC driver not properly escapingcharacters, Tony Spencer, 08/20/2004