1
22
23 package com.liferay.portal.service.impl;
24
25 import com.liferay.portal.SystemException;
26 import com.liferay.portal.kernel.dao.jdbc.DataAccess;
27 import com.liferay.portal.kernel.log.Log;
28 import com.liferay.portal.kernel.log.LogFactoryUtil;
29 import com.liferay.portal.service.base.QuartzLocalServiceBaseImpl;
30 import com.liferay.portal.tools.sql.DBUtil;
31
32 import java.sql.Connection;
33 import java.sql.PreparedStatement;
34 import java.sql.ResultSet;
35
36
41 public class QuartzLocalServiceImpl extends QuartzLocalServiceBaseImpl {
42
43 public void checkQuartzTables() throws SystemException {
44 Connection con = null;
45 PreparedStatement ps = null;
46 ResultSet rs = null;
47
48 try {
49 con = DataAccess.getConnection();
50
51 ps = con.prepareStatement(
52 "select count(*) from QUARTZ_JOB_DETAILS");
53
54 rs = ps.executeQuery();
55
56 if (rs.next()) {
57 return;
58 }
59 }
60 catch (Exception e) {
61 if (_log.isWarnEnabled()) {
62 _log.warn(e.getMessage());
63 }
64 }
65 finally {
66 DataAccess.cleanUp(con, ps, rs);
67 }
68
69 DBUtil dbUtil = DBUtil.getInstance();
70
71 try {
72 dbUtil.runSQLTemplate("quartz-tables.sql", false);
73 }
74 catch (Exception e) {
75 throw new SystemException(e);
76 }
77 }
78
79 private static Log _log =
80 LogFactoryUtil.getLog(QuartzLocalServiceImpl.class);
81
82 }