/** * Removes a new process instance * * @param instanceId instance id */ public void removeProcessInstance(String instanceId) throws WorkflowException { SilverTrace.info( "worflowEngine", "ProcessInstanceManagerImpl.removeProcessInstance()", "root.MSG_GEN_ENTER_METHOD", "InstanceId=" + instanceId); ProcessInstanceImpl instance; Database db = null; try { // Delete forms data associated with this instance removeProcessInstanceData(instanceId); // Constructs the query db = WorkflowJDOManager.getDatabase(); db.begin(); instance = (ProcessInstanceImpl) db.load(ProcessInstanceImpl.class, instanceId); db.remove(instance); db.commit(); } catch (PersistenceException pe) { throw new WorkflowException( "ProcessInstanceManagerImpl.removeProcessInstance", "EX_ERR_CASTOR_REMOVE_INSTANCE", pe); } finally { WorkflowJDOManager.closeDatabase(db); } WorkflowHub.getErrorManager().removeErrorsOfInstance(instanceId); SilverTrace.info( "worflowEngine", "ProcessInstanceManagerImpl.removeProcessInstance()", "root.MSG_GEN_EXIT_METHOD"); }
/** * Method declaration * * @param id * @param percent * @throws TodoException * @see */ public void setToDoPercentCompleted(String id, String percent) throws TodoException { SilverTrace.info( "todo", "ToDoSessionController.setToDoPercentCompleted()", "root.MSG_GEN_ENTER_METHOD"); ToDoHeader todo = getToDoHeader(id); try { todo.setPercentCompleted(new Integer(percent).intValue()); } catch (Exception e) { SilverTrace.warn( "todo", "ToDoSessionController.setToDoPercentCompleted()", "todo.MSG_CANT_SET_TODO_PERCENTCOMPLETED"); } try { calendarBm.updateToDo(todo); SilverTrace.info( "todo", "ToDoSessionController.setToDoPercentCompleted()", "root.MSG_GEN_EXIT_METHOD"); } catch (Exception e) { throw new TodoException( "ToDoSessionController.setToDoPercentCompleted()", SilverpeasException.ERROR, "todo.MSG_CANT_UPDATE_TODO_DETAIL", e); } }
public Vector<AttachmentDetail> getAttachmentsByPKAndContext( AttachmentPK foreignKey, String context, Connection con) throws AttachmentException { if (con == null) { SilverTrace.info( "attachment", "AttachmentBmImpl.getAttachmentsByPKAndContext()", "root.MSG_GEN_PARAM_VALUE", "parameter con is null, new connection is created !"); con = getConnection(); } else { SilverTrace.info( "attachment", "AttachmentBmImpl.getAttachmentsByPKAndContext()", "root.MSG_GEN_PARAM_VALUE", "parameter con is not null, this connection is used !"); } try { return dao.findByPKAndContext(con, foreignKey, context); } catch (SQLException se) { throw new AttachmentException( "AttachmentBmImpl.createAttachment()", SilverpeasException.ERROR, "attachment.EX_RECORD_NOT_LOAD", se); } finally { closeConnection(con); } }
public Collection<SimpleDocument> getAttachments() { if (getPK() == null) { SilverTrace.info( "publication", "PublicationDetail.getAttachments()", "root.MSG_GEN_ENTER_METHOD", "getPK() is null !"); } else { SilverTrace.info( "publication", "PublicationDetail.getAttachments()", "root.MSG_GEN_ENTER_METHOD", "getPK() is not null !"); } AttachmentPK foreignKey = new AttachmentPK(getPK().getId(), getPK().getSpace(), getPK().getComponentName()); SilverTrace.info( "publication", "PublicationDetail.getAttachments()", "root.MSG_GEN_PARAM_VALUE", "foreignKey = " + foreignKey.toString()); Collection<SimpleDocument> attachmentList = AttachmentServiceFactory.getAttachmentService() .listDocumentsByForeignKeyAndType(foreignKey, DocumentType.attachment, null); SilverTrace.info( "publication", "PublicationDetail.getAttachments()", "root.MSG_GEN_PARAM_VALUE", "attachmentList.size() = " + attachmentList.size()); return attachmentList; }
public String getFieldValue(String fieldNameAndLanguage) { SilverTrace.info( "publication", "PublicationDetail.getModelContent()", "root.MSG_GEN_ENTER_METHOD", "fieldNameAndLanguage = " + fieldNameAndLanguage); String[] params = fieldNameAndLanguage.split(","); String fieldName = params[0]; String language = null; if (params.length > 1) { language = params[1]; } String fieldValue = ""; List<XMLField> xmlFieldsForLanguage = getXmlFields(language); for (XMLField xmlField : xmlFieldsForLanguage) { if (fieldName.equals(xmlField.getName())) { fieldValue = getValueOfField(xmlField, language); } } SilverTrace.info( "publication", "PublicationDetail.getModelContent('" + fieldName + "')", "root.MSG_GEN_EXIT_METHOD", "fieldValue = " + fieldValue); return fieldValue; }
/** * Indexes one space * * @param spaceId space identifier * @throws Exception whether an exception occurred */ public void indexSpace(String spaceId) throws Exception { SilverTrace.info( ApplicationDYMIndexer.class.toString(), "ApplicationDYMIndexer.indexSpace()", "applicationIndexer.MSG_START_INDEXING_SPACE", "spaceId = " + spaceId); if (spaceId.startsWith(Admin.SPACE_KEY_PREFIX)) { spaceId = spaceId.substring(2); } // index space info admin.indexSpace(Integer.parseInt(spaceId)); // index components String[] componentIds = organizationController.getAllComponentIds(spaceId); for (String componentId : componentIds) { indexComponent(spaceId, componentId); } // index sub spaces String[] subSpaceIds = organizationController.getAllSubSpaceIds(spaceId); for (String subSpaceId : subSpaceIds) { indexSpace(subSpaceId); } SilverTrace.info( ApplicationDYMIndexer.class.toString(), "ApplicationDYMIndexer.indexSpace()", "applicationIndexer.MSG_END_INDEXING_SPACE", "spaceId = " + spaceId); }
public void index(String currentSpaceId, String componentId) throws Exception { setSilverTraceLevel(); SilverTrace.info( "applicationIndexer", "ApplicationIndexer.index()", "root.MSG_GEN_ENTER_METHOD"); if (currentSpaceId == null) { // index whole application String[] spaceIds = organizationController.getAllSpaceIds(); SilverTrace.info( "applicationIndexer", "ApplicationIndexer.index()", "applicationIndexer.MSG_INDEXING_ALL_SPACES"); for (String spaceId : spaceIds) { indexSpace(spaceId); } } else { if (!StringUtil.isDefined(componentId)) { // index whole space indexSpace(currentSpaceId); } else { // index only one component indexComponent(currentSpaceId, componentId); } } SilverTrace.info( "applicationIndexer", "ApplicationIndexer.index()", "root.MSG_GEN_EXIT_METHOD"); }
@Override public void update(Connection connection, T bean) throws PersistenceException { Connection con; if (connection == null) { con = getConnection(); } else { con = connection; } PreparedStatement prepStmt = null; try { String statement = null; for (PropertyDescriptor property : properties) { String type = property.getPropertyType().getName(); SilverTrace.info( "persistence", "SilverpeasBeanDAOImpl.update(SilverpeasBean bean)", "root.MSG_GEN_PARAM_VALUE", "property Name = " + property.getName() + ", type = " + type); if (isTypeValid(type) == true) { if (statement == null) { statement = property.getName() + " = ? "; } else { statement += ", " + property.getName() + " = ? "; } } } String updateStatement = "update " + getTableName(bean.getPK()) + " set " + statement + " where id = ?"; prepStmt = con.prepareStatement(updateStatement); SilverTrace.info( "persistence", "SilverpeasBeanDAOImpl.update(SilverpeasBean bean)", "root.MSG_GEN_PARAM_VALUE", "queryStr = " + updateStatement + ", id= " + bean.getPK().getId()); int count = prepareStatementSetProperties(prepStmt, bean); // for the where clause prepStmt.setInt(count, Integer.parseInt(bean.getPK().getId())); prepStmt.executeUpdate(); } catch (Exception e) { throw new PersistenceException( "SilverpeasBeanDAOImpl.update(SilverpeasBean bean) ", SilverpeasException.ERROR, "persistence.EX_CANT_UPDATE_OBJECT", "", e); } finally { DBUtil.close(prepStmt); if (connection == null) { DBUtil.close(con); } } }
public Group[] getAllChangedGroups(String lds, String extraFilter) throws AdminException { Vector<LDAPEntry> groupsCur; Iterator<LDAPEntry> it; int i; Hashtable<String, Group> groupsManaged = new Hashtable<String, Group>(); LDAPEntry[] les = getChildGroupsEntry(lds, null, extraFilter); LDAPEntry theGroup; Vector<LDAPEntry> groupsIdsSet = new Vector<LDAPEntry>(les.length); for (i = 0; i < les.length; i++) { groupsIdsSet.add(les[i]); groupsManaged.put(les[i].getDN(), translateGroup(lds, les[i])); } // Go recurs to all group's ancestors while (groupsIdsSet.size() > 0) { it = groupsIdsSet.iterator(); groupsCur = new Vector<LDAPEntry>(); while (it.hasNext()) { theGroup = it.next(); SilverTrace.info( "admin", "LDAPGroupSamse.getAllChangedGroups()", "root.MSG_GEN_PARAM_VALUE", "GroupTraite2=" + theGroup.getDN()); les = LDAPUtility.search1000Plus( lds, driverSettings.getGroupsSpecificGroupsBaseDN(), driverSettings.getScope(), "(&" + driverSettings.getGroupsFullFilter() + "(" + driverSettings.getGroupsMemberField() + "=" + LDAPUtility.dblBackSlashesForDNInFilters(theGroup.getDN()) + "))", driverSettings.getGroupsNameField(), driverSettings.getGroupAttributes()); for (i = 0; i < les.length; i++) { SilverTrace.info( "admin", "LDAPGroupSamse.getAllChangedGroups()", "root.MSG_GEN_PARAM_VALUE", "GroupFound2=" + les[i].getDN()); if (!groupsManaged.containsKey(les[i].getDN())) { SilverTrace.info( "admin", "LDAPGroupSamse.getAllChangedGroups()", "root.MSG_GEN_PARAM_VALUE", "GroupAjoute2=" + les[i].getDN()); groupsCur.add(les[i]); groupsManaged.put(les[i].getDN(), translateGroup(lds, les[i])); } } } groupsIdsSet = groupsCur; } return groupsManaged.values().toArray(new Group[groupsManaged.size()]); }
/** * Method declaration * * @throws TodoException * @see */ public void indexAll() throws TodoException { SilverTrace.info("todo", "ToDoSessionController.indexAll()", "root.MSG_GEN_ENTER_METHOD"); try { calendarBm.indexAllTodo(); SilverTrace.info("todo", "ToDoSessionController.indexAll()", "root.MSG_GEN_EXIT_METHOD"); } catch (Exception e) { throw new TodoException( "ToDoSessionController.indexAll()", SilverpeasException.ERROR, "todo.MSG_CANT_INDEX_TODOS", e); } }
/** * Method declaration * * @param id * @throws TodoException * @see */ public void removeToDo(String id) throws TodoException { SilverTrace.info("todo", "ToDoSessionController.removeToDo()", "root.MSG_GEN_ENTER_METHOD"); try { calendarBm.removeToDo(id); SilverTrace.info("todo", "ToDoSessionController.removeToDo()", "root.MSG_GEN_EXIT_METHOD"); } catch (Exception e) { throw new TodoException( "ToDoSessionController.removeToDo()", SilverpeasException.ERROR, "todo.MSG_CANT_REMOVE_TODO", e); } }
@Override public void create(Connection con, String spaceId, String componentId, String userId) throws InstanciationException { SilverTrace.info( "almanach", "AlmanachInstanciator.create()", "almanach.MSG_CREATE_WITH_SPACE_AND_COMPONENT", "space : " + spaceId + "component : " + componentId); AttachmentInstanciator ai = new AttachmentInstanciator("com.stratelia.webactiv.almanach"); ai.create(con, spaceId, componentId, userId); SilverTrace.info("almanach", "AlmanachInstanciator.create()", "root.MSG_GEN_EXIT_METHOD"); }
@Override public void delete(Connection con, String spaceId, String componentId, String userId) throws InstanciationException { SilverTrace.info( "mailingList", "MailingListInstanciator.delete()", "root.MSG_GEN_ENTER_METHOD", "space = " + spaceId + ", componentId = " + componentId + ", userId =" + userId); ServicesFactory servicesFactory = ServicesFactory.getFactory(); servicesFactory.getMailingListService().deleteMailingList(componentId); SilverTrace.info("mailingList", "MailingListInstanciator.delete()", "root.MSG_GEN_EXIT_METHOD"); servicesFactory.getMessageChecker().removeListener(componentId); }
/** * Method declaration * * @param lds * @param groupEntry * @return * @throws AdminException * @see */ @Override protected String[] getUserIds(String lds, LDAPEntry groupEntry) throws AdminException { Vector<String> usersVector = new Vector<String>(); LDAPEntry userEntry = null; String[] stringVals = null; int i; SilverTrace.info( "admin", "LDAPGroupUniqueDescriptor.getUserIds()", "root.MSG_GEN_ENTER_METHOD"); stringVals = LDAPUtility.getAttributeValues(groupEntry, driverSettings.getGroupsMemberField()); for (i = 0; i < stringVals.length; i++) { try { // userEntry = LDAPUtility.getFirstEntryFromSearch(lds, // driverSettings.getLDAPUserBaseDN(), driverSettings.getScope(), "(&" + // driverSettings.getUsersFullFilter() + "(distinguishedName=" + // LDAPUtility.dblBackSlashesForDNInFilters(stringVals[i]) + "))"); userEntry = LDAPUtility.getFirstEntryFromSearch( lds, stringVals[i], driverSettings.getScope(), driverSettings.getUsersFullFilter(), driverSettings.getGroupAttributes()); if (userEntry != null) { String userSpecificId = LDAPUtility.getFirstAttributeValue(userEntry, driverSettings.getUsersIdField()); // Verify that the user exist in the scope if (LDAPUtility.getFirstEntryFromSearch( lds, driverSettings.getLDAPUserBaseDN(), driverSettings.getScope(), driverSettings.getUsersIdFilter(userSpecificId), driverSettings.getGroupAttributes()) != null) { usersVector.add(userSpecificId); } } } catch (AdminException e) { SilverTrace.error( "admin", "LDAPGroupUniqueDescriptor.getUserIds()", "admin.MSG_ERR_LDAP_GENERAL", "USER NOT FOUND : " + LDAPUtility.dblBackSlashesForDNInFilters(stringVals[i]), e); } } stringVals = null; SilverTrace.info("admin", "LDAPGroupUniqueDescriptor.getUserIds()", "root.MSG_GEN_EXIT_METHOD"); return usersVector.toArray(new String[usersVector.size()]); }
@Override public void delete(Connection con, String spaceId, String componentId, String userId) throws InstanciationException { SilverTrace.info( "almanach", "AlmanachInstanciator.delete()", "almanach.MSG_DELETE_WITH_SPACE", "spaceId : " + spaceId); setDeleteQueries(); deleteDataOfInstance(con, componentId, "Event"); AttachmentInstanciator ai = new AttachmentInstanciator("com.stratelia.webactiv.almanach"); ai.delete(con, spaceId, componentId, userId); SilverTrace.info("almanach", "AlmanachInstanciator.delete()", "root.MSG_GEN_EXIT_METHOD"); }
/** * Method declaration * * @param todoId * @return * @throws TodoException * @see */ public ToDoHeader getToDoHeader(String todoId) throws TodoException { SilverTrace.info("todo", "ToDoSessionController.getToDoHeader()", "root.MSG_GEN_ENTER_METHOD"); try { ToDoHeader result = calendarBm.getToDoHeader(todoId); SilverTrace.info("todo", "ToDoSessionController.getToDoHeader()", "root.MSG_GEN_EXIT_METHOD"); return result; } catch (Exception e) { throw new TodoException( "ToDoSessionController.getToDoHeader()", SilverpeasException.ERROR, "todo.MSG_CANT_GET_TODO_DETAIL", e); } }
/** * Method declaration * * @param todoId * @param userIds * @throws TodoException * @see */ public void setToDoAttendees(String todoId, String[] userIds) throws TodoException { SilverTrace.info( "todo", "ToDoSessionController.setToDoAttendees()", "root.MSG_GEN_ENTER_METHOD"); try { calendarBm.setToDoAttendees(todoId, userIds); SilverTrace.info( "todo", "ToDoSessionController.setToDoAttendees()", "root.MSG_GEN_EXIT_METHOD"); } catch (Exception e) { throw new TodoException( "ToDoSessionController.setToDoAttendees()", SilverpeasException.ERROR, "todo.MSG_CANT_SET_TODO_ATTENDEES", e); } }
@Override public void remove(Connection connection, WAPrimaryKey pk) throws PersistenceException { Connection con; if (connection == null) { con = getConnection(); } else { con = connection; } PreparedStatement prepStmt = null; try { String updateStatement = "delete from " + getTableName(pk) + " where id = ?"; prepStmt = con.prepareStatement(updateStatement); SilverTrace.info( "persistence", "SilverpeasBeanDAOImpl.remove(WAPrimaryKey pk)", "root.MSG_GEN_PARAM_VALUE", "queryStr = " + updateStatement + ", id= " + pk.getId()); prepStmt.setInt(1, Integer.parseInt(pk.getId())); prepStmt.executeUpdate(); } catch (SQLException e) { throw new PersistenceException( "SilverpeasBeanDAOImpl.remove(WAPrimaryKey pk)", SilverpeasException.ERROR, "persistence.EX_CANT_REMOVE_OBJECT", "", e); } finally { DBUtil.close(prepStmt); if (connection == null) { DBUtil.close(con); } } }
public void initFromServer(String lds, String baseDN, String filter, String fallbackSortBy) throws AdminException { SilverTrace.info("admin", "LDAPTimeStampMSAD.initFromServer()", "root.MSG_GEN_ENTER_METHOD"); LDAPEntry[] theEntries = LDAPUtility.search1000Plus( lds, baseDN, driverSettings.getScope(), "(&(" + driverSettings.getTimeStampVar() + ">=" + timeStamp + ")" + filter + ")", driverSettings.getTimeStampVar(), driverSettings.getGroupAttributes()); if (theEntries.length > 0) { // Problem is : the search1000Plus function sorts normaly by descending // order. BUT most LDAP server can't performs this type of order (like // Active Directory) // So, it may be ordered in the oposite way.... long firstVal = Long.parseLong( LDAPUtility.getFirstAttributeValue(theEntries[0], driverSettings.getTimeStampVar())); long lastVal = Long.parseLong( LDAPUtility.getFirstAttributeValue( theEntries[theEntries.length - 1], driverSettings.getTimeStampVar())); if (firstVal >= lastVal) { lTimeStamp = firstVal; } else { lTimeStamp = lastVal; } timeStamp = Long.toString(lTimeStamp); } }
public Vector<TodoDetail> getEntriesFromExternal( String spaceId, String componentId, String externalId) { SilverTrace.info( "calendar", "TodoBackboneAcess.getEntriesFromExternal(String spaceId, String componentId, String externalId)", "root.MSG_GEN_ENTER_METHOD", "spaceId=" + spaceId + ", componentId=" + componentId + ", externalId=" + externalId); try { Collection<ToDoHeader> headers = getCalendarBm().getExternalTodos(spaceId, componentId, externalId); Vector<TodoDetail> result = new Vector<TodoDetail>(); for (ToDoHeader header : headers) { TodoDetail detail = todoHeaderToDetail(header); Collection<Attendee> list = getCalendarBm().getToDoAttendees(detail.getId()); detail.setAttendees(new Vector<Attendee>(list)); result.add(detail); } return result; } catch (Exception e) { SilverTrace.error( "calendar", "TodoBackboneAcess.getEntriesFromExternal(String spaceId, String componentId, String externalId)", "calendar.MSG_CANT_GET", "return null", e); return null; } }
public void removeAttendeeToEntryFromExternal( String componentId, String externalId, String userId) { SilverTrace.info( "calendar", "TodoBackboneAcess.removeAttendeeToEntryFromExternal(String componentId, String externalId, String userId)", "root.MSG_GEN_ENTER_METHOD", "componentId=" + componentId + ", externalId=" + externalId + ", userId = " + userId); try { Attendee attendee = new Attendee(); attendee.setUserId(userId); Collection<ToDoHeader> headers = getCalendarBm().getExternalTodos("useless", componentId, externalId); for (ToDoHeader header : headers) { if (header != null) { getCalendarBm().removeToDoAttendee(header.getId(), attendee); } } } catch (Exception e) { SilverTrace.error( "calendar", "TodoBackboneAcess.removeAttendeeToEntryFromExternal(String componentId, String externalId)", "calendar.MSG_CANT_REMOVE", "return null", e); } }
/** * Method declaration * * @param con * @param statsType * @param conf * @throws SQLException * @see */ static void purgeTablesCumul(Connection con, StatType statsType, StatisticsConfig conf) throws SQLException { StringBuilder deleteStatementBuf = new StringBuilder("DELETE FROM " + conf.getTableName(statsType) + "Cumul WHERE dateStat<"); PreparedStatement prepStmt = null; // compute the last date to delete from Calendar dateOfTheDay = Calendar.getInstance(); dateOfTheDay.add(Calendar.MONTH, -(conf.getPurge(statsType))); deleteStatementBuf.append( getRequestDate(dateOfTheDay.get(Calendar.YEAR), dateOfTheDay.get(Calendar.MONTH) + 1)); String deleteStatement = deleteStatementBuf.toString(); SilverTrace.info( "silverstatistics", "SilverStatisticsManagerDAO.purgeTablesCumul", "root.MSG_GEN_PARAM_VALUE", "deleteStatement=" + deleteStatement); try { prepStmt = con.prepareStatement(deleteStatement); prepStmt.executeUpdate(); } finally { DBUtil.close(prepStmt); } }
/** * Method declaration * * @return * @throws TodoException * @see */ public Collection getClosedToDos() throws TodoException { SilverTrace.info("todo", "ToDoSessionController.getClosedToDos()", "root.MSG_GEN_ENTER_METHOD"); try { Collection result = calendarBm.getClosedToDos(getUserId()); SilverTrace.info( "todo", "ToDoSessionController.getClosedToDos()", "root.MSG_GEN_EXIT_METHOD"); return result; } catch (Exception e) { throw new TodoException( "ToDoSessionController.getClosedToDos()", SilverpeasException.ERROR, "todo.MSG_CANT_GET_CLOSED_TODOS", e); } }
/** * Remove domain authentication and settings properties file * * @param domainToRemove domain to remove * @throws DomainDeletionException */ private void removeDomainPropertiesFile(Domain domainToRemove) throws DomainDeletionException { SilverTrace.info( "admin", "SQLDomainService.removeDomainAuthenticationPropertiesFile()", "root.MSG_GEN_ENTER_METHOD"); String domainName = domainToRemove.getName(); String domainPropertiesPath = FileRepositoryManager.getDomainPropertiesPath(domainName); String authenticationPropertiesPath = FileRepositoryManager.getDomainAuthenticationPropertiesPath(domainName); File domainPropertiesFile = new File(domainPropertiesPath); File authenticationPropertiesFile = new File(authenticationPropertiesPath); boolean domainPropertiesFileDeleted = domainPropertiesFile.delete(); boolean authenticationPropertiesFileDeleted = authenticationPropertiesFile.delete(); if ((!domainPropertiesFileDeleted) || (!authenticationPropertiesFileDeleted)) { SilverTrace.warn( "admin", "SQLDomainService.removeDomainAuthenticationPropertiesFile()", "admin.EX_DELETE_DOMAIN_PROPERTIES", "domainPropertiesFileDeleted:" + domainPropertiesFileDeleted + ", authenticationPropertiesFileDeleted:" + authenticationPropertiesFileDeleted); } }
/** * Method declaration * * @param id * @throws TodoException * @see */ public void reopenToDo(String id) throws TodoException { SilverTrace.info("todo", "ToDoSessionController.reopenToDo()", "root.MSG_GEN_ENTER_METHOD"); ToDoHeader todo = getToDoHeader(id); todo.setCompletedDate(null); try { calendarBm.updateToDo(todo); SilverTrace.info("todo", "ToDoSessionController.reopenToDo()", "root.MSG_GEN_EXIT_METHOD"); } catch (Exception e) { throw new TodoException( "ToDoSessionController.reopenToDo()", SilverpeasException.ERROR, "todo.MSG_CANT_UPDATE_TODO_DETAIL", e); } }
/** * Method declaration * * @param con * @param questionContainerPK * @throws SQLException * @see */ public static void openQuestionContainer(Connection con, QuestionContainerPK questionContainerPK) throws SQLException { SilverTrace.info( "questionContainer", "QuestionContainerDAO.openQuestionContainer()", "root.MSG_GEN_ENTER_METHOD", "questionContainerPK = " + questionContainerPK); String updateStatement = "update " + questionContainerPK.getTableName() + " set qcIsClosed = 0 , instanceId = ?" + " where qcId = ? "; PreparedStatement prepStmt = null; try { prepStmt = con.prepareStatement(updateStatement); prepStmt.setString(1, questionContainerPK.getComponentName()); prepStmt.setInt(2, Integer.parseInt(questionContainerPK.getId())); prepStmt.executeUpdate(); } finally { DBUtil.close(prepStmt); } }
/** * Method declaration * * @param con * @param questionContainerPK * @return * @throws SQLException * @see */ public static QuestionContainerHeader getQuestionContainerHeader( Connection con, QuestionContainerPK questionContainerPK) throws SQLException { SilverTrace.info( "questionContainer", "QuestionContainerDAO.getQuestionContainerHeader()", "root.MSG_GEN_ENTER_METHOD", "questionContainerPK = " + questionContainerPK); ResultSet rs = null; QuestionContainerHeader questionContainerHeader = null; String selectStatement = "select " + QUESTIONCONTAINERCOLUMNNAMES + " from " + questionContainerPK.getTableName() + " where qcId = ? "; PreparedStatement prepStmt = null; try { prepStmt = con.prepareStatement(selectStatement); prepStmt.setInt(1, Integer.parseInt(questionContainerPK.getId())); rs = prepStmt.executeQuery(); if (rs.next()) { questionContainerHeader = getQuestionContainerHeaderFromResultSet(rs, questionContainerPK); } } finally { DBUtil.close(rs, prepStmt); } return questionContainerHeader; }
/** * Method declaration * * @param con * @param qcPK * @return * @throws SQLException * @see */ public static Collection<QuestionContainerHeader> getInWaitQuestionContainers( Connection con, QuestionContainerPK qcPK) throws SQLException { SilverTrace.info( "questionContainer", "QuestionContainerDAO.getInWaitQuestionContainers()", "root.MSG_GEN_ENTER_METHOD", "qcPK = " + qcPK); ResultSet rs = null; QuestionContainerHeader header = null; String selectStatement = "select " + QUESTIONCONTAINERCOLUMNNAMES + " from " + qcPK.getTableName() + " where ? < qcBeginDate and instanceId = ?"; PreparedStatement prepStmt = null; try { prepStmt = con.prepareStatement(selectStatement); prepStmt.setString(1, formatter.format(new java.util.Date())); prepStmt.setString(2, qcPK.getComponentName()); rs = prepStmt.executeQuery(); List<QuestionContainerHeader> list = new ArrayList<QuestionContainerHeader>(); while (rs.next()) { header = getQuestionContainerHeaderFromResultSet(rs, qcPK); list.add(header); } return list; } finally { DBUtil.close(rs, prepStmt); } }
/** * Method declaration * * @param con * @param questionContainerHeader * @throws SQLException * @see */ public static void updateQuestionContainerHeader( Connection con, QuestionContainerHeader questionContainerHeader) throws SQLException { SilverTrace.info( "questionContainer", "QuestionContainerDAO.updateQuestionContainerHeader()", "root.MSG_GEN_ENTER_METHOD", "questionContainerHeader = " + questionContainerHeader); String insertStatement = "update " + questionContainerHeader.getPK().getTableName() + " set qcTitle = ?," + " qcDescription = ?," + " qcComment = ?," + " qcBeginDate = ?," + " qcEndDate = ?," + " qcNbVoters = ?," + " qcNbQuestionsPage = ?," + " qcNbMaxParticipations = ?," + " qcNbTriesBeforeSolution = ?," + " qcMaxTime = ?, " + " instanceId = ?, " + " anonymous = ?" + " where qcId = ?"; PreparedStatement prepStmt = null; try { prepStmt = con.prepareStatement(insertStatement); prepStmt.setString(1, questionContainerHeader.getTitle()); prepStmt.setString(2, questionContainerHeader.getDescription()); prepStmt.setString(3, questionContainerHeader.getComment()); if (questionContainerHeader.getBeginDate() == null) { prepStmt.setString(4, nullBeginDate); } else { prepStmt.setString(4, questionContainerHeader.getBeginDate()); } if (questionContainerHeader.getEndDate() == null) { prepStmt.setString(5, nullEndDate); } else { prepStmt.setString(5, questionContainerHeader.getEndDate()); } prepStmt.setInt(6, questionContainerHeader.getNbVoters()); prepStmt.setInt(7, questionContainerHeader.getNbQuestionsPerPage()); prepStmt.setInt(8, questionContainerHeader.getNbMaxParticipations()); prepStmt.setInt(9, questionContainerHeader.getNbParticipationsBeforeSolution()); prepStmt.setInt(10, questionContainerHeader.getMaxTime()); prepStmt.setString(11, questionContainerHeader.getPK().getComponentName()); if (questionContainerHeader.isAnonymous()) { prepStmt.setInt(12, 1); } else { prepStmt.setInt(12, 0); } prepStmt.setInt(13, Integer.parseInt(questionContainerHeader.getPK().getId())); prepStmt.executeUpdate(); } finally { DBUtil.close(prepStmt); } }
public synchronized void addSubscription() { SilverTrace.info( "webPages", "WebPagesSessionController.addSubscription()", "root.MSG_GEN_ENTER_METHOD"); if (isSubscriber()) { return; } getSubscribeBm().subscribe(new ComponentSubscription(getUserId(), getComponentId())); }