Re: CachedRowSetXImpl() and PostgreSQL

From: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: CachedRowSetXImpl() and PostgreSQL
Date: 2006-09-21 21:33:55
Message-ID: 45130543.7080609@pbnet.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


> What we need to know is what is the metadata call being made to the
> driver and how do the results differ from what is expected?
>
That's pretty much hidden behind the curtains in the Java classes. How
can I log that ?

> BTW, it's possible to have a table called "my.table" (where "my." is
> part of the table name, not a schema prefix) so the driver seems to be
> doing the right thing if it is being asked about tables called
> "my.table" by the RowSet .. But that's why we need to know what
> metadata call is being made.
>
my is the schema name. I have tried 3 setups:
1. setting setTableName("my.table");
2. setTableName("table");
3. setSchemaName("my"); setTableName("table");

And none of them works. When getting the metadata from pg_catalog the
schema name must be left out
and when doing update the schema name must be included or it can't find
the relation.
It's like the setSchemaName has no effect
> I think finding out why setSchemaName on your rowset does not work is
> the first step, that RuntimeException tells me nothing about the real
> cause of the problem.
Exactly, but I'm clueless how.

Poul

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2006-09-21 21:41:18 Re: CachedRowSetXImpl() and PostgreSQL
Previous Message Oliver Jowett 2006-09-21 21:14:34 Re: CachedRowSetXImpl() and PostgreSQL