From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Auri Mason <amason(at)syntrex(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: getColumns() - workaround |
Date: | 2002-04-04 14:23:17 |
Message-ID: | 1017930197.20075.6.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Auri,
Yes, if you go into psql and look at your tables you will find that they
are all lower case, regardless of how you created them.
Dave
On Thu, 2002-04-04 at 08:44, Auri Mason wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2002-04-04 15:21:45 | Re: Urgent :Query - Please help |
Previous Message | Auri Mason | 2002-04-04 14:04:16 | Re: getColumns() - workaround |