We have a JDBC driver (3.5.2) that is running against a MS SQL database
and is pulling information from a SQL view. This works fine and what we
see is that an event is triggered and we see the following occur -
BEGIN Handle event(s).
BEGIN query back
Driver:SELECT xxx,xxx WHERE PRIMKEY = ?
That query performs the select statement which queries the database and
returns the info as expected.
What I need to be able to do is order the results returned such as
order by employeestatus ASC
now, i cant seem to see anywhere that I can change the SELECT statement
for a QUERY on this driver to add the ordering, is this even possible?