Re: When will your JDBC 4.0 driver implement DatabaseMetadata.getFunctions? - Mailing list pgsql-jdbc

From the6campbells
Subject Re: When will your JDBC 4.0 driver implement DatabaseMetadata.getFunctions?
Date
Msg-id CAFEjsq6_=7wLDDmKGMFv2du2VxEumais5St+89S9AJJ8y0jpAQ@mail.gmail.com
Whole thread Raw
In response to Re: When will your JDBC 4.0 driver implement DatabaseMetadata.getFunctions?  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: When will your JDBC 4.0 driver implement DatabaseMetadata.getFunctions?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Semantically, one would hope that the advertised method is used to get an object of the type (procedure vs function) vs using an overloaded method which conceptually is returning both. Perhaps PG may internally treat both objects as the same type but you'd like to think that one could say create procedure and create function and be able locate said via canonical API method such as DatabaseMetadata.get<xxyyzz>


On Mon, Sep 24, 2012 at 1:35 PM, Dave Cramer <pg@fastcrypt.com> wrote:
This is just an alias for getProcedures, so 1) it's probably fairly
easy to implement and 2) why not just use getProcedures ?
Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Mon, Sep 24, 2012 at 12:59 PM, the6campbells <the6campbells@gmail.com> wrote:
> Currently fails
>
> PostgreSQL 9.1 JDBC4 (build 902)
> 9.0.4
>
> Error calling JDBC driver for procedure metadata.
> org.postgresql.Driver.notImplemented(Driver.java:751)
> org.postgresql.jdbc4.AbstractJdbc4DatabaseMetaData.getFunctions(AbstractJdbc4DatabaseMetaData.java:82)
> SQLException.sqlState(0A000) SQLException.Message(Method
> org.postgresql.jdbc4.Jdbc4DatabaseMetaData.getFunction(String, String,
> String) is not yet implemented.)
>

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: When will your JDBC 4.0 driver implement DatabaseMetadata.getFunctions?
Next
From: Tom Lane
Date:
Subject: Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?