Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Uniqueidentifier column type is not supporting in prepared statement

 
Naresh Talluri
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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



here is the sample code :




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
author & internet detective
Marshal
Posts: 34672
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 115
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.


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.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic