Thread: Re: Doubt in Value insertion to an Array column through JD

Re: Doubt in Value insertion to an Array column through JD

From
J M Okomba
Date:
Try this:

                        connection.prepareStatement("insert into
address_using_array values(?,?,?)");

             pStmt.setString(1,"Subramanian. S");
        pStmt.setArray(2, {"First Street","Friends Nagar"});
             pStmt.setString(3,"ssm_pandu@ceedees.com");

> -----Original Message-----
> From:    Shanmugasundaram Doraisamy [SMTP:shan@ceedees.com]
> Sent:    13 March 2003 04:54
> To:    postgresql-jdbc
> Subject:    [JDBC] Doubt in Value insertion to an Array column through
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org