WebSphere Application Server Access PostgreSQL throuth JDBC

[mushixun]

My Application is deploy on WebSphere Application Server ,config a JDBC Datasource pool to connect PostgreSQL ,JDBC Version is 9.3,PostgreSQL version is 9.3，my problem is my app query a table(using preparedstatement) that contain TIMESTAMP type，the first 4 times access is OK，later access is fail，if I set binaryTransfer=false，All access is OK.

[sehrope]

Please provide the actual error message you're receiving and if possible the stack trace of the error. If you can reproduce the error with a self-contained example that would be even more helpful.

Just guessing based on the "...the first 4 times..." part of the comment, I'd say this is related to the prepared statement being converted to a server side prepared statement. It might be effecting the way the timestamp parameter for your statement is being sent/bound.

The driver switches to (more efficient) server side prepared statements after 4 executions of the same Java prepared statement. You can read more about it here.

[vlsi]

I think timestamp handling was fixed in several commits, so it should be just fine in 9.4.1209+