KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > opencms > db > mssql > CmsBackupDriver


1 /*
2  * File : $Source: /usr/local/cvs/opencms/src/org/opencms/db/mssql/CmsBackupDriver.java,v $
3  * Date : $Date: 2006/03/27 14:52:44 $
4  * Version: $Revision: 1.2 $
5  *
6  * This library is part of OpenCms -
7  * the Open Source Content Mananagement System
8  *
9  * Copyright (c) 2005 Alkacon Software GmbH (http://www.alkacon.com)
10  *
11  * This library is free software; you can redistribute it and/or
12  * modify it under the terms of the GNU Lesser General Public
13  * License as published by the Free Software Foundation; either
14  * version 2.1 of the License, or (at your option) any later version.
15  *
16  * This library is distributed in the hope that it will be useful,
17  * but WITHOUT ANY WARRANTY; without even the implied warranty of
18  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
19  * Lesser General Public License for more details.
20  *
21  * For further information about Alkacon Software GmbH, please see the
22  * company website: http://www.alkacon.com
23  *
24  * For further information about OpenCms, please see the
25  * project website: http://www.opencms.org
26  *
27  * You should have received a copy of the GNU Lesser General Public
28  * License along with this library; if not, write to the Free Software
29  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
30  */
31
32 package org.opencms.db.mssql;
33
34 import org.opencms.db.CmsDbContext;
35 import org.opencms.db.CmsDbSqlException;
36 import org.opencms.db.CmsDbUtil;
37 import org.opencms.db.generic.CmsSqlManager;
38 import org.opencms.file.CmsBackupProject;
39 import org.opencms.file.CmsDataAccessException;
40 import org.opencms.util.CmsUUID;
41
42 import java.sql.Connection JavaDoc;
43 import java.sql.PreparedStatement JavaDoc;
44 import java.sql.ResultSet JavaDoc;
45 import java.sql.SQLException JavaDoc;
46 import java.util.ArrayList JavaDoc;
47 import java.util.List JavaDoc;
48
49 /**
50  * MS SQL implementation of the backup driver methods.<p>
51  *
52  * @author Andras Balogh
53  *
54  * @version $Revision: 1.2 $
55  *
56  * @since 6.0.0
57  */
58 public class CmsBackupDriver extends org.opencms.db.generic.CmsBackupDriver {
59
60     /**
61      * @see org.opencms.db.I_CmsBackupDriver#initSqlManager(String)
62      */
63     public org.opencms.db.generic.CmsSqlManager initSqlManager(String JavaDoc classname) {
64
65         return CmsSqlManager.getInstance(classname);
66     }
67
68     /**
69      * @see org.opencms.db.I_CmsBackupDriver#readBackupProjects(org.opencms.db.CmsDbContext)
70      */
71     public List JavaDoc readBackupProjects(CmsDbContext dbc) throws CmsDataAccessException {
72
73         List JavaDoc projects = new ArrayList JavaDoc();
74         ResultSet JavaDoc res = null;
75         PreparedStatement JavaDoc stmt = null;
76         Connection JavaDoc conn = null;
77
78         try {
79             // create the statement
80 conn = m_sqlManager.getConnection(dbc);
81             stmt = m_sqlManager.getPreparedStatement(conn, "C_PROJECTS_READLAST_BACKUP");
82             stmt.setInt(1, 300);
83             res = stmt.executeQuery();
84             while (res.next()) {
85                 List JavaDoc resources = m_driverManager.getBackupDriver().readBackupProjectResources(
86                     dbc,
87                     res.getInt("PUBLISH_TAG"));
88                 projects.add(new CmsBackupProject(
89                     res.getInt("PUBLISH_TAG"),
90                     res.getInt("PROJECT_ID"),
91                     res.getString("PROJECT_NAME"),
92                     res.getString("PROJECT_DESCRIPTION"),
93                     res.getInt("TASK_ID"),
94                     new CmsUUID(res.getString("USER_ID")),
95                     new CmsUUID(res.getString("GROUP_ID")),
96                     new CmsUUID(res.getString("MANAGERGROUP_ID")),
97                     res.getLong("DATE_CREATED"),
98                     res.getInt("PROJECT_TYPE"),
99                     CmsDbUtil.getTimestamp(res, "PROJECT_PUBLISHDATE"),
100                     new CmsUUID(res.getString("PROJECT_PUBLISHED_BY")),
101                     res.getString("PROJECT_PUBLISHED_BY_NAME"),
102                     res.getString("USER_NAME"),
103                     res.getString("GROUP_NAME"),
104                     res.getString("MANAGERGROUP_NAME"),
105                     resources));
106             }
107         } catch (SQLException JavaDoc e) {
108             throw new CmsDbSqlException(org.opencms.db.generic.Messages.get().container(
109                 org.opencms.db.generic.Messages.ERR_GENERIC_SQL_1,
110                 CmsDbSqlException.getErrorQuery(stmt)), e);
111         } finally {
112             m_sqlManager.closeAll(dbc, conn, stmt, res);
113         }
114         return (projects);
115     }
116 }
Popular Tags