| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Mario Splivalo *EXTERN*" <mario(dot)splivalo(at)megafon(dot)hr>, <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Pg 8.3, jdbc and UUID |
| Date: | 2009-01-21 16:09:33 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C202F762F0@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Mario Splivalo wrote:
> What would be the best way to use JDBC and UUIDs?
>
> Since the only interface between the java codebase and postgres RDBMS is
> trough the pl/pgsql functions, shall I write my functions to accept
> varchars, and there convert them to uuids, same thing for returning
> UUIDS to java?
The best interface is text; you can (implicitly) cast UUID to text
(or char or varchar) and vice versa.
So you can for example just use java.sql.PreparedStatement.setString()
to set an UUID.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2009-01-22 00:16:50 | Re: Deadlock detection |
| Previous Message | Simon Riggs | 2009-01-21 14:54:45 | Re: Deadlock detection |