After schema changes ActiveObjects yields exception "cached plan must not change result type" with PostgreSQL - JDBC driver 9.4

Description

Hi,

From time to time customers report the following stack trace when they install an upgrade of my plug-in with PostgreSQL:

This one happened with the following PostgreSQL version:

  • nameostgreSQL

  • version:9.3.4

  • minor version:3

  • major version:9

  • Driver:

  • nameostgreSQL Native Driver

  • versionostgreSQL 9.4 JDBC4.1 (build 1201)

This normally happens when I add a new column to an entity. In the web I've seen similar issues and normally a restart of the application helps. PostgreSQL seams to have issues with cached plans that have been altered through table changes.

The question is: can you clear those caches in ActiveObjects to circumvent such a restart?

Thanks,
Michael

Environment

None

Testing Notes

Add notes...

Assignee

Unassigned

Reporter

Mibex Software

Labels

None

Add-on Type

Server

Team

None

CC

None

Risk factor

None

QA Kickoff Status

None

QA Demo Status

None

Story Points

2

Components

Sprint

None

Affects versions

Priority

Critical
Configure