Uniqueidentifier column type is not supporting in prepared statement

[Naresh Talluri]

Hi Folks

I have an issue with storing uniqueidentifier column in Database using prepared statement.

Am using postgre sql database, in postgres we have one uniqueidentifier column type and am using it.
while inserting uniqueidentifier column as string or object using prepared statement it is throwing exception like

java.sql.SQLException: ERROR: column "fieldid" is of type uniqueidentifier but expression is of type character varying

here is the sample code :

lPreparedStatement = lConn.prepareStatement( sqltext );

preparedStatement.setString( 1 , object.getHistoryFieldValue());

if the column type is string/int/object i can able to store using prepared statement, but because of uniqueidentifier type am not able to insert into DB.

Could anyone of please give me some idea how to do it using JDBC.

I really appriciate if anyone having any suggestion.

[Jeanne Boyarsky]

Naresh,
I went through this yesterday for Timestamps. (postgresql is WAY to picky with types.) I haven't had occasion to try for Unique Ids but searched and found this. The suggestion is to use setObject which sounds reasonable.

[Naresh Talluri]

Hi Jeanne

Thank you for your suggestion, but i tried with setObject() as well, and i followed the link and tried as they shown example.

public class UUID extends org.postgresql.util.PGobject {
public static final long serialVersionUID = 668353936136517917L;
public UUID(String s) throws java.sql.SQLException {
super();
this.setType("uuid");
this.setValue(s);
}
}

but this is also not work it out.

Could you please let me know if you have any other ideas..

Thank you for your reply.