Subject: [Pljava-dev] ResultSet getString
Date: Thu, 18 May 2006 09:38:33 -0500
Message-ID: <7E60AAC2-554C-4541-B37D-C515957BE1DB@sptci.com> (raw)
In-Reply-To: <446C84BA.1080506@tada.se>
References: <446C5033.2000508@lewczuk.com>
<446C55FE.2020902@tada.se>
<e4hmi1$9o3$1@sea.gmane.org>
<446C69C8.3030908@tada.se>
<446C773E.6000102@lewczuk.com>
<446C84BA.1080506@tada.se>
On 18-May-06, at 9:29 AM, Thomas Hallgren wrote:
> Marek Lewczuk wrote:
>>
>> Lets see what Java api say about ResultSet.getString():
>> "Retrieves the value of the designated column in the current row of
>> this ResultSet object as a String in the Java programming language."
>>
>> It doesn't say, that getString() will return "a string representation
>> of the object".
> Well, it has to, doesn't it? Either that or throw an exception.
> Question
> is, what representation?
>
>> Now, if I would like to get PostgreSQL String representation of
>> multi-dimensional array, what method should I use ?
> Simply perform SQL coercions in SQL rather than in Java, i.e. "SELECT
> array_out(arrayValue)". The array_out function will produce a pseudo
> type called cstring and PL/Java will treat that as a String.
>
>> For me obvious thing to do is to call getString() and I wouldn't
>> expect that this will return same as
>> ResultSet.getBoolean().toString(). Another example:
>>
>> Statement statement = ...
>> statement.execute()...
>> ResultSet result = ...
>> while (result.next()) {
>> // result contains 3 columns: varchar[], boolean, integer[]
>>
>> // we create a duplicated row, without worrying about the SQL type
>> Statement s = connection.createStatement();
>> s.executeUpdate("INSERT ... (c1, c2, c3) VALUES ('" +
>> result.getString(0) + "', '" + result.getString(1) + "', '" +
>> result.getString(2) + "')");
>> }
>>
> Try this instead:
>
> PreparedStatement s = connection.prepareStatement("INSERT ...(c1, c2,
> c3) VALUES(?,?,?)");
> s.setObject(result.getObject(1));
> s.setObject(result.getObject(2));
> s.setObject(result.getObject(3));
> s.executeUpdate();
>
> Far more efficient since:
> a) no String coercion is needed
> b) no String concatenation is needed
> c) the actual statement can be cached
> d) it's completely insensitive to the types of the involved columns.
>
> Regards,
> Thomas Hallgren
This is much more elegant. I had been doing something similar in the
earlier version while sending objects to the back-end by making my
custom objects extend PGobject. My SQL statements were much simpler
with just one parameter, doing s.setObject( 1, myObject, Types.OTHER )
Rakesh
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: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] ResultSet getString
In-Reply-To: <7E60AAC2-554C-4541-B37D-C515957BE1DB@sptci.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox