0 Replies Latest reply on Jun 19, 2004 5:19 AM by svenbeer

    Prepared Statement Cache + External Application

    svenbeer Newbie

      Hi!

      I've run into a problem after activating the prepared statement cache for my datasource (to improve performance).

      The database entries are modified from an external paplication, too. So I am using "instance per transaction" with commit option B.

      With prepared statement caching enabled I don't get currently modified data displayed anymore until my connection drops and a new one gets created (this is, because the prepared statements are bound to the connection I think)

      So is this to enable the prepared statement cache for a datasource which is modified by an external application?


      Thanks for any help,
      Sven