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  (Alexander Panzhin <jalexoids@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: How to pass array in prepared statement for stored procedure execution?
Следующее
От: Gorka Mauleon
Дата:
Сообщение: JNDI Datasource in tomcat