jdbc and ARRAYs - Mailing list pgsql-jdbc

From NosyMan
Subject jdbc and ARRAYs
Date
Msg-id 200512021142.38982.nosyman@gmail.com
Whole thread Raw
Responses Re: jdbc and ARRAYs  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hi everyone,

I have some problems trying to use a preparedStatement with an array
parameter. The problem is I don't know how to do it :-(

CREATE OR REPLACE FUNCTION MyFunction( id INTEGER, anArray
VARCHAR[] )..........................


pstat = conn.prepareStatement("SELECT * FROM MyFunction(?,?)");
pstat.setInt(1, 30);
pstat.setArray(2, ??????????);

Can you tell me how can I construct the array for parameter number 2?

Thanks,
NosyMan


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Statement.cancel() race condition
Next
From: Dave Cramer
Date:
Subject: Re: jdbc and ARRAYs