When I run the following code the result set is not filtered.
When I look at the query sent to SQLServer the where statement is not added.
What do I wrong?
With kind regards,
Chris Gerrist
JDBCConnectionPool mpool = null;
SQLContainer container = null;
try {
mpool = new SimpleJDBCConnectionPool(“net.sourceforge.jtds.jdbc.Driver”, “jdbc:jtds:sqlserver://10.0.1.150/ITK_LN_Scheduler”, “sa”, “sa”, 2, 5);
} catch (SQLException e1) {
e1.printStackTrace();
}
TableQuery tq = new TableQuery(“ITK_JOBACTION”, mpool);
tq.setVersionColumn(“OPTLOCK”);
FreeformQuery fquery = new FreeformQuery(
“SELECT JOBACTIONID, JOBID, NAME, CLASSSRCNAME, CLASSDSTNAME, JOBSTATUS, JOBACTIONSTART, ELAPSEDTIME FROM ITK_JOBACTION ORDER BY JOBACTIONID DESC”, pool, “JOBACTIONID”);
try {
container = new SQLContainer(fquery);
} catch (SQLException e) {
e.printStackTrace();
}
container.addContainerFilter(new Like(“JOBID”, “17”));