Doubt in Value insertion to an Array column through JDBC]
От | Shanmugasundaram Doraisamy |
---|---|
Тема | Doubt in Value insertion to an Array column through JDBC] |
Дата | |
Msg-id | 1047531253.17323.10.camel@vpsd2.ceedees.com обсуждение исходный текст |
Ответы |
Re: Doubt in Value insertion to an Array column through
|
Список | 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 по дате отправления: