Re: Passing Array from Java to Postgres

Tried it on PostgreSQL 8.2, PL/pgSQL function.

Array sqlArray = cn.createArrayOf("int4", new Integer[] { 47,46 });

CallableStatement cstmt = cn.prepareCall("{? = call testit(?)}");
cstmt.registerOutParameter(1, Types.INTEGER);
try {
cstmt.setArray(2, sqlArray);
} catch (Exception e) {
e.printStackTrace();
}
cstmt.execute();
int result = cstmt.getInt(1);
System.out.println("Result: "+result);

CREATE FUNCTION testit(number integer[]) RETURNS integer
AS $$BEGIN
RETURN number[1];
END;$$
LANGUAGE plpgsql;

Got: "Result: 47"

> Hi,
> I need to pass array from Java to postgres DB.Tried the following
> code given in net,but it doesnt work,please help me to solve this.
>
> Getting no exceptions but program execution skips when it reaches
> the following code
> cstmt.setArray(2, connection.createArrayOf("int4", intarr ));
>
> I have also copied the following code for reference,
>
> DBConnection dbconn=new DBConnection();
> Connection connection=dbconn.getDBConnection();
> CallableStatement cstmt = connection.prepareCall("{?=
> call testit(?)}");
> cstmt.registerOutParameter(1, Types.INTEGER);
> try{
> cstmt.setArray(2, connection.createArrayOf("int4",
> intarr ));
> }catch(Exception e) {
> e.printStackTrace();
> }
> cstmt.execute();
> result = cstmt.getInt(1);
>
> Regards,
> Latha S
>
>