public void updateJournalNote(DocumentNote documentNote) throws Exception { kLogger.fine("Updating journal notes id=" + documentNote.getNoteId()); Connection connection = ConnectionPoolManager.getInstance().getConnection(); PreparedStatement psUpdate = connection.prepareStatement(SQL_UPDATE_JOURNALNOTE); int i = 1; psUpdate.setString(i++, documentNote.getNoteData()); psUpdate.setString(i++, documentNote.getUserName().toUpperCase()); psUpdate.setString(i++, documentNote.getCreated()); if (documentNote.isActive()) { psUpdate.setString(i++, "Y"); } else { psUpdate.setString(i++, "N"); } psUpdate.setInt(i++, documentNote.getDocumentId()); psUpdate.setString(i++, documentNote.getNoteType()); psUpdate.setInt(i++, documentNote.getNoteId()); int recCount = psUpdate.executeUpdate(); psUpdate.close(); connection.commit(); connection.close(); if (recCount == 0) { kLogger.warning("Unable to update journal notes id=" + documentNote.getNoteId()); throw new Exception("Unable to update journal notes id=" + documentNote.getNoteId()); } }