Doubt in Value insertion to an Array column through JDBC]

From: Shanmugasundaram Doraisamy <shan(at)ceedees(dot)com>
To: postgresql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Doubt in Value insertion to an Array column through JDBC]
Date: 2003-03-13 04:54:08
Message-ID: 1047531253.17323.10.camel@vpsd2.ceedees.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Albert B. Tingson III 2003-03-13 09:15:57 Help!!
Previous Message Dave Cramer 2003-03-13 02:12:15 Re: getExportedKeys/getImportedKeys more information