Register / Login
Win a copy of
Java Mock Exams (software)
this week in the
Programmer Certification (OCPJP)
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
JDBC and Relational Databases
Converting SQLServer 2005 uniqueIdentifier column to java.util.UUID
posted 6 years ago
I have a uniqueidentifier column in SQLServer 5 table which is retrieved through
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
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
work but need an elegant solution supported by JDBC
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
Boost this thread!
Oracle or SQL Server?
][SQLServer 2000 Driver for JDBC]ResultSet can not re-read
JDBC Error MSSQL Uniqueidentifier
Uniqueidentifier column type is not supporting in prepared statement
How to view the Datatypes of the Columns of a Table in SQLSERVER