Re: jdbc supportsStoredProcedures - Mailing list pgsql-jdbc

From Chris Smith
Subject Re: jdbc supportsStoredProcedures
Date
Msg-id 002201c3f3ed$86275830$6f00000a@KYA
Whole thread Raw
In response to jdbc supportsStoredProcedures  ("tijgertje" <figje@hotmail.com>)
Responses Re: jdbc supportsStoredProcedures  (Andrew Rawnsley <ronz@ravensfield.com>)
List pgsql-jdbc
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...

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation


pgsql-jdbc by date:

Previous
From: "obaks"
Date:
Subject: error:mismatched parentheses
Next
From: Oliver Jowett
Date:
Subject: Re: idle in transaction