From: | Auri Mason <amason(at)syntrex(dot)com> |
---|---|
To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: getColumns() - workaround |
Date: | 2002-04-04 13:44:07 |
Message-ID: | Pine.LNX.4.44.0204041534030.6799-100000@mendeleev.syntrex.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I've find the workaround for postreSQL
//->>>>>>>>>>>>the following returns no rows!
ResultSet rs = dma.getColumns(getCatalog(), getSchema(), tableName.toUpperCase(), fieldName.toUpperCase());
//->>>> the following WORKS FINE!
ResultSet rs = dma.getColumns("", "",tableName.toLowerCase(), fieldName.toLowerCase());
BTW, it doesn't work if tablename is a view :(
--
Auri
On 3 Apr 2002, Dave Cramer wrote:
> Auri,
>
> AFAIK this works, can you give me specifics?
>
> ie db version, columns, code sample, etc.
>
> Dave
> On Wed, 2002-04-03 at 11:22, Auri Mason wrote:
> > Hi list,
> >
> > in my applications I use getColumns() method to retrieve the size of some
> > fileds to avoid the exceed of the field size during an insert.
> > This procedure works fine with oracle, DB2 and MSsql JDBC but seems it
> > doesn't work (return a null) with the postgresql JDBC driver (feb 9 2002
> > release).
> > Anyone of you has some note/fix/workaround about this?
> >
> > p.s. I use % as schema
From | Date | Subject | |
---|---|---|---|
Next Message | Auri Mason | 2002-04-04 14:04:16 | Re: getColumns() - workaround |
Previous Message | Nick Fankhauser | 2002-04-04 12:56:55 | Re: JDBC Driver Problem |