Passing Array from Java to Postgres
От | lathasuresh.s@gmail.com |
---|---|
Тема | Passing Array from Java to Postgres |
Дата | |
Msg-id | 18395d43-777b-4b47-b533-478b4c61b995@e38g2000prn.googlegroups.com обсуждение исходный текст |
Ответы |
Re: Passing Array from Java to Postgres
|
Список | pgsql-jdbc |
Hi, I need to pass array from Java to postgres DB.Tried the following code given in net,but it doesnt work,please help me to solve this. Getting no exceptions but program execution skips when it reaches the following code cstmt.setArray(2, connection.createArrayOf("int4", intarr )); I have also copied the following code for reference, DBConnection dbconn=new DBConnection(); Connection connection=dbconn.getDBConnection(); CallableStatement cstmt = connection.prepareCall("{?= call testit(?)}"); cstmt.registerOutParameter(1, Types.INTEGER); try{ cstmt.setArray(2, connection.createArrayOf("int4", intarr )); }catch(Exception e) { e.printStackTrace(); } cstmt.execute(); result = cstmt.getInt(1); Regards, Latha S
В списке pgsql-jdbc по дате отправления: