Re: Prepared Statements

straight from jdbc2.1 doc
http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec2/jdbc2.1.frame6.html
Statement
Statement object to submit a set of heterogeneous update commands together
as a single unit, or batch, to the underlying DBMS
i.e. execute Statement without parameters
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html

PreparedStatement
An element in a batch consists of a parameterized command and an associated
set of parameters when a PreparedStatement is used. (i.e. A Statement with
params)
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedStatement.html

CallableStatement
Multiple sets of input parameter values may be associated with a callable
statement and sent to the DBMS together.
(For procedures)
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/CallableStatement.html

Viel Gluck
Martin
----- Original Message -----
From: <mljv(at)planwerk6(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, January 09, 2008 2:02 PM
Subject: [GENERAL] Prepared Statements

> Hi,
>
> i am trying to understand "Prepared Statements". I am asking because i
want to
> understand the impact of "Prepared statements" to my application.
>
> Actually i use Hibernate, DBCP Connection Pool with Postgresql-JDBC Driver
and
> Postgresql 8.1.
>
> - I know there is a PREPARE Statement in Postgresql and read the docs.
> - in PostgresqlJDBC i have a prepareThreshold parameter which i left to
> default of 5.
> - in DBCP i have a property "poolPreparedStatements", set to true. Does
ist
> just configure prepareThreshold of JDBC or does it maintain a
statementPool
> of it's own?
>
> In my Log files of postgresql each query is called like this:
>
> EXECUTE <unnamed> [PREPARE: select ...]
>
> I have not found anything about preparing "unnamed" statements. What does
it
> mean?
>
> many questions, but i was googling a lot and "Prepared Statement" is a
> somewhat ambiguous expression, isn't it? Can someone clarify this to me,
> please?
>
> kind regards,
> Janning
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>