ERROR: cached plan must not change

Hi,

We are facing an error in our java application: “ERROR: cached plan must not change”

Our application architecture is as follows:

WAS >> hibernate >> applications >> java connection pool >> drivers jdbc (postgresql-9.1-901.jdbc4.jar) >> cluster postgresql 9.1.2 or 9.2.4

This error occurs when changing a table definition and the application is in use.

Actually, one of the solutions we have is to kill existing “WAS” connections so that future SQL requests do not fail into this error.

So we need your help to resolve this error :

• Have you in jdbc driver some setting which can handle this problem?
• Is this error handled in future jdbc driver ?

Cordialement/Best Regards

CISS Moussa