Re: PrepareStatement

From:

Lew <lew@lewscanon.com>

Newsgroups:

comp.lang.java.programmer

Date:

Tue, 29 Jan 2008 08:50:19 -0500

Message-ID:

<zamdnfwnSdyBsgLanZ2dnUVZ_umlnZ2d@comcast.com>

Bumsys@gmail.com wrote:

String query = "select logfiles from "
                + getFullTableName(Tables.LOG)
                + " where ipadr = ? and application = ? and
time_started = ? for update";

            PreparedStatement ps =
manager.getConnection().prepareStatement(
                    query);
            ps.setString(1, ipAdrStr);
            ps.setString(2, applStr);
            ps.setTimestamp(3, sqlDate);

            ResultSet rs = ps.executeQuery();

how can i get sql query that is formed by PrepareStatement?

Via 'query' - the actualized query with the positional parameters in place is
not available, because that exists only in a compiled form that is not
available to the calling program. Internally the system never generates a
string version of that query. The only query string available is the one
referenced via your 'query' variable.

If you are using log4j you can log the query with something like:

  logger.debug( "Query: "+ query );
    (java.util.logging: logger.fine( "Query: "+ query ); )
  logger.debug( "IP addr: "+ ipAdrStr );
  etc.

P.S., You only needed to post your question once.

P.P.S., It's a bad idea to embed implementation details ("Str") in variable
names ("ipAdrStr"). What if you changed it from a String to an IpAddr type?
Your variable names should be drawn from the modeled domain of discourse, not
from program implementation: "ipAddress".

--
Lew