Re: java.sql.Statement.isClosed() throws an SQLException if the statement is closed

The bug likewise applies to PreparedStatement, not just Statement.

Am 15.08.2014 um 13:43 schrieb Christian Schlichtherle <christian(at)schlichtherle(dot)de>:

> Hi,
>
> this bug applies to the JDBC driver version 9.3-1102-jdbc41. It only happens when using a PGPoolingDataSource. The bug is in the proxy class for the Statement. Here’s some test code to provide evidence:
>
> <pre><code>
> package cpssd.postgresql;
>
> import org.junit.Test;
> import org.postgresql.ds.PGPoolingDataSource;
>
> import java.sql.Connection;
> import java.sql.SQLException;
> import java.sql.Statement;
>
> public class IsClosedIT {
>
> @Test(expected = SQLException.class)
> public void testIsClosed() throws SQLException {
> final PGPoolingDataSource ds = new PGPoolingDataSource();
> ds.setDatabaseName("postgres");
> try (Connection c = ds.getConnection()) {
> Statement s = c.createStatement();
> s.close();
> // Throws SQLException: Statement has been closed.
> assert s.isClosed();
> }
> }
> }
> </code></pre>
>
> Regards,
> Christian Schlichtherle