| From: | from-postgresql(at)xenomachina(dot)com | 
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org | 
| Subject: | BUG #14576: JDBC's PreparedStatement.getParameterMetaData fails with 'could not determine polymorphic type' | 
| Date: | 2017-03-03 17:56:26 | 
| Message-ID: | 20170303175626.25057.3985@wrigleys.postgresql.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
The following bug has been logged on the website:
Bug reference:      14576
Logged by:          Laurence Gonsalves
Email address:      from-postgresql(at)xenomachina(dot)com
PostgreSQL version: 9.5.6
Operating system:   Ubuntu Linux 16.04
Description:        
I am using the JDBC driver "org.postgresql:postgresql:42.0.0.jre7".
I'm creating a PreparedStatement with the following SQL:
    SELECT code, title, did
    FROM films
    WHERE did in (select * from unnest(?));
I can set the parameter and execute the query without problems, but if I
call getParameterMetaData() on the PreparedStatement (before executing
the query) an exception is thrown:
    Exception in thread "main" org.postgresql.util.PSQLException: ERROR:
could not determine polymorphic type because input has type "unknown"
    at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
    at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at
org.postgresql.jdbc3.AbstractJdbc3Statement.getParameterMetaData(AbstractJdbc3Statement.java:414)
    ...
This makes it impossible to (programmatically) determine even the number
of parameters the PreparedStatement accepts.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2017-03-03 19:11:32 | Re: [HACKERS] Two phase commit in ECPG | 
| Previous Message | digoal | 2017-03-03 02:32:46 | BUG #14575: Standby recovery process call close() very slow, when drop (many small files) database on Primary. |