FAQ
HI all.

I have a function called:

dbcmp(
t varchar,
p varchar[],
c varchar[],
n INTEGER
) RETURNS SETOF dbcmp_t
...


Today, I call my function like this:

String sql = "select * from dbcmp('" + t + "','" + p + "','" + "'," + n + ")";
Statement stmt = con.createStatement(sql);
ResultSet rs = stmt.executeQuery();
...

I want to transform my code to use PreparedStatement like this:

String sql = "select * from dbcmp(?, ?, ?, ?)";
PreparedStatement ps = con.preparedStatement(sql);
ps.setString(1, t);
ps.setArray(2, p);
ps.setArray(3, c);
ps.setInt(4, n);

But I don´t know how to create an Array object to use the set.

Can anyone help me? :-)

Thanks in advance.

--
José Arthur Benetasso Villanova
ICQ 2138887

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
grouppgsql-jdbc @
categoriespostgresql
postedJun 14, '06 at 7:04p
activeJun 15, '06 at 12:53p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase