Re: getGeneratedKeys() - Mailing list pgsql-jdbc

From Marcus Andree S. Magalhaes
Subject Re: getGeneratedKeys()
Date
Msg-id 61203.200.174.148.100.1072858789.squirrel@webmail.webnow.com.br
Whole thread Raw
In response to Re: getGeneratedKeys()  (<henr-and@dsv.su.se>)
List pgsql-jdbc
Ahhh.... yes.... good and old "multiplatform code compatibility"...

I remember that from '95, when version Beta 2.0 arrived and I started
to write Java code in applets...

There was a cool hack around to use Netscape to compile code and
generate a class file under Linux 1.2...

The promiss of "write once, run everywhere". Frames used AWT back
then and all have the same cup of cofee when iconized. After all,
the mac wasn;t able to iconize frames. Well, some flexibility was
trade off in the name of compatibility. Fine...

Then, we had to deal with threading issues in Solaris and Windows...
After that, JDBC arrived... True, multiplatform db access.
A query as complex as "select gettime()" could run in SQL Server
and Postgres (or it was called PostgreSQL at that time ?)
and return the same kind of data: a timestamp-like data in SQL Server
and an error in Postgres.

Since then, I never believed in platform independent coding. And it
was a long time ago....


>> Can you do the insert using a function instead, and return the currval
>> on the underlying sequence?
>>
>> John
>>
>
> I'm not sure what you mean. A stored procedure?
>
> The good thing about getGeneratedKeys() is that you don't have to write
> DB-specific code.
> --
> Henrik
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org




pgsql-jdbc by date:

Previous
From: "John Sidney-Woollett"
Date:
Subject: Re: getGeneratedKeys()
Next
From: snpe
Date:
Subject: Re: ResultSetMetaData enhancements