Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Converting SQLServer 2005 uniqueIdentifier column to java.util.UUID  RSS feed

Sander Evanfield
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I have a uniqueidentifier column in SQLServer 5 table which is retrieved through JDBC (Driver Sparta)

String uniqueColumn = resultSet.getString(1);

actual column in database has value 067e6162-3b6f-4ae2-a171-2470b63dff00

uniqueColumn holds 067e61623b6f4ae2a1712470b63dff00

When I try to get a UUID from uniqueColumn using UUID.fromString(uniqueColumn) I get IllegalStateException as unique column does not hold UUID representation.

Am i missing something here or it is a known bug I can put the dashes in the string and it should work but need an elegant solution supported by JDBC
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!