11:15 p.m.
Should enum objects be converted to the appropriate type when bound to a native query?
It looks like they are converted properly when bound using a Criteria or HQL Query, but
not for a SQLQuery.
Attached is a patch for EnumTypeTest that shows that it works for Criteria and HQL
queries, and fails for SQLQuery.
Is this a bug?
Thanks,
Gail
10:05 a.m.
As a personal uninformed opinion, I would expect that when setting
parameters to a Native Query there would be no transformations.
I'm wondering if there is a (significant) population of users who
expect the opposite?
(BTW I didn't find the attachment, I think this list drops them..
better to attach them to a JIRA, so you can also use that to document
a decision?)
Sanne
On 13 February 2015 at 05:15, Gail Badner <gbadner(a)redhat.com> wrote:
Should enum objects be converted to the appropriate type when bound
to a native query?
It looks like they are converted properly when bound using a Criteria or HQL Query, but
not for a SQLQuery.
Attached is a patch for EnumTypeTest that shows that it works for Criteria and HQL
queries, and fails for SQLQuery.
Is this a bug?
Thanks,
Gail
_______________________________________________
hibernate-dev mailing list
hibernate-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
10:33 a.m.
Do we do any other conversion in SQLQueries from the property type to the SQL type? I
don’t think we do.
On 13 Feb 2015, at 06:15, Gail Badner <gbadner(a)redhat.com>
wrote:
Should enum objects be converted to the appropriate type when bound to a native query?
It looks like they are converted properly when bound using a Criteria or HQL Query, but
not for a SQLQuery.
Attached is a patch for EnumTypeTest that shows that it works for Criteria and HQL
queries, and fails for SQLQuery.
Is this a bug?
Thanks,
Gail_______________________________________________
hibernate-dev mailing list
hibernate-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
1:55 p.m.
Probably the difference is the idea of "auto determination" of a
parameter's "expected" Type. In HQL/JPQL and Criteria queries I have a lot
of code in place to determine the expected type of a parameter based any
"corresponding property reference". In native SQL queries there is no such
opportunity to perform this "auto determination".
On Mon, Feb 16, 2015 at 10:33 AM, Emmanuel Bernard <emmanuel(a)hibernate.org>
wrote:
Do we do any other conversion in SQLQueries from the property type to
the
SQL type? I don’t think we do.
> On 13 Feb 2015, at 06:15, Gail Badner <gbadner(a)redhat.com> wrote:
>
> Should enum objects be converted to the appropriate type when bound to a
native query?
>
> It looks like they are converted properly when bound using a Criteria or
HQL Query, but not for a SQLQuery.
>
> Attached is a patch for EnumTypeTest that shows that it works for
Criteria and HQL queries, and fails for SQLQuery.
>
> Is this a bug?
>
> Thanks,
> Gail_______________________________________________
> hibernate-dev mailing list
> hibernate-dev(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
_______________________________________________
hibernate-dev mailing list
hibernate-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
2:34 p.m.
OK, so this is expected.
Thanks!
Gail
----- Original Message -----
From: "Steve Ebersole" <steve(a)hibernate.org>
To: "Emmanuel Bernard" <emmanuel(a)hibernate.org>
Cc: "Gail Badner" <gbadner(a)redhat.com>, "Hibernate Dev"
<hibernate-dev(a)lists.jboss.org>
Sent: Monday, February 16, 2015 11:55:54 AM
Subject: Re: [hibernate-dev] Enum object bound to SQLQuery
Probably the difference is the idea of "auto determination" of a
parameter's "expected" Type. In HQL/JPQL and Criteria queries I have a
lot
of code in place to determine the expected type of a parameter based any
"corresponding property reference". In native SQL queries there is no such
opportunity to perform this "auto determination".
On Mon, Feb 16, 2015 at 10:33 AM, Emmanuel Bernard <emmanuel(a)hibernate.org>
wrote:
> Do we do any other conversion in SQLQueries from the property type to the
> SQL type? I don’t think we do.
>
> > On 13 Feb 2015, at 06:15, Gail Badner <gbadner(a)redhat.com> wrote:
> >
> > Should enum objects be converted to the appropriate type when bound to a
> native query?
> >
> > It looks like they are converted properly when bound using a Criteria or
> HQL Query, but not for a SQLQuery.
> >
> > Attached is a patch for EnumTypeTest that shows that it works for
> Criteria and HQL queries, and fails for SQLQuery.
> >
> > Is this a bug?
> >
> > Thanks,
> > Gail_______________________________________________
> > hibernate-dev mailing list
> > hibernate-dev(a)lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
>
>
> _______________________________________________
> hibernate-dev mailing list
> hibernate-dev(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>
3601
days inactive
3604
days old
4 comments
4 participants
participants (4)
-
Emmanuel Bernard -
Gail Badner -
Sanne Grinovero -
Steve Ebersole