Metacat

      // Set auto commit fasle

      dbconn.setAutoCommit(false);

      pstmt = dbconn.prepareStatement(sql.toString());

      pstmt.execute();

      // Commit the insert

      dbconn.commit();

        pStmt = dbConn.prepareStatement("INSERT INTO xml_replication " +

                      "(server, last_checked, replicate, datareplicate, hub) " +

                       "VALUES ('" + server + "', " + 

                       replicate +"', '"+dataReplicate+"','"+ hub + "')");

        pStmt.execute();

        dbConn.commit();

         sql.append(dbAdapter.toDate(datestr, "MM/DD/YY HH24:MI:SS"));

         sql.append(" where server like '").append(server).append("'");

         pstmt = dbConn.prepareStatement(sql.toString());

         pstmt.executeUpdate();

         dbConn.commit();

         pstmt.close();

        pStmt = dbConn.prepareStatement("INSERT INTO xml_replication " +

                      "(server, last_checked, replicate, datareplicate, hub) "+

                       "VALUES ('" + givenServerName + "', "+

                       replicate +"', '"+dataReplicate+"','"+ hub + "')");

        pStmt.execute();

        pStmt.close();

      }//try

      catch (Exception e)