From bfaure@cosmosbay.com Mon Apr 17 14:18:49 2000 Received: from risgw.ris.fr (IDENT:root@risfw.ris.fr [195.6.34.1]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA04732; Mon, 17 Apr 2000 10:18:49 -0400 (EDT) (envelope-from bfaure@cosmosbay.com) Received: from cosmosbay.com (IDENT:faure@simons [200.0.0.250]) by risgw.ris.fr (8.9.3/8.9.3) with ESMTP id QAA21501; Mon, 17 Apr 2000 16:17:36 +0200 Message-ID: <38FB1CED.ECD15DC0@cosmosbay.com> Date: Mon, 17 Apr 2000 16:17:17 +0200 From: Bruno Faure Reply-To: bruno.faure@cosmosbay.com X-Mailer: Mozilla 4.7 [fr] (X11; I; Linux 2.2.14-15mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org CC: pgsql-novice@postgresql.org Subject: JDBC : CallableStatement returns always same Exception Content-Type: multipart/alternative; boundary="------------7C4772011C90CFEC0ADE7CC7" X-Archive-Number: 200004/95 --------------7C4772011C90CFEC0ADE7CC7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I'am using a PGSQL DB on Linux, and I'm writing a Connection Servlet to that DB. Everything is fine when using simple statements, but I can't use any CallableStatement to execute stored procedures. It returns an exception , whatever I put in the prepareCall (even if nothing) : Error : Callable Statements are not supported at this time. State : null Code : 0 My code : CallableStatement instruction ; instruction = con.prepareCall("call ps_ins_user{?,?}"); --> raises the Exception ... or instruction = con.prepareCall(""); --> raises the Exception as well Does that mean that stored procedure are not supported on pgSQL :-(? I feel that this is a postgreSQL problem, because I've checked on the JDBC forum, and others are using the same code on other database without any probem. Thanks for your help. Bruno Faure --------------7C4772011C90CFEC0ADE7CC7 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I'am using a PGSQL DB on Linux, and I'm writing a Connection Servlet to that DB.
Everything is fine when using simple statements, but I can't use any CallableStatement to execute stored procedures.
It returns an exception , whatever I put in the prepareCall (even if nothing) :

Error : Callable Statements are not supported at this time.
State : null
Code : 0

My code :
   CallableStatement instruction ;
   instruction = con.prepareCall("call ps_ins_user{?,?}");    --> raises the Exception
    ...
or instruction = con.prepareCall("");   --> raises the Exception as well

 
Does that mean that stored procedure are not supported on pgSQL :-(?

I feel that this is a postgreSQL problem, because I've checked on the JDBC forum, and others are using the same code on other database without any probem.

Thanks for your help.

Bruno Faure --------------7C4772011C90CFEC0ADE7CC7-- From bfaure@cosmosbay.com Mon Apr 17 14:45:23 2000 Received: from risgw.ris.fr (IDENT:root@risfw.ris.fr [195.6.34.1]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA41837 for ; Mon, 17 Apr 2000 10:45:23 -0400 (EDT) (envelope-from bfaure@cosmosbay.com) Received: from cosmosbay.com (IDENT:faure@simons [200.0.0.250]) by risgw.ris.fr (8.9.3/8.9.3) with ESMTP id QAA22160 for ; Mon, 17 Apr 2000 16:44:08 +0200 Message-ID: <38FB2324.31373FE4@cosmosbay.com> Date: Mon, 17 Apr 2000 16:43:48 +0200 From: Bruno Faure Reply-To: bruno.faure@cosmosbay.com X-Mailer: Mozilla 4.7 [fr] (X11; I; Linux 2.2.14-15mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: JDBC : CallableStatement returns always same Exception References: <95598204701@aquarius.hosting4u.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/96 Hi, I'am using a PGSQL DB on Linux, and I'm writing a Connection Servlet to that DB. Everything is fine when using simple statements, but I can't use any CallableStatement to execute stored procedures. It returns an exception , whatever I put in the prepareCall (even if nothing) : Error : Callable Statements are not supported at this time. State : null Code : 0 My code : CallableStatement instruction ; instruction = con.prepareCall("call ps_ins_user{?,?}"); --> raises the Exception ... or instruction = con.prepareCall(""); --> raises the Exception as well Does that mean that stored procedure are not supported on pgSQL :-(? I feel that this is a postgreSQL problem, because I've checked on the JDBC forum, and others are using the same code on other database without any probem. Thanks for your help. Bruno Faure From petermount@it.maidstone.gov.uk Mon Apr 17 15:22:43 2000 Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA00978 for ; Mon, 17 Apr 2000 11:22:43 -0400 (EDT) (envelope-from petermount@it.maidstone.gov.uk) Received: from mailgate.maidstone.gov.uk ([194.159.6.98] helo=gatekeeper.maidstone.gov.uk) by anchor-post-32.mail.demon.net with esmtp (Exim 2.12 #1) id 12hDMF-000BtA-0W; Mon, 17 Apr 2000 16:22:39 +0100 Received: from exchange1.nt.maidstone.gov.uk (exchange1.nt.maidstone.gov.uk [172.16.0.150]) by gatekeeper.maidstone.gov.uk (8.9.3/8.9.3) with ESMTP id QAA24175; Mon, 17 Apr 2000 16:22:39 +0100 Received: by exchange1.nt.maidstone.gov.uk with Internet Mail Service (5.5.1960.3) id <240AS5YN>; Mon, 17 Apr 2000 16:20:23 +0100 Message-ID: <1B3D5E532D18D311861A00600865478C70C4A5@exchange1.nt.maidstone.gov.uk> From: Peter Mount To: "'bruno.faure@cosmosbay.com'" , pgsql-interfaces@postgresql.org Subject: RE: JDBC : CallableStatement returns always same Exc eption Date: Mon, 17 Apr 2000 16:20:21 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.1960.3) Content-Type: text/plain X-Archive-Number: 200004/98 Callable statements are not supported at all. I was planning on including them in 7.0, but the amount of work needed means it's not going to be ready in time, hence it's going to be a 7.1 item. PS: It was only a couple of weeks ago that I found some real examples on how CallableStatement works. Peter -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council. -----Original Message----- From: Bruno Faure [mailto:bfaure@cosmosbay.com] Sent: Monday, April 17, 2000 3:44 PM To: pgsql-interfaces@postgresql.org Subject: [INTERFACES] JDBC : CallableStatement returns always same Exception Hi, I'am using a PGSQL DB on Linux, and I'm writing a Connection Servlet to that DB. Everything is fine when using simple statements, but I can't use any CallableStatement to execute stored procedures. It returns an exception , whatever I put in the prepareCall (even if nothing) : Error : Callable Statements are not supported at this time. State : null Code : 0 My code : CallableStatement instruction ; instruction = con.prepareCall("call ps_ins_user{?,?}"); --> raises the Exception ... or instruction = con.prepareCall(""); --> raises the Exception as well Does that mean that stored procedure are not supported on pgSQL :-(? I feel that this is a postgreSQL problem, because I've checked on the JDBC forum, and others are using the same code on other database without any probem. Thanks for your help. Bruno Faure