0 Replies Latest reply on Mar 17, 2006 9:08 PM by Frank Reed

    JDBC insert commiting after approx. 20-30 min.

    Frank Reed Newbie

      Hello,

      Oracle 8.1.7
      JBoss4.0.2

      I am making JDBC call to insert into a table.
      PreparedStatement testStat = connection.prepareStatement("INSERT INTO ...") ;
      testStat.setInt(6, col...);
      if (testStat.executeUpdate() != 1) {print .. }
      testStat.close() ;
      connection.clost();if (rlLogPrepStatement.executeUpdate() != 1) {

      There are no errors. Using SQL*Plus, I cannot see the commit until after a long time. Has anybody experienced this?

      Thank you.