public inbox for [email protected]
help / color / mirror / Atom feedSubject: [Pljava-dev] Sample Code ResultSetHandle interface
Date: Sun, 16 Aug 2015 12:51:52 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
Am 15.08.2015 um 11:08 schrieb Thomas Hill:
> Hi,
>
> I have installed pl/Java and am struggling to understand how the code
> in the calling Java program needs to look like if I want to use the
> resultsethandle interface and just call the sample function listsupers.
> Calling listsupers from pgAdmin (select rte.listsupers() in my
> environment) works fine and returns two rows.
>
> I tried
> CallableStatement cstmt = null;
> try {
> cstmt = conn.prepareCall("{ ? = CALL
> \"rte\".\"listsupers\"() }");
> cstmt.executeUpdate();
>
> ResultSet rs = cstmt.getResultSet();
> while (rs.next()){
> rs.getString(1);
> }
>
> but this is throwning an error when the executeUpdate() is called.
>
> Can someone please help?
>
> Thanks
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at lists.pgfoundry.org
> http://lists.pgfoundry.org/mailman/listinfo/pljava-dev
Note: The sample code getNames for the resultsetprovider interface works
fine. The error thrown when trying to run the above listsupers sample is
"Malformed function or procedure escape syntax at offset 2." but
listsupers dowsn't have any in out our parameters!?
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Subject: Re: [Pljava-dev] Sample Code ResultSetHandle interface
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox