prepareThreshold=1 and statement.executeBatch() ??
От | Joost Kraaijeveld |
---|---|
Тема | prepareThreshold=1 and statement.executeBatch() ?? |
Дата | |
Msg-id | 1131864485.6535.26.camel@Panoramix обсуждение исходный текст |
Ответы |
Re: prepareThreshold=1 and statement.executeBatch() ??
|
Список | pgsql-jdbc |
Hi, I have a connection that is created with "prepareThreshold=1" in the connection string. I use a prepared statement that I fill with addbatch() and that I execute with executeBatch() (for full source: see "application.java" attachment). Tracing all statements in my PostgreSQL logs I see (for the full log: see "postgresql.log" attachement): LOG: statement: PREPARE S_2 AS update prototype.customers set title= $1 , defaultcurrency=$2, defaulttermsofdelivery=$3 , defaulttermsofpayment=$4 where customernumber=$5 LOG: statement: <BIND> LOG: statement: EXECUTE <unnamed> [PREPARE: update prototype.customers set title=$1 , defaultcurrency=$2, defaultter msofdelivery=$3, defaulttermsofpayment=$4 where customernumber=$5] LOG: duration: 773.841 ms LOG: statement: <BIND> LOG: statement: EXECUTE <unnamed> [PREPARE: update prototype.customers set title=$1 , defaultcurrency=$2, defaultter msofdelivery=$3, defaulttermsofpayment=$4 where customernumber=$5] LOG: duration: 377.981 ms Does this output mean that the prepared statement with the name "S_2" is not used in the following 2 EXECUTE statements and that therefor each execute statement is planned again? BTW: I used PostgreSQL 8.1 and PostgreSQL-8.1-404.jdbc3.jar. TIA -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: J.Kraaijeveld@Askesis.nl web: www.askesis.nl
Вложения
В списке pgsql-jdbc по дате отправления: