Major Description
In one of the error messages the parameter does not get replaced with the actual value to make the message meaningful.
Here is a sample message:
===> XJ084=Column does not correspond to a column in the base table. Cant issue
{0} on this column.More info:
Table:
ij version 10.1
ij> connect 'jdbc:derby:tvtm';
ij> select * from t1;
C1 |C2
--------------------------------
1 |aa
2 |bb
3 |cc
3 rows selected
To get the above message use the following Java snippet:
private static void runTestXJ084(Connection conn){
try{ Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery("SELECT 1, 2 FROM t1 FOR UPDATE"); rs.next(); rs.updateInt(1,22); }catch (SQLException sqe){ System.out.println(" ===> "+ sqe.getSQLState()+"="+ sqe.getMessage()); }
}
The message obtained is:
===> XJ084=Column does not correspond to a column in the base table. Cant issue {0}
on this column.
The
{0}above should have been replaced by the appropriate operation perfomed - update in the above case.