Обсуждение: JDBC : CallableStatement returns always same Exception

Поиск
Список
Период
Сортировка

JDBC : CallableStatement returns always same Exception

От
Bruno Faure
Дата:
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