From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: CallableStatement.getParameterMetaData() throws exception for valid {call ...} statement |
Date: | 2015-06-03 07:01:10 |
Message-ID: | mkm8nm$i73$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> According to the Java 7 API it seems this interface is mainly associated with
> PreparedStatements and lucky to get any information from a CallableStatement.
Well a CallableStatement *is* a PreparedStatement
> From the context of your question, it seems what you are looking for is the
> information about the function, parameters, etc. When I first looked at this
> I searched the database for the newly created sum_n_product() function to
> find information about it. It seemed to be abscured. Perhaps that information
> stored in the database is the answer to your question rather then this interface.
Yes, that's what I'm doing when getParameterMetaData() fails. But it makes things a bit more complicated
This is part of my SQL client that supports multiple DBMS and offers a DBMS independent way to call procedures that have OUT parameters.
I was just curious. Many JDBC drivers don't even implement getParameterMetaData() but the error message in Postgres' exception is misleading because there is such a function - and the fact that it works _after_ registering an OUT parameter makes it even more confusing.
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Robert DiFalco | 2015-06-06 16:34:47 | Multiple Row Insert vs. Batch |
Previous Message | dmp | 2015-06-02 16:40:11 | Re: Re: CallableStatement.getParameterMetaData() throws exception for valid {call ...} statement |