Re: updatable (J2EE) resultsets

1) why do you want to use mixed case columns. Postgres supports them but
not very well.

2) so what you are suggesting is that if a column name has any upper
case letters, then it should be quoted?

Dave
On Tue, 2002-12-10 at 09:04, Gerlits András wrote:
> Hi all.
>
> I'm new to the list, so first off I'd like to say hello.
>
> The reason I've joined the list is that I've tried to use the updatable
> ResultSet feature with the JDBC drivers for Postgres and found that they
> won't work if you have columns in your database that have capital letters
> in it. After a lot of fumbling (which included not downloading the source,
> but decompiling the driver (I'm not too proud of that :))) I've found the
> AbstractJdbc2ResultSet.insertRow method, which prepares the query for
> execution, but ignores the fact that columnames must be included between "-
> s if they are capitalized.
>
> I'd be happy to post a patch, but I'm really a newcomer when it comes to
> open-source shared development, and haven't got the slightest idea on how
> to do it.
>
> I've tried to look this up in the archives, but haven't found any threads
> dealing with this issue.
>
> Thanks
> Andras Gerlits
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Dave Cramer <Dave(at)micro-automation(dot)net>