Doubt in Value insertion to an Array column through JDBC] - Mailing list pgsql-jdbc

From Shanmugasundaram Doraisamy
Subject Doubt in Value insertion to an Array column through JDBC]
Date
Msg-id 1047531253.17323.10.camel@vpsd2.ceedees.com
Whole thread Raw
Responses Re: Doubt in Value insertion to an Array column through
List pgsql-jdbc
Dear Group,
        We are using Postgresql 7.3.1 on Redhat 7.3. The following is the problem I am facing:

**************************************************************************************************
    I am having a table with the following structure:

    Table Name: address_using_array

          COLUMN_NAME        TYPE    CONSTRAINT
          -------------------------------------
    1.     name              text       -
    2.     address           text[]     -
    3.     email             text       -


    I tried the following combinations and I got the exceptions as a
result (It is also given).
    My java program Name is DBTestWithArrayColumn.java.

        a)   PreparedStatement pStmt =
                        connection.prepareStatement("insert into
address_using_array values(?,{?,?},?)");
             pStmt.setString(1,"Subramanian. S");
             pStmt.setString(2,"First Street");
             pStmt.setString(3,"Friends Nagar");
             pStmt.setString(4,"ssm_pandu@ceedees.com");
             if(pStmt.execute()) System.out.println("Successfully
inserted");

           Output:
            ------
                java.sql.SQLException: ERROR:  parser: parse error at or
near "{" at character 58
                 at
DBTestWithArrayColumn.main(DBTestWithArrayColumn.java:28)


    The doubt is "How to insert values to the 'address' column through
JDBC?".


Thanking you,
Shanmugasundaram Doraisamy


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: getExportedKeys/getImportedKeys more information
Next
From: "Albert B. Tingson III"
Date:
Subject: Help!!