Re: examples of SQL Arrays and jdbc?

On 06 Feb 2003 20:27:19 -0500 Dave Cramer <Dave@micro-automation.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@averillpark.net
Averill Park Networking                                         518-573-7592
              Unix, Linux, IP Network Engineering, Security