Is that stored procedure actually in the schema "public"?
Mark
On 2020-07-13 13:53, Pavan Kumar Bonda wrote:
> Hi Team,
> The java.sql.DatabaseMetaData.getProcedures() method is not returning
> the list of Procedures from the database when run against PostgreSQL
> 12.3.1 with the latest JDBC driver postgresql-42.2.14.jar. The same
> call actually returns me the list of Procedures from the same
> PostgreSQL 12.3.1 database with an older JDBC driver
> postgresql-42.2.5.jar.
>
> To test this, I've used a sample JDBC program and here are the output
> messages when run with these two versions of JAR files. I've attached
> the JDBC program used as well.
>
> With 42.2.14 JDBC jar:
> Database connection successful!!!
>
> Driver supports this JDBC version: 4.2
> _Current JDBC Driver Version: 42.2.14_
>
> With 42.2.5 JDBC jar:
> Database connection successful!!!
>
> Driver supports this JDBC version: 4.2
>
> Current JDBC Driver Version: 42.2.5
>
> Catalog name: null
>
> Procedure name: CUT_SAMPLEPROCEDURE
>
> Type of the procedure: 2
> _Specific name of the procedure: CUT_SAMPLEPROCEDURE_43443_
>
> Please let me know if you need any further details on the same.