/** * The transactino code for saving a tool config. */ protected void saveToolConfigTx(ToolConfiguration tool) { // delete this tool and tool properties Object fields[] = new Object[2]; fields[0] = caseId(tool.getSiteId()); fields[1] = caseId(tool.getId()); String statement = siteServiceSql.getDeleteToolPropertySql(); m_sql.dbWrite(statement, fields); statement = siteServiceSql.getDeleteToolSql(); m_sql.dbWrite(statement, fields); // write the tool statement = siteServiceSql.getInsertToolSql(); fields = new Object[7]; fields[0] = tool.getId(); fields[1] = tool.getPageId(); fields[2] = caseId(tool.getSiteId()); fields[3] = tool.getToolId(); fields[4] = Integer.valueOf(tool.getPageOrder()); fields[5] = tool.getTitle(); fields[6] = tool.getLayoutHints(); m_sql.dbWrite(statement, fields); // write the tool's properties writeProperties("SAKAI_SITE_TOOL_PROPERTY", "TOOL_ID", tool.getId(), "SITE_ID", caseId(tool.getSiteId()), tool.getPlacementConfig()); }