JDBC : CallableStatement returns always same Exception

Поиск
Список
Период
Сортировка
От Bruno Faure
Тема JDBC : CallableStatement returns always same Exception
Дата
Msg-id 38FB1CED.ECD15DC0@cosmosbay.com
обсуждение исходный текст
Список pgsql-interfaces
Hi, I'am using a PGSQL DB on Linux, and I'm writing a Connection Servlet to that DB. <br />Everything is fine when
usingsimple statements, but I can't use any CallableStatement to execute stored procedures. <br />It returns an
exception, whatever I put in the prepareCall (even if nothing) : <p><i>Error : Callable Statements are not supported at
thistime.</i><br /><i>State : null</i><br /><i>Code : 0</i><p>My code : <br /><i>   CallableStatement instruction
;</i><br/><i>   instruction = con.prepareCall("call ps_ins_user{?,?}");    </i>--> raises the Exception <br /><i>   
...</i><br/>or<i> instruction = con.prepareCall("");   </i>--> raises the Exception as well<i></i><p>  <br />Does
thatmean that stored procedure are not supported on pgSQL :-(? <p>I feel that this is a postgreSQL problem, because
I'vechecked on the JDBC forum, and others are using the same code on other database without any probem. <p>Thanks for
yourhelp. <p>Bruno Faure 

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: "J.Post"
Дата:
Сообщение: Connecting website with SQL-database.....
Следующее
От: Bruno Faure
Дата:
Сообщение: JDBC : CallableStatement returns always same Exception