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

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

On Wed, 14 May 2008, Daniel Migowski wrote:

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

PreparedStatement.getParameterMetaData will prepare a statement without
executing it.

Kris Jurka

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

Kris Jurka schrieb: On Wed, 14 May 2008, Daniel Migowski wrote:
Is it possible with the PostgreSQL JDBC driver (leaving the JDBC API space is allowed) to serverside prepare a statement without executing it?
PreparedStatement.getParameterMetaData will prepare a statement without executing it.
Thank you. I also already helped me with something like statement.executeQuery("PREPARY test AS "+myQueryToTest), but your variant does apropriate query parsing, which seem better.

With best regards,
Daniel Migowski




--


|¯¯|¯¯| IKOffice GmbH Daniel Migowski | | |/| Mail: dmigowski@ikoffice.de | | // | Nordstr. 10 Tel.: 0441 21 98 89 52 | | \\ | 26135 Oldenburg Fax.: 0441 21 98 89 55 |__|__|\| http://www.ikoffice.de Mob.: 0176 22 31 20 76