Re: set parameter not enabled? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: set parameter not enabled?
Date
Msg-id 013401c1be06$7e926890$8201a8c0@inspiron
Whole thread Raw
In response to set parameter not enabled?  ("Henry" <hxzhang@cs.ualberta.ca>)
List pgsql-jdbc
Henry,

Postgres does not natively support a stored procedure the way that
others do. There is a patch in the pipe which attempts to convert a
Callable statement into a postgres "stored proc", but I'm not sure it
will work.

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Henry
Sent: Friday, February 22, 2002 5:00 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] set parameter not enabled?


I got the following from a jdbc call:
Exception: Callable Statements are not supported at this time.

this exception comes out from a third party pure java report engine,
thus the detailed information is not very much clear to me. When I was
using Oracle as database backend, this exception is not there. however,
when I change to postgres's  pgjdbc2.jar  JDBC driver, this exception
raises. Does that mean Postgres doesn't support stored procesure?

thanks a lot!


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



pgsql-jdbc by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: Connection Problem with JDBC
Next
From: "Steven Murphy"
Date:
Subject: Re: Connection Problem with JDBC