GUIDs and databases

[jinwah50]

Hi,

I want to read/write a GUID from/to a SQL Server field of the type uniqueidentifer.

I am using a PreparedStatement which has various methods such as setInt, setString etc.

How to setGUID? and then subsequently when I read it back in how do I read it?

Thanks

Jin

[jinwah50]

The solution was to simply use setString and getString.

I am using org.safehaus.uuid.UUID as my GUID field type.

So for the write:

preparedStatement.setString(1, myObject.getUid().toString());

and the read:

result.setUid(new UUID(resultSet.getString(1)));

Just in case anybody else ever searches for this question!

Thanks

Jin