jdbc question

[djam]

I have a jdbc question,

I have a stored procedure that I'm calling that requires as a parameter an array. Is this the correct syntax?

int[] myArray = new int[2];

myArray[0] = 0;
myArray[1] = 1;

String command = "select getquote('"+myArray+"')";
Statement stmt =con.createStatement();
ResultSet rs = stmt.executeQuery(command);


thanks " ahhh computers, how they made our lives much simpler "

 

[palbano]

>> I have a stored procedure that I'm calling that requires
>> as a parameter an array.

Post that stored procedure. I've never seen an "array" type parameter in a stored procedure.

String command = "select getquote('"+myArray+"')";

That certainly will NOT work.

-pete

 

[djam]

CREATE FUNCTION getquote (integer[]) RETURNS integer AS
'declare

begin

return 1;

end;
'LANGUAGE'plpgsql'; " ahhh computers, how they made our lives much simpler "

 

[palbano]

Well that's beyond my experience. I've never dealt with stored procedures that use complex types or arrays. You should look in the PostgreSQL Developers Guide in section 21 on JDBC to see if they detail how to accompish that.

http://sunsite.ui.ac.id/pub/database/postgres/programmer.pdf

good luck
-pete