Just one idea - I'm not using Oracle - but what about:
(column = '' OR column IS NULL)
In Torque
Criteria.Criterion c1 = criteria.getNewCriterion(COLUMN, , Criteria.EQUAL);
Criteria.Criterion c2 = criteria.getNewCriterion(COLUMN, (Object)null,
Criteria.ISNULL);
criteria.add(c1.or(c2));
Thanks Thoralf, I will try it.. I am sure this will work.
I am thinking that instead of building these type of workarounds to take care
of db specific idiosyncrasies in our code we should do it in the torque
classes.
The build expression in torque.util.SQLExpression class accepts the db
Why cannot we write a code in this method which simply says -
if db is of type dboracle and if criteria= then criteria is null
Maybe because nobody wrote a patch or a jira issue. :)
http://issues.apache.org/jira/browse/TORQUE
the actual code that does db operation is in village.jar which is not a
part of Torque.
Thoralf Rickert wrote:
Why cannot we write a code in this method which simply says -
if db is of type dboracle and if criteria= then criteria is null
Maybe because nobody wrote a patch or a jira issue.
