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
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 |