oops, forgot to cc the mailing list again...
Andrew wrote:
I know none of this relates directly to postgresql and on reflection
is probably more appropriate for the hibernate forums. So apologies
for having raised the topic here. Also, thanks for the suggestions
that I have received on the t
Oh, I see what you mean. Use EJBQL on a view. That would probably
work. Have to get going, so will try that when I get back in several
hours. I'll let you know how I go.
Andrew wrote:
I have given it consideration, but haven't tried it as I have
concluded that I would still have the same i
I have given it consideration, but haven't tried it as I have concluded
that I would still have the same issue. The problem occurs with the
client attempting to apply a UUID value to filter the result set. So I
would still have a datatype mismatch if I were to use a view.
I am confident that
Yeah, tried that, but get the following:
org.hibernate.MappingException: No Dialect mapping for JDBC type:
Thanks for the suggestion though.
Douglas McNaught wrote:
On Thu, Jul 31, 2008 at 5:57 PM, Andrew <[EMAIL PROTECTED]> wrote:
The only relevant thing I have been able to find r
On Thu, Jul 31, 2008 at 5:57 PM, Andrew <[EMAIL PROTECTED]> 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 t
I'm currently using JPA with Hibernate as my ORM and have been able to
convince hibernate to play nicely with the Postgresql UUID. Most of my
queries have been in EJBQL using the JPA entity manager's createQuery.
However when I try to do a UNION, JPA only returned the results of the
first que
