Well, it seems to work for regular SQL. I do not need to specify schema
name for the tables I am hitting. Here are the config file as well as
properties file that it uses.
TestApplicationContext.xml:
http://www.springframework.org/schema/beans";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-inst
Jeff,
Think the question was not about including OR-s in the SQL but executing SQL
only if OR-ed expression is true. Anyway, the right place of OR-s seems to
be in java, but it seems to me one can achieve the same adding the following
to the desired SQL (using appropriate syntax for specific datab