0 Replies Latest reply on Jan 15, 2007 12:50 PM by razshaar

    prepared-statement-cache-size RETURNING INTO

      I'm facing a problem caching the following UPDATE callable statement: BEGIN UPDATE TABLE_NAME SET COLUMN_1 RETURNING UPDATE_TIME INTO NEW_UPDATE_TIME; END;

      In the datasource xml: <prepared-statement-cache-size>5</prepared-statement-cache-size>

      During statement execution, the returned value (NEW_UPDATE_TIME) is never updated and always returned the value from the first execution...

      CallableStatement statement = null;
      statement.executeUpdate();
      final Timestamp ts = statement.getTimestamp(1);


      Configuration:
      jboss-4.0.5.GA, Oracle 10g, JDK 1.5.0_09

      Thanks
      R