Java tutorial
/* * This library is part of OpenCms - * the Open Source Content Management System * * Copyright (c) Alkacon Software GmbH (http://www.alkacon.com) * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * For further information about Alkacon Software GmbH, please see the * company website: http://www.alkacon.com * * For further information about OpenCms, please see the * project website: http://www.opencms.org * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ package org.opencms.db.oracle; import org.opencms.db.CmsDbContext; import org.opencms.db.CmsDbEntryNotFoundException; import org.opencms.db.CmsDbIoException; import org.opencms.db.CmsDbSqlException; import org.opencms.db.generic.CmsSqlManager; import org.opencms.db.generic.Messages; import org.opencms.file.CmsDataAccessException; import org.opencms.file.CmsProject; import org.opencms.main.OpenCms; import org.opencms.util.CmsUUID; import java.io.IOException; import java.io.OutputStream; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import org.apache.commons.dbcp.DelegatingResultSet; /** * Oracle implementation of the VFS driver methods.<p> * * @since 6.0.0 */ public class CmsVfsDriver extends org.opencms.db.generic.CmsVfsDriver { /** * @see org.opencms.db.I_CmsVfsDriver#createContent(CmsDbContext, CmsUUID, CmsUUID, byte[]) */ @Override public void createContent(CmsDbContext dbc, CmsUUID projectId, CmsUUID resourceId, byte[] content) throws CmsDataAccessException { Connection conn = null; PreparedStatement stmt = null; try { conn = m_sqlManager.getConnection(dbc); stmt = m_sqlManager.getPreparedStatement(conn, projectId, "C_ORACLE_OFFLINE_CONTENTS_WRITE"); // first insert new file without file_content, then update the file_content // these two steps are necessary because of using BLOBs in the Oracle DB stmt.setString(1, resourceId.toString()); stmt.executeUpdate(); } catch (SQLException e) { throw new CmsDbSqlException( Messages.get().container(Messages.ERR_GENERIC_SQL_1, CmsDbSqlException.getErrorQuery(stmt)), e); } finally { m_sqlManager.closeAll(dbc, conn, stmt, null); } // now update the file content internalWriteContent(dbc, projectId, resourceId, content, -1); } /** * @see org.opencms.db.generic.CmsVfsDriver#createOnlineContent(CmsDbContext, CmsUUID, byte[], int, boolean, boolean) */ @Override public void createOnlineContent(CmsDbContext dbc, CmsUUID resourceId, byte[] contents, int publishTag, boolean keepOnline, boolean needToUpdateContent) throws CmsDataAccessException { Connection conn = null; PreparedStatement stmt = null; try { conn = m_sqlManager.getConnection(dbc); boolean dbcHasProjectId = (dbc.getProjectId() != null) && !dbc.getProjectId().isNullUUID(); if (needToUpdateContent || dbcHasProjectId) { if (dbcHasProjectId || !OpenCms.getSystemInfo().isHistoryEnabled()) { // remove the online content for this resource id stmt = m_sqlManager.getPreparedStatement(conn, "C_ONLINE_CONTENTS_DELETE"); stmt.setString(1, resourceId.toString()); stmt.executeUpdate(); m_sqlManager.closeAll(dbc, null, stmt, null); } else { // put the online content in the history stmt = m_sqlManager.getPreparedStatement(conn, "C_ONLINE_CONTENTS_HISTORY"); stmt.setString(1, resourceId.toString()); stmt.executeUpdate(); m_sqlManager.closeAll(dbc, null, stmt, null); } // create new empty online content entry stmt = m_sqlManager.getPreparedStatement(conn, "C_ORACLE_ONLINE_CONTENTS_WRITE"); stmt.setString(1, resourceId.toString()); stmt.setInt(2, publishTag); stmt.setInt(3, publishTag); stmt.setInt(4, keepOnline ? 1 : 0); stmt.executeUpdate(); m_sqlManager.closeAll(dbc, conn, stmt, null); // now update the file content internalWriteContent(dbc, CmsProject.ONLINE_PROJECT_ID, resourceId, contents, publishTag); } else { // update old content entry stmt = m_sqlManager.getPreparedStatement(conn, "C_HISTORY_CONTENTS_UPDATE"); stmt.setInt(1, publishTag); stmt.setString(2, resourceId.toString()); stmt.executeUpdate(); m_sqlManager.closeAll(dbc, null, stmt, null); if (!keepOnline) { // put the online content in the history stmt = m_sqlManager.getPreparedStatement(conn, "C_ONLINE_CONTENTS_HISTORY"); stmt.setString(1, resourceId.toString()); stmt.executeUpdate(); m_sqlManager.closeAll(dbc, null, stmt, null); } } } catch (SQLException e) { throw new CmsDbSqlException( Messages.get().container(Messages.ERR_GENERIC_SQL_1, CmsDbSqlException.getErrorQuery(stmt)), e); } finally { m_sqlManager.closeAll(dbc, conn, stmt, null); } } /** * @see org.opencms.db.I_CmsVfsDriver#initSqlManager(String) */ @Override public org.opencms.db.generic.CmsSqlManager initSqlManager(String classname) { return CmsSqlManager.getInstance(classname); } /** * @see org.opencms.db.I_CmsVfsDriver#writeContent(CmsDbContext, CmsUUID, byte[]) */ @Override public void writeContent(CmsDbContext dbc, CmsUUID resourceId, byte[] content) throws CmsDataAccessException { internalWriteContent(dbc, dbc.currentProject().getUuid(), resourceId, content, -1); } /** * Writes the resource content with the specified resource id.<p> * * @param dbc the current database context * @param projectId the id of the current project * @param resourceId the id of the resource used to identify the content to update * @param contents the new content of the file * @param publishTag the publish tag if to be written to the online content * * @throws CmsDataAccessException if something goes wrong */ protected void internalWriteContent(CmsDbContext dbc, CmsUUID projectId, CmsUUID resourceId, byte[] contents, int publishTag) throws CmsDataAccessException { PreparedStatement stmt = null; PreparedStatement commit = null; Connection conn = null; ResultSet res = null; boolean wasInTransaction = false; try { conn = m_sqlManager.getConnection(dbc); if (projectId.equals(CmsProject.ONLINE_PROJECT_ID)) { stmt = m_sqlManager.getPreparedStatement(conn, projectId, "C_ORACLE_ONLINE_CONTENTS_UPDATECONTENT"); } else { stmt = m_sqlManager.getPreparedStatement(conn, projectId, "C_ORACLE_OFFLINE_CONTENTS_UPDATECONTENT"); } wasInTransaction = !conn.getAutoCommit(); if (!wasInTransaction) { conn.setAutoCommit(false); } // update the file content in the contents table stmt.setString(1, resourceId.toString()); if (projectId.equals(CmsProject.ONLINE_PROJECT_ID)) { stmt.setInt(2, publishTag); stmt.setInt(3, publishTag); } res = ((DelegatingResultSet) stmt.executeQuery()).getInnermostDelegate(); if (!res.next()) { throw new CmsDbEntryNotFoundException( Messages.get().container(Messages.LOG_READING_RESOURCE_1, resourceId)); } // write file content OutputStream output = CmsUserDriver.getOutputStreamFromBlob(res, "FILE_CONTENT"); output.write(contents, 0, contents.length); output.close(); if (!wasInTransaction) { commit = m_sqlManager.getPreparedStatement(conn, "C_COMMIT"); commit.execute(); m_sqlManager.closeAll(dbc, null, commit, null); } m_sqlManager.closeAll(dbc, null, stmt, res); // this is needed so the finally block works correctly commit = null; stmt = null; res = null; if (!wasInTransaction) { conn.setAutoCommit(true); } } catch (IOException e) { throw new CmsDbIoException( Messages.get().container(Messages.ERR_WRITING_TO_OUTPUT_STREAM_1, resourceId), e); } catch (SQLException e) { throw new CmsDbSqlException(org.opencms.db.generic.Messages.get().container( org.opencms.db.generic.Messages.ERR_GENERIC_SQL_1, CmsDbSqlException.getErrorQuery(stmt)), e); } finally { org.opencms.db.oracle.CmsSqlManager.closeAllInTransaction(m_sqlManager, dbc, conn, stmt, res, commit, wasInTransaction); } } }