Re: Doubt in Value insertion to an Array column through

PrepatedStatement.setArray( Array x) ?

Dave
On Wed, 2003-03-12 at 23:54, Shanmugasundaram Doraisamy wrote:
> 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(at)ceedees(dot)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(at)postgresql(dot)org
--
Dave Cramer <Dave(at)micro-automation(dot)net>