log.info("test- isc_dsql_exec_immed2");
if (log!=null) log.info("test- isc_dsql_exec_immed2");
    public void testParameterizedInsert() throws Exception {        log.info("test- 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;        log.info("test- 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;        log.info("test- 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);        log.info("test- retrieved inserted row C1 = " + xsqlda.sqlvar[0].sqldata + "     " +                           "C2 = " + xsqlda.sqlvar[1].sqldata);        commit(t1);        teardownTable(db1);    }