1   /**
2    * Copyright (c) 2000-2009 Liferay, Inc. All rights reserved.
3    *
4    * The contents of this file are subject to the terms of the Liferay Enterprise
5    * Subscription License ("License"). You may not use this file except in
6    * compliance with the License. You can obtain a copy of the License by
7    * contacting Liferay, Inc. See the License for the specific language governing
8    * permissions and limitations under the License, including but not limited to
9    * distribution rights of the Software.
10   *
11   * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
12   * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
13   * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
14   * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
15   * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
16   * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
17   * SOFTWARE.
18   */
19  
20  package com.liferay.portal.service.impl;
21  
22  import com.liferay.portal.SystemException;
23  import com.liferay.portal.kernel.dao.jdbc.DataAccess;
24  import com.liferay.portal.kernel.log.Log;
25  import com.liferay.portal.kernel.log.LogFactoryUtil;
26  import com.liferay.portal.service.base.QuartzLocalServiceBaseImpl;
27  import com.liferay.portal.tools.sql.DBUtil;
28  
29  import java.sql.Connection;
30  import java.sql.PreparedStatement;
31  import java.sql.ResultSet;
32  
33  /**
34   * <a href="QuartzLocalServiceImpl.java.html"><b><i>View Source</i></b></a>
35   *
36   * @author Brian Wing Shun Chan
37   *
38   */
39  public class QuartzLocalServiceImpl extends QuartzLocalServiceBaseImpl {
40  
41      public void checkQuartzTables() throws SystemException {
42          Connection con = null;
43          PreparedStatement ps = null;
44          ResultSet rs = null;
45  
46          try {
47              con = DataAccess.getConnection();
48  
49              ps = con.prepareStatement(
50                  "select count(*) from QUARTZ_JOB_DETAILS");
51  
52              rs = ps.executeQuery();
53  
54              if (rs.next()) {
55                  return;
56              }
57          }
58          catch (Exception e) {
59              if (_log.isWarnEnabled()) {
60                  _log.warn(e.getMessage());
61              }
62          }
63          finally {
64              DataAccess.cleanUp(con, ps, rs);
65          }
66  
67          DBUtil dbUtil = DBUtil.getInstance();
68  
69          try {
70              dbUtil.runSQLTemplate("quartz-tables.sql", false);
71          }
72          catch (Exception e) {
73              throw new SystemException(e);
74          }
75      }
76  
77      private static Log _log =
78          LogFactoryUtil.getLog(QuartzLocalServiceImpl.class);
79  
80  }