System.out.println("retrieved inserted row C1 = " + xsqlda.sqlvar[0].sqldata + "     " +
System.out.println("test- retrieved inserted row C1 = " + xsqlda.sqlvar[0].sqldata + "     " +
    public void testParameterizedInsert() throws Exception {        System.out.println();        System.out.println("testParameterizedInsert");        db1 = setupTable();                t1 = startTransaction(db1);        XSQLDA xsqlda = new XSQLDA(2);        XSQLVAR xsqlvar = new XSQLVAR();        xsqlvar.sqltype = GDS.SQL_SHORT;        xsqlvar.sqllen = 2;        xsqlvar.sqldata = new Short((short) 3);        xsqlda.sqlvar[0] = xsqlvar;                xsqlvar = new XSQLVAR();        xsqlvar.sqltype = GDS.SQL_SHORT;        xsqlvar.sqllen = 2;        xsqlvar.sqldata = new Short((short) 4);        xsqlda.sqlvar[1] = xsqlvar;                System.out.println("isc_dsql_exec_immed2");        gds.isc_dsql_exec_immed2(db1, t1, "INSERT INTO R1 VALUES (?, ?)",                                 GDS.SQL_DIALECT_CURRENT, xsqlda, null);                xsqlda = new XSQLDA(2);        xsqlvar = new XSQLVAR();        xsqlvar.sqltype = GDS.SQL_SHORT;        xsqlvar.sqllen = 2;        xsqlvar.sqldata = null;        xsqlda.sqlvar[0] = xsqlvar;                xsqlvar = new XSQLVAR();        xsqlvar.sqltype = GDS.SQL_SHORT;        xsqlvar.sqllen = 2;        xsqlvar.sqldata = null;        xsqlda.sqlvar[1] = xsqlvar;                System.out.println("isc_dsql_exec_immed2");        gds.isc_dsql_exec_immed2(db1, t1, "SELECT COL1, COL2 FROM R1 WHERE COL1 = 3",                                 GDS.SQL_DIALECT_CURRENT, null, xsqlda);                System.out.println("retrieved inserted row C1 = " + xsqlda.sqlvar[0].sqldata + "     " +                           "C2 = " + xsqlda.sqlvar[1].sqldata);                commit(t1);        teardownTable(db1);    }