JDBC : CallableStatement returns always same Exception - Mailing list pgsql-interfaces

From Bruno Faure
Subject JDBC : CallableStatement returns always same Exception
Date
Msg-id 38FB1CED.ECD15DC0@cosmosbay.com
Whole thread Raw
List 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 by date:

Previous
From: "J.Post"
Date:
Subject: Connecting website with SQL-database.....
Next
From: Bruno Faure
Date:
Subject: JDBC : CallableStatement returns always same Exception