I think this fixture is ok as is except for maybe a comma after the word fail. Following rename should fail, to prove that, not the following rename should fail to prove that #.
On the cleanup e.g. drop tables you should just have s.executeUpdate("drop table t3) instead of an assertion
Why is this fixture commented out? There doesn't seem to be an open cursor.
/*-- cannot rename an index when there is an open cursor on it
public void testRenameIndexWithOpenCursor() throws SQLException
Statement s = createStatement(ResultSet.TYPE_FORWARD_ONLY , ResultSet.CONCUR_UPDATABLE);
assertUpdateCount(s , 0 , "create table t1(c11 int, c12 int)");
assertUpdateCount(s , 0 , "create index i1 on t1(c11)");
assertStatementError("X0X95" , s , "rename index i1 to i1r");
//-- following rename should pass because cursor c1 has been closed
assertUpdateCount(s , 0 , "rename index i1 to i1r");
assertUpdateCount(s , 0 , "drop table t1");