Hosting Provided By

[JDBC] UUID datatype

From: Andrew <archa(at)pacific.net.au>
Date: Sat Feb 16 2008 - 08:39:02 EST

Hi,

I'm currently running:

PostgreSQL v8.3
JDBC4 v8.3-603

I'm wondering about the timeline or plans if any for JDBC driver support of the recently added UUID datatype in PostgreSQL?

I haven't been able to check the JDBC v4 spec as the Sun server hosting it was not available at the time I last checked, but I doubt that it is part of the specification, as it is not in the JDBC v3 spec and it is not mentioned in the differences between the two, so I assume any such support would be as a custom datatype similar to the PGcircle datatype. Additionally, I was not able to find anything in the JDBC driver documentation regarding UUID support or in the driver API, and all that I have been able to find on the Internet is work arounds, such as custom methods on the DB end to convert string UUID representations into UUID datatypes, as there is no implicit conversion by the DB.

As an increasing number of DB's support UUID's, or in the case of Microsoft, their GUID, I thought I would pose the question. I searched the mail archives and couldn't find anything matching, so hopefully this is not a repeated question, as I have just arrived on this list.

Thanks,

Andy

---------------------------(end of broadcast)---------------------------

TIP 2: Don't 'kill -9' the postmaster Received on Sat Feb 16 08:40:06 2008

Do you need help?

This message: [ Message body ]
Next message: Gustav Trede: "[JDBC] extra rowcopy in ResultSet allways needed ?."
Previous message: Adriano Migani: "[JDBC] (assunto em branco)"
Next in thread: Kris Jurka: "Re: [JDBC] UUID datatype"
Reply: Kris Jurka: "Re: [JDBC] UUID datatype"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:44:26 EDT