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@xxxxxxxxxxxx> To: <pgsql-general@xxxxxxxxxxxxxx> Sent: Wednesday, January 09, 2008 2:02 PM Subject: 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/ > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
