HI

I'm using hibernate with sqlserver,


I have a proceudre in sql server called using hibernate

@Override
public void getAccess() {
Query query = (Query) getSession().createSQLQuery("EXEC getAccess :name,:id,")
.addEntity(Access.class).setParameter("name", "AAA")
.setParameter("id","1dcf61b2-2b37-4c18-bad6-7b51b9ce5c61")
List<Access> result = query.list();
return ;
}

I get this error (for Id) running this, whats the correct approach to pass uniqueIdentifier

com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to uniqueidentifier.

Please let me know.....

I assume that the ID parameter is of type uniqueidentifier in your getAcess function.

Try setting the parameter like this:



and see if it works. According to the SQL Server type conversion table it should work.

Thanks for the suggestion. But this doesnot seem to help. I'm using hibernate query and setParameter on that takes in hibernate type hence I tried with .Type.Char. But still see the same issue. Is there something I'm missing