Re: hibernate nativequery and uuid

[Andrew <archa(at)pacific(dot)net(dot)au>]

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(at)pacific(dot)net(dot)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
>
>