Case History:
I have upgraded postgreSQL normal to Enterprise edition
Old version: PostgreSQL 9.5.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit
New Version: EnterpriseDB 9.5.0.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit
Taken complete dump from old and imported in new version.
Problem statement:
While We are accessing postgre function from new version (Enterprise) (by making connection from java 1.8). Getting below error although there is no problem with establish connection with postgreSQL enterprise.
org.postgresql.util.PSQLException: A CallableStatement was executed with an invalid number of parameters
at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:106)
This error comes for all 144 functions. Is there any change in java callableStatement and prepared statement while using enterprise PostgreSQL ? Although same procedures are working while establish connection with old version of PostgreSQL.
Please suggest
BR// Mohit M
I also faced same problem.
I think you are using postgresql-9.4.1211.jre6.jar. Problem will be resolved by replacing the jar to postgresql-9.4.1209.jre6.jar.