From: | Andrew Rawnsley <ronz(at)ravensfield(dot)com> |
---|---|
To: | "Chris Smith" <cdsmith(at)twu(dot)net> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org>, "tijgertje" <figje(at)hotmail(dot)com> |
Subject: | Re: jdbc supportsStoredProcedures |
Date: | 2004-02-15 21:57:53 |
Message-ID: | 014B8DCA-6002-11D8-9659-000393A47FCC@ravensfield.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Feb 15, 2004, at 12:59 PM, Chris Smith wrote:
> tijgertje wrote:
>> So after that I wrote this simple jdbc program, I tried to test if
>> PostgreSQL supports stored procedures with the
>> supportsStoredProcedures method in the DatabaseMetaData class, but
>> the method returned false.
>
> It's hard-coded in the driver to return false.
>
> My guess is that this is because the driver doesn't comply with some
> detail of
> the JDBC or SQL specifications regarding stored procedures. It's best
> to be
> very strict about claiming support for a feature when there are
> work-arounds
> involved for not really conforming. Obviously, stored procedures by
> themselves are supported.
>
> The comment there talks about "stored procedure calls using the stored
> procedure escape syntax". Not sure what that's referring to...
>
That refers to the JDBC escape syntax that supposedly allows consistent
procedure calling
across different database vendows. The whole IN/OUT thing with
CallableStatements, which
postgreSQL doesn't yet support.
Calling stored procedures is easy - select <function> for things that
return a value, or select
* from <function> for those things that return a result set, using
normal Statement objects.
> --
> www.designacourse.com
> The Easiest Way to Train Anyone... Anywhere.
>
> Chris Smith - Lead Software Developer/Technical Trainer
> MindIQ Corporation
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>
--------------------
Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com
From | Date | Subject | |
---|---|---|---|
Next Message | Warren Little | 2004-02-15 23:51:21 | Re: idle in transaction |
Previous Message | Oliver Jowett | 2004-02-15 20:32:42 | Re: idle in transaction |