[32721] in bugtraq
Re: Intresting case of SQL Injection
daemon@ATHENA.MIT.EDU (Florian Weimer)
Fri Dec 5 16:58:17 2003
Date: Fri, 5 Dec 2003 22:18:30 +0100
To: "Scovetta, Michael V" <Michael.Scovetta@ca.com>
Cc: "Martin Sarsale (runa@sytes)" <runa@runa.sytes.net>,
bugtraq@securityfocus.com
Message-ID: <20031205211830.GA6172@deneb.enyo.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <D7DDF83751235046BFAC82E1244EB4C8034AE239@usilms23.ca.com>
From: Florian Weimer <fw@deneb.enyo.de>
Scovetta, Michael V wrote:
> I've run into this, and my solution for MSSQL was to use Java
> PreparedStatements).
Unfortunately, there appears to be a misconception surrounding Java
prepared statements. Many developers assume that the only reason to use
them is performance, and are extremely reluctant to switching (even if
the application architecture would allow for that with a reasonable
delevelopment effort).
I believe that the relative fragility of database gateways written in
PHP is a result of the late availability of higher-level database
interface libraries (comparable to JDBC or Perl's DBI) and thus the
large amount of hand-written SQL statement generation code.
