Re: examples of SQL Arrays and jdbc?

Richard,

The current implementation of setObject() doesn't support arrays.

thanks,
--Barry

Richard Welty wrote:
> On 06 Feb 2003 20:27:19 -0500 Dave Cramer <Dave(at)micro-automation(dot)net> wrote:
>
>
>>Yes, in general any postgres data type can be set/get using
>>setString/getString
>>
>>This may change in the future, it is really an artifact of the wire
>>protocol
>>
>>Be warned!
>
>
> taking this advice to heart, i switched my code to write jdbc int arrays
> from using strings, per eric's posting, to using Integer arrays, saving
> them with setObject, per page 266-267 of the sun jdbc book (second
> edition). their example shows an array of strings:
>
> String [] departments = {"accounting", "personal", "marketing"};
> PreparedStatement pstmt = con.prepareStatement(
> "UPDATE AJAX_LTD SET DEPTS = ? WHERE ID = 0045");
> pstmt.setObject( 1, departments);
>
> my code differs in that the object is an Integer [],
>
> Debug.println( "starting arrays, field_index: " + field_index);
> statement.setObject( ++field_index,
> intArrayToInteger( target_percentages));
> Debug.println( "first array done, field_index: " + field_index);
>
> where intArrayToInteger appears to work correctly, and is as follows:
>
> public static Integer [] intArrayToInteger( int [] ints){
> Integer [] IntArray = new Integer [ints.length];
>
> for( int i = 0; i < ints.length; i++){
> IntArray[i] = new Integer( ints[i]);
> }
> return IntArray;
> }
>
> i'm getting the following error:
>
> starting arrays, field_index: 7
> SQLException: The table for [Ljava.lang.Integer;
> is not in the database. Contact the DBA, as the
> database is in an inconsistent state.
>
> i'd previously seen this when i mistakenly tried to pass int [] arrays to
> setObject. am i missing something here? perhaps some Objects work and not
> others?
>
> environment (which i inadvertantly left out of my note earlier today on my
> problems with set methods on my UPDATE statement):
>
> RedHat 7.3
> postgresql installed from rpm, 7.2.1-5
> pgjdbc2.jar driver from website late october of last year
> jdk 1.4.1_01
>
> thanks in advance,
> richard
> --
> Richard Welty rwelty(at)averillpark(dot)net
> Averill Park Networking 518-573-7592
> Unix, Linux, IP Network Engineering, Security
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>