Object[] row = null;
byte[][] row = null;
    public void testPreparedSelect() throws Exception {        if (log!=null) log.info("test- testPreparedSelect");        db1 = setupTable();        t1 = startTransaction(db1);        doSQLImmed(db1, t1, "INSERT INTO R1 VALUES (1, 2)");        doSQLImmed(db1, t1, "INSERT INTO R1 VALUES (2, 3)");        doSQLImmed(db1, t1, "INSERT INTO R1 VALUES (3, 4)");        XSQLDA in_xsqlda;// = new XSQLDA();        XSQLDA out_xsqlda;// = new XSQLDA();        isc_stmt_handle stmt1 = gds.get_new_isc_stmt_handle();        if (log!=null) log.info("test- isc_dsql_allocate_statement");        gds.isc_dsql_allocate_statement(db1, stmt1);        if (log!=null) log.info("test- isc_dsql_prepare");        out_xsqlda = gds.isc_dsql_prepare(t1, stmt1, "SELECT COL1, COL2 FROM R1 WHERE COL1 = 1",                             GDS.SQL_DIALECT_CURRENT);//, out_xsqlda);//        if (log!=null) log.info("test- isc_dsql_describe_bind");//        in_xsqlda = gds.isc_dsql_describe_bind(stmt1, 1);//, in_xsqlda);        in_xsqlda = null;//        in_xsqlda.sqlvar[0].sqldata = new Short((short) 1);//        if (log!=null) log.info("test- isc_dsql_describe");//        out_xsqlda = gds.isc_dsql_describe(stmt1, 1);//, out_xsqlda);        if (log!=null) log.info("test- isc_dsql_execute2");        gds.isc_dsql_execute2(t1, stmt1, 1, in_xsqlda, null);//        if (log!=null) log.info("test- isc_dsql_set_cursor_name");//        gds.isc_dsql_set_cursor_name(stmt1, "cur1", 0);//        int fetch_stat;        String out = "";//        while (gds.isc_dsql_fetch(stmt1, 1, out_xsqlda) != null) {        Object[] row = null;        while ((row=gds.isc_dsql_fetch(stmt1, 1, out_xsqlda)) != null) {            for (int i = 0; i < out_xsqlda.sqld; i++) {//                Short data = (Short) out_xsqlda.sqlvar[i].sqldata;                Short data =  (Short) row[i];                out += data.shortValue() + "    ";            }            out += System.getProperty("line.separator");        }        if (log!=null) log.info("fetch returned: " + out);        if (log!=null) log.info("test- isc_dsql_free_statement");        gds.isc_dsql_free_statement(stmt1, GDS.DSQL_drop);        commit(t1);        teardownTable(db1);    }