Hi
The driver of 23\10\2009 does not work correctly with a where clause. I have changed back to the older driver and the selection works fine.
Please advise.
code:
String sql = "select "+field1+" from mdown where punit = ? and fin_date = ?";
PreparedStatement ps = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ps.setString(1,punit);
ps.setDate(2,fin_date);
ps.executeQuery();
ResultSet rs = ps.getResultSet();
|
Please download the latest package.
|