Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Testing JDBC Prepared Statements



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group