View Single Post

   
  #1 (permalink)  
Old 04-16-2008, 12:59 AM
Silvio Bierman
 
Posts: n/a
Default Howto set UUID parameter for PGSQL 8.3rc1 / postgresql-8.3dev-602.jdbc3.jar

Hello all,

I am trying to convert an older PG database where we stored GUID keys by
explicitly converting them to byte arrays before storing them in bytea
columns in the DB to a database where we use the new UUID type supported
by PG 8.3.

I am having trouble setting such a value through a JDBC
PreparedStatement because any stmt.setXXX(i,...) I have tried results in
an error about a mismatch between type UUID and XXX.

How can I get my PreparedStatement to work correctly?

Kind regards,

Silvio Bierman

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote