5:04 p.m.
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
5:15 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Tobias Dietl commented on HHH-2077:
-----------------------------------
sorry, I got the sql queries wrong...
If you want to search for '_abc' in MySQL, you have to use:
value like '\_abc'
or
value like '\_abc' escape '\\';
In Oracle or HSQLDB, you have to use:
value like '\_abc' escape '\'
and not
value like '\_abc'
As you can see, simple escaping with '\' does not work with Oracle and HSQLDB, so
I wanted to use another escape sequence '|'. Unlike with HQL queries,
unfortunately, there is no way of setting the escape sequence for Criteria queries.
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
5:21 p.m.
New subject: [Hibernate-JIRA] Closed: (HHH-2077) Providing an escape sequence for Criteria queries
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=all ]
Steve Ebersole closed HHH-2077:
-------------------------------
Resolution: Rejected
Incorrect. You actually can do this already. like expressions are handled by a class
named org.hibernate.criterion.LikeExpression, which has the following constructor:
protected LikeExpression(
String propertyName,
String value,
MatchMode matchMode,
Character escapeChar,
boolean ignoreCase) { ... }
Notice the 'escapeChar' parameter?
Arguably this constructor should not be protected; but regardless, what you ask is
certainly already achievable...
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
11:43 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Tobias Dietl commented on HHH-2077:
-----------------------------------
org.hibernate.criterion.LikeExpression has a protected constructor and therefore can not
be used within ordinary application classes.
Therefore I dissagree with the comment, as it is not archievable to escape characters
without subclassing from LikeExpression and providing a new, public Constructor. This
would be a real hack...
A simple solution would be to make the constructor public or provide a method that enables
the user to set the escapeChar. Up to now, this is only possible for Query by Example
(QBE)
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
11:47 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Tobias Dietl commented on HHH-2077:
-----------------------------------
So it is only possible for Query by Example (QBE) , but not for Criteria queries to set
the escape char! I think itwould be quite simple to add this feature and it would make
sense...
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
12:54 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Steve Ebersole commented on HHH-2077:
-------------------------------------
You can, of course, subclass. How is that a hack? These are all meant to be
extensible...
No, it is not only available in QBE as I have stated previously.
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
2:17 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Tobias Dietl commented on HHH-2077:
-----------------------------------
My code lookes like that:
Criteria c = HibernateUtil.getSession().createCriteria(Ipu.class);
c.add(Expression.like("name", filter, MatchMode.ANYWHERE));
How can I set the escape char here? There is no Expression.like that takes an escape
char!
The signatue is
SimpleExpression like(String propertyName, String value, MatchMode matchMode)
It would be nice to have something similar to
SimpleExpression like(String propertyName, String value, MatchMode matchMode, Character
escapeChar)
What do you think about it?
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
2:29 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Steve Ebersole commented on HHH-2077:
-------------------------------------
I would rather saty away from providing ever possible combination of options in the
Expression factory methods. That's an API explosion waiting to happen...
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
7:13 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Kevin Stembridge commented on HHH-2077:
---------------------------------------
Hi Steve,
I'm just wondering if you plan on making the constructor public?
I could create a subclass, but if that class contains nothing but public constructors that
delegate to the protected constructors of the superclass then it's hard to say that
isn't at least a little bit of a hack :)
Also, I'm just curious, what is the reason for using protected constructors on this
class?
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
12:46 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Steve Ebersole commented on HHH-2077:
-------------------------------------
Obviously its trivial to do... By the way, have you seen the number of trivial things to
be done in JIRA? ;)
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
9:50 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Kevin Stembridge commented on HHH-2077:
---------------------------------------
Agreed, its not a major issue because there is a workaround. I was just asking if your
plan was to make the constructor public or not.
My interpretation of your answer is that you do think the change should be made, but
correct me if I'm wrong. If so, this issue shoud probably be reopened and downgraded
to trivial just so it is at least on the radar.
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Type: Improvement
Components: query-criteria
Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
8:01 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Mark A. Ziesemer commented on HHH-2077:
---------------------------------------
Well, now that over a year has passed, I too am facing this same issue. What can be done
to address this?
Can someone re-open this bug, or should we just create a new one and link back to this
one?
Is there any reason as to why these Criterion constructors can't be made public? If
not, what needs to be done to make this happen? If needed, I could write and submit a
patch to make the necessary changes...
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Issue Type: Improvement
Components: query-criteria
Affects Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining Estimate: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:40 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Max Rydahl Andersen commented on HHH-2077:
------------------------------------------
Mark - create a subclass that calls the method like you want. That is the intented usecase
for customizations.
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Issue Type: Improvement
Components: query-criteria
Affects Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining Estimate: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:57 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Mark A. Ziesemer commented on HHH-2077:
---------------------------------------
Max - thanks for confirming that subclassing is the intended usecase for these classes.
However, I'd still be curious as to the reasoning behind the protected constructors,
just as Kevin previously asked without receiving an answer. While creating the subclass
works, it seems a bit inconvenient to have to create a subclass just to access code that
already exists. Is there a reason as to why the protected constructors aren't /
can't be public?
Thanks!
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Issue Type: Improvement
Components: query-criteria
Affects Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining Estimate: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:16 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Max Rydahl Andersen commented on HHH-2077:
------------------------------------------
I assume it was done like because the author were not sure if he would like that
constructor to be public api.
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate3
Issue Type: Improvement
Components: query-criteria
Affects Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining Estimate: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:54 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Nabeel Mukhtar commented on HHH-2077:
-------------------------------------
On a related note the LikeExpression seems to have a bug in the method getTypedValues().
Its converting the value to lower case without checking the ignoreCase flag. So it does
not work when ignoreCase is false. Is it intended?
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate Core
Issue Type: Improvement
Components: query-criteria
Affects Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining Estimate: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:38 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2077) Providing an escape sequence for Criteria queries
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077?page=c...
]
Mark A. Ziesemer commented on HHH-2077:
---------------------------------------
Nabeel - the issue you mentioned regarding ignoreCase is already being tracked at
HHH-2997.
Providing an escape sequence for Criteria queries
-------------------------------------------------
Key: HHH-2077
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2077
Project: Hibernate Core
Issue Type: Improvement
Components: query-criteria
Affects Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4
Environment: Hibernate 3.1.3, MySQL, HSQLDB, Oracle
Reporter: Tobias Dietl
Original Estimate: 3 hours
Remaining Estimate: 3 hours
Up to now, there is no way of setting the escape sequence to use for string comparisions
with like for Criteria queries.
This is necessary as MySQL on the one hand and HSQLDB / Oracle on the other behave
differently...
If you want to search for '_abc' in MySQL, you have to use:
value like '\\_abc'
In Oracle or HsqlDB, you have to use:
value like '\_abc'
If you want to switch to another escape sequence like '|' , you can set it in HQL
with value like '|_abc' escape '|'. Unfortunately, there is no way of
setting it for Criteria queries, which would force me to rewrite all my Criteria queries
in HQL. It would really be nice if the feature/improvement would be added...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5659
days inactive
6497
days old
hibernate-issues@lists.jboss.org
16 comments
6 participants
participants (6)
-
Kevin Stembridge (JIRA) -
Mark A. Ziesemer (JIRA)
-
Max Rydahl Andersen (JIRA)
-
Nabeel Mukhtar (JIRA)
-
Steve Ebersole (JIRA)
-
Tobias Dietl (JIRA)