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