Re: Pg 8.3, jdbc and UUID - Mailing list pgsql-jdbc

From Albe Laurenz
Subject Re: Pg 8.3, jdbc and UUID
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202F762F0@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Pg 8.3, jdbc and UUID  (Mario Splivalo <mario.splivalo@megafon.hr>)
List 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

pgsql-jdbc by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Deadlock detection
Next
From: Simon Riggs
Date:
Subject: Re: Deadlock detection