Subversion Repositories XServices

Rev

Rev 198 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
72 brianR 1
/*
2
 *   Copyright 2011 Brian Rosenberger (Brutex Network)
3
 *
4
 *   Licensed under the Apache License, Version 2.0 (the "License");
5
 *   you may not use this file except in compliance with the License.
6
 *   You may obtain a copy of the License at
7
 *
8
 *       http://www.apache.org/licenses/LICENSE-2.0
9
 *
10
 *   Unless required by applicable law or agreed to in writing, software
11
 *   distributed under the License is distributed on an "AS IS" BASIS,
12
 *   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13
 *   See the License for the specific language governing permissions and
14
 *   limitations under the License.
15
 */
16
 
17
package net.brutex.xservices.util;
18
 
19
import java.io.BufferedReader;
20
import java.io.File;
21
import java.io.FileNotFoundException;
22
import java.io.FileReader;
23
import java.io.IOException;
24
import java.sql.Connection;
25
import java.sql.DatabaseMetaData;
26
import java.sql.DriverManager;
27
import java.sql.ResultSet;
28
import java.sql.SQLException;
29
import java.sql.Statement;
30
import java.util.ArrayList;
31
import java.util.List;
32
 
199 brianR 33
 
34
import lombok.extern.slf4j.Slf4j;
72 brianR 35
import org.quartz.utils.ConnectionProvider;
36
 
37
/**
38
 * @author Brian Rosenberger
39
 *
40
 */
199 brianR 41
@Slf4j
72 brianR 42
public class BrutexHSQLQuartzConnectionProvider implements ConnectionProvider {
43
 
44
	private Connection conn = null;
199 brianR 45
 
72 brianR 46
 
47
 
48
	public Connection getConnection() throws SQLException {
113 brianR 49
		if( conn!= null ) { // Todo: && conn.conn.isValid(5)) {
199 brianR 50
			log.debug("Checking tables on pre-exisiting database connection.");
72 brianR 51
			checkTables();
52
			return conn;
53
		}
54
		try {
55
			// Class.forName("org.hsqldb.jdbc.JDBCDriver" );
56
			Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
57
		} catch (Exception e) {
199 brianR 58
			log.error("Failed to load Derby JDBC driver.");
72 brianR 59
			e.printStackTrace();
60
			return null;
61
		}
62
 
63
		if(isConnected(false)) {
64
			checkTables();
65
		} else {
66
			return null;
67
		}
68
 
69
		return conn;
70
	}
71
 
72
	public void shutdown() throws SQLException {
73
		try {
74
			// Class.forName("org.hsqldb.jdbc.JDBCDriver" );
75
			Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
76
		} catch (Exception e) {
77
			System.err.println("ERROR: failed to load Derby JDBC driver.");
78
			e.printStackTrace();
79
			return;
80
		}
81
		String t = this.getClass().getClassLoader().getResource("/").toString()
82
				.substring(6);
83
		t += "../data/db";
84
		System.out.println("Shut down embedded database now.");
85
		Connection c = DriverManager.getConnection("jdbc:derby:" + t
86
				+ ";shutdown=true;");
87
 
88
	}
89
 
198 brianR 90
	@Override
91
	public void initialize() throws SQLException {
92
 
93
	}
94
 
72 brianR 95
	private synchronized void recursiveDelete(File dbDir) {
96
		File[] files = dbDir.listFiles();
97
		for (int i = 0; i < files.length; i++) {
98
			if (files[i].isFile()) {
99
				files[i].delete();
100
			} else {
101
				recursiveDelete(files[i]);
102
				files[i].delete();
103
			}
104
		}
105
		dbDir.delete();
106
	}
107
 
108
	private synchronized void checkTables() throws SQLException {
199 brianR 109
		log.debug("Checking QUARTZ database schema.");
72 brianR 110
		if(!isConnected(false)) {
199 brianR 111
			log.error("Failed to validate QUARTZ database schema.");
72 brianR 112
			return;
113
		}
114
		List<String> ddl_list = new ArrayList<String>(11);
115
		ddl_list.add("QRTZ_JOB_DETAILS");
116
		ddl_list.add("QRTZ_TRIGGERS");
117
		ddl_list.add("QRTZ_SIMPLE_TRIGGERS");
118
		ddl_list.add("QRTZ_CRON_TRIGGERS");
119
		ddl_list.add("QRTZ_SIMPROP_TRIGGERS");
120
		ddl_list.add("QRTZ_BLOB_TRIGGERS");
121
		ddl_list.add("QRTZ_CALENDARS");
122
		ddl_list.add("QRTZ_PAUSED_TRIGGER_GRPS");
123
		ddl_list.add("QRTZ_FIRED_TRIGGERS");
124
		ddl_list.add("QRTZ_SCHEDULER_STATE");
125
		ddl_list.add("QRTZ_LOCKS");
126
 
127
		String ddl = this.getClass().getClassLoader().getResource("/").toString()
128
		.substring(6)+ "../data/";
129
 
130
		DatabaseMetaData dmd = conn.getMetaData();
131
		for (String tbl : ddl_list) {
132
			ResultSet rs = dmd.getTables(null, "APP", tbl, null);
133
			if (!rs.next()) {
199 brianR 134
				log.debug("Adding DDL for table {}", tbl);
72 brianR 135
				Statement st = conn.createStatement();
136
				File ddlFile = new File(ddl + tbl + ".ddl");
137
				String create = "";
138
				try {
139
						BufferedReader r = new BufferedReader(new FileReader(ddlFile));
140
						while (r.ready()) {
141
							create += r.readLine() + "\n";
142
						}
143
						create.trim();
144
						if( st.execute(create)) {
199 brianR 145
							log.debug("Table {} created.", tbl);
72 brianR 146
						}
147
					} catch (IOException ex) {
148
						ex.printStackTrace();
149
					} catch (SQLException ex) {
199 brianR 150
						log.error("Error executing statement {}.",create, ex );
72 brianR 151
					}
152
				} else {
199 brianR 153
					log.trace("Table {} exists.", tbl);
72 brianR 154
				}
155
			}
156
		}
157
 
158
	private synchronized boolean isConnected(boolean fail) throws SQLException {
113 brianR 159
		if(conn!=null ) { // Todo: && conn.conn.isValid(5)) {) {
72 brianR 160
			return true;
161
		} else {
162
			String t = this.getClass().getClassLoader().getResource("/").toString().substring(6); // WEB-INF/classes
163
			t += "../data/db";
199 brianR 164
			log.debug("Database directory is set to '{}", t);
72 brianR 165
			try {
166
				this.conn = DriverManager.getConnection("jdbc:derby:" + t + ";create=true;");
167
			} catch (SQLException ex) {
199 brianR 168
				log.error(ex.getMessage(), ex);
72 brianR 169
				if(!fail) {
199 brianR 170
					log.warn("Deleting database directory.");
72 brianR 171
					recursiveDelete(new File(t));
199 brianR 172
					log.warn("Retrying to connect to database.");
72 brianR 173
					return isConnected(true);
174
				} else {
175
					return false;
176
				}
177
			}
178
		}
179
		return false;
180
	}
139 brianR 181
 
197 brianR 182
 
72 brianR 183
}
184