[Info-ingres] Ingres 10.1, JDBC parameters issue

[zarafiq]

Hi,

I am encountering a strange problem when accessing Ingres 10.1
using jdbc. Old db (2.6) everything fine.
New DB (10.1) the following code runs ok:

 String sql = "SELECT * FROM table_x WHERE column_x = 'A1234' ";
 PreparedStatement pstmt = con.prepareStatement(sql);
 ResultSet rs = pstmt.executeQuery();

After changing to:

 String sql = "SELECT * FROM table_x WHERE column_x = ? ";
 PreparedStatement pstmt = con.prepareStatement(sql);
 pstmt.setString(1, "A1234");
 ResultSet rs = pstmt.executeQuery();

Super slow (I am guessing full table scan), and the following
error in errlog.log. 

E_PS0C05_BAD_ADF_STATUS Unexpected status from ADF

Tried 3 different iijdbc.jar files, (client v. 3, 9 and 10)
with no success.

Any help would be appreciated.

Regards,
zarafiq