Re: hibernate nativequery and uuid - Mailing list pgsql-general

From Andrew
Subject Re: hibernate nativequery and uuid
Date
Msg-id 489244C7.7070206@pacific.net.au
Whole thread Raw
In response to Re: hibernate nativequery and uuid  ("Douglas McNaught" <doug@mcnaught.org>)
List pgsql-general
Yeah, tried that, but get the following:

org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111

Thanks for the suggestion though.



Douglas McNaught wrote:
On Thu, Jul 31, 2008 at 5:57 PM, Andrew <archa@pacific.net.au> wrote:
 
The only relevant thing I have been able to find relating to it is
http://archives.postgresql.org/pgsql-bugs/2007-12/msg00061.php which
suggests adding a ::uuid cast to the parameter.

However, when doing that, hibernate thinks that it is a named parameter and
complains.
org.hibernate.QueryException: Not all named parameters have been set   
Have you tried using the alternative (and more standard) CAST syntax
instead?  Perhaps that won't confuse Hibernate.

-Doug
 

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: eliminating records not in (select id ... so SLOW?
Next
From: Andrew
Date:
Subject: Re: hibernate nativequery and uuid