System.out.println("isc_dsql_allocate_statement");
System.out.println("test- isc_dsql_allocate_statement");
    public void testPreparedSelect() throws Exception {        System.out.println();        System.out.println("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();                System.out.println("isc_dsql_allocate_statement");        gds.isc_dsql_allocate_statement(db1, stmt1);                        System.out.println("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);        //        System.out.println("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);        //        System.out.println("isc_dsql_describe");//        out_xsqlda = gds.isc_dsql_describe(stmt1, 1);//, out_xsqlda);                System.out.println("isc_dsql_execute2");        gds.isc_dsql_execute2(t1, stmt1, 1, in_xsqlda, null);        //        System.out.println("isc_dsql_set_cursor_name");//        gds.isc_dsql_set_cursor_name(stmt1, "cur1", 0);        //        int fetch_stat;        while (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;                System.out.print(data.shortValue() + "    ");            }            System.out.println();        }            System.out.println("isc_dsql_free_statement");        gds.isc_dsql_free_statement(stmt1, GDS.DSQL_drop);        commit(t1);        teardownTable(db1);    }