gistfile1.java

import org.skife.jdbi.v2.tweak.Argument;
import org.skife.jdbi.v2.StatementContext;

import java.sql.PreparedStatement;
import java.sql.SQLException;

import oracle.sql.ArrayDescriptor;
import oracle.sql.ARRAY;

/**
 *
 */
public class VArrayArgument implements Argument
{
    private final String typeName;
    private final Object arg;

    public VArrayArgument(String typeName, Object arg) {
        this.typeName = typeName;
        this.arg = arg;
    }

    public void apply(int i, PreparedStatement stmt, StatementContext ctx) throws SQLException {
        ArrayDescriptor desc = ArrayDescriptor.createDescriptor(typeName, stmt.getConnection());
        ARRAY varray = new ARRAY(desc, stmt.getConnection(), arg);
        stmt.setObject(i, varray);
    }
}