Commit 9980a95

Snapshot builds (builds from `master` branch) are also deployed to OSS Sonatype Snapshot Repository, so you can test current development version (test some bugfix) by enabling the repository and using the latest [SNAPSHOT](https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/) version.

version: Log4J CVE Notice

- fix: binary conversion of (very) long numeric values (longer than 4 * 2^15 digits) [PR #2697](https://github.com/pgjdbc/pgjdbc/pull/2697)\

- fix: Apply patch from [Issue #2683](https://github.com/pgjdbc/pgjdbc/issues/2683) provided by James Courtney to fix hanging ssl connections [PR #2687](https://github.com/pgjdbc/pgjdbc/pull/2687)\

Sebastian Baumhekel(1): <sebastian.baumhekel@gmail.com>

- feat: Define binary transfer for custom types dynamically/automatically fixes [Issue #2554](https://github.com/pgjdbc/pgjdbc/issues/2554) [PR #2556](https://github.com/pgjdbc/pgjdbc/pull/2556)

sz-liva(1):

- fix: improve thread safety of PgResultSet#getTimestamp [PR #2726](https://github.com/pgjdbc/pgjdbc/pull/2726) fixes [Issue #2723](https://github.com/pgjdbc/pgjdbc/issues/2723)

try (Connection conn = DriverManager.getConnection(url, "test", "")){

try (PreparedStatement pstmt = conn.prepareStatement("SELECT ?")){

// cast to the pg extension interface

org.postgresql.PGStatement pgstmt = pstmt.unwrap(org.postgresql.PGStatement.class);

// on the third execution start using server side statements

pgstmt.setPrepareThreshold(3);

for (int i = 1; i <= 5; i++) {

pstmt.setInt(1, i);

boolean usingServerPrepare = pgstmt.isUseServerPrepare();

ResultSet rs = pstmt.executeQuery();

rs.next();

System.out.println("Execution: " + i + ", Used server side: " + usingServerPrepare + ", Result: " + rs.getInt(1));

rs.close();

}

}

The driver provides an extension for accessing `COPY`. Copy is an extension that PostreSQL provides. see [Copy](https://www.postgresql.org/docs/current/sql-copy.html)

private static String[] origData =

{"First Row\t1\t1.10\n",

"Second Row\t2\t-22.20\n",

"\\N\t\\N\t\\N\n",

"\t4\t444.40\n"};

private int dataRows = origData.length;

private String sql = "COPY copytest FROM STDIN";

try (Connection con = DriverManager.getConnection(url, "postgres", "somepassword")){

createTempTable(con, "copytest", "stringvalue text, intvalue int, numvalue numeric(5,2)");

PGConnection pgConnection = con.unwrap(org.postgresql.PGConnection.class);

CopyManager copyAPI = pgConnection.getCopyAPI();

CopyIn cp = copyAPI.copyIn(sql);

for (String anOrigData : origData) {

byte[] buf = anOrigData.getBytes();

cp.writeToCopy(buf, 0, buf.length);

}

long updatedRows = cp.endCopy();

long handledRowCount = cp.getHandledRowCount();

System.err.println(String.format("copy Updated %d Rows, and handled %d rows", updatedRows, handledRowCount));

int rowCount = getCount(con);

System.err.println(rowCount);

}

String sql = "COPY copytest TO STDOUT";

try (Connection con = DriverManager.getConnection(url, "postgres", "somepassword")){

PGConnection pgConnection = con.unwrap(org.postgresql.PGConnection.class);

CopyManager copyAPI = pgConnection.getCopyAPI();

CopyOut cp = copyAPI.copyOut(sql);

int count = 0;

byte[] buf; // This is a relatively simple example. buf will contain rows from the database

while ((buf = cp.readFromCopy()) != null) {

count++;

}

long rowCount = cp.getHandledRowCount();

}

More examples can be found in the [Copy Test Code](https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/test/java/org/postgresql/test/jdbc2/CopyTest.java)

Binary JAR file downloads of the JDBC driver are available here and the current version with Maven Repository. Because Java is platform neutral, it is a simple process of just downloading the appropriate JAR file and dropping it into your classpath. Source versions are also available here for recent driver versions. Latest [SNAPSHOT](https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/) versions.

aliases:

- "/about/license.html"

<a href="{{.Permalink}}"> {{.Params.Version}}</a>

put("BOX_ARRAY", "_BOX");