Re: DatabaseMetaData and Transactions - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: DatabaseMetaData and Transactions
Date
Msg-id F76A1422-9F37-4A26-9430-51071837CF3C@fastcrypt.com
Whole thread Raw
In response to DatabaseMetaData and Transactions  (Carl Olivier <carl@zero-one.co.za>)
List pgsql-jdbc
Carl,

One of the queries is failing, have a look at the logs in postgres
and report back to
us what is failing.

Dave
On 6-Jun-05, at 9:38 AM, Carl Olivier wrote:

> Greetings.
>
> Having a problem with regards DatabaseMetaData retrievals within a
> Transaction.  I have a large transaction running - within which
> database
> alterations need to occur.  However, during this process I need to
> retrieve
> Table metadata (via the DatabaseMetaData.getTables() method).
> However, this
> does not seem possible in POSTGRES?  I receive the following error:
>
> ERROR: current transaction is aborted, queries ignored until end of
> transaction block.
>
> I trace that directly to a call to the getTables method of the
> DatabaseMetaData implementation.
>
> Can anyone provide me with any advice here?  Is this correct
> behaviour, and
> is there any way (other than caching table metadata prior to, and
> maintaining said cache during the transaction) to allow for meta data
> retrieval during a transaction?
>
> Thanks in advance!
>
> Regards,
>
> Carl
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>


pgsql-jdbc by date:

Previous
From: Carl Olivier
Date:
Subject: DatabaseMetaData and Transactions
Next
From: Sylvain Boily
Date:
Subject: Probleme with jdbc driver an openxhange.