PreparedStatement clearParameters and setTimestamp

Hi,

This reply is about the following threads.
http://archives.postgresql.org/pgsql-jdbc/2006-02/msg00156.php

With case of setTimestamp(), it seem to always do "Parse".
(setDate() and setTime() too)


JDBC driver   : 8.1-407
URL parameter : prepareThreshold=1&loglevel=2

sample code :

create table test(id int, tm timestamp);

int n = 10;
Timestamp tm = new Timestamp(System.currentTimeMillis());
PreparedStatement pst = conn.prepareStatement("INSERT INTO test(id, tm)
VALUES (?, ?)");
for(int i=0; i< n; i++){
    pst.clearParameters();
    pst.setInt(1, i);
    pst.setTimestamp(2, tm);
    pst.executeUpdate();
}
pst.close()

----


When we used poolPreparedStatements (common-dbcp), a similar problem
seems to occur. When we called close() of PreparedStatement, dbcp side
calls clearParameters().


JDBC driver     : 8.1-407
URL parameter   : prepareThreshold=1&loglevel=2
Jakarta commons : commons-dbcp-1.2.1
                  commons-pool-1.3
                  commons-collections-3.2

sample code :

import org.apache.commons.dbcp.BasicDataSource;
              :
String url =
"jdbc:postgresql://localhost/testdb?loglevel=2&prepareThreshold=1";
BasicDataSource ds = new BasicDataSource();
ds.setDriverClassName("org.postgresql.Driver");
ds.setUsername("user");
ds.setPassword("passwd");
ds.setUrl(url);
ds.setPoolPreparedStatements(true);

Connection conn = ds.getConnection();

int n = 10;
Timestamp tm = new Timestamp(System.currentTimeMillis());
for(int i=0; i< n; i++){psql tes
    PreparedStatement pst = conn.prepareStatement("INSERT INTO test(id,
tm) VALUES (?, ?)");
    pst.setInt(1, i);
    pst.setTimestamp(2, tm);
    pst.executeUpdate();
    pst.close()
}

----

best regards,

Akira.