From: Bruno Faure <bfaure@cosmosbay.com>
To: pgsql-interfaces@postgresql.org
Subject: JDBC : CallableStatement returns always same Exception
Date: Mon, 17 Apr 2000 16:43:48 +0200
Message-ID: <38FB2324.31373FE4@cosmosbay.com> (raw)
References: <95598204701@aquarius.hosting4u.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bfaure@cosmosbay.com
Subject: Re: JDBC : CallableStatement returns always same Exception
In-Reply-To: <38FB2324.31373FE4@cosmosbay.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox