Testing JDBC Prepared Statements - Mailing list pgsql-jdbc

From Daniel Migowski
Subject Testing JDBC Prepared Statements
Date
Msg-id 482AFAEB.1000505@ikoffice.de
Whole thread Raw
Responses Re: Testing JDBC Prepared Statements  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Hello dear developers,

We are beginning to have a bunch of SQL statements in an evolving
application, and are facing the problem, that every rename of a database
attribute (refactor early and often ;), breaks some of our statements.

To find what we broke, we are currently looking for postgresql to
prepare all the statements, without actually executing them, and to see,
which fail.

As far as I understand, the JDBC API wraps the internal implementation
of PreparedStatements from the user (and with PostgreSQL, there is a
distinction between client/server side prepared statements, anyway).

Is it possible with the PostgreSQL JDBC driver (leaving the JDBC API
space is allowed) to serverside prepare a statement without executing it?

With best regards,
Daniel Migowski

pgsql-jdbc by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: 25P02, current transaction is aborted, commands ignored
Next
From: Kris Jurka
Date:
Subject: Re: Testing JDBC Prepared Statements