Subversion Repositories XServices

Rev

Rev 197 | Go to most recent revision | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

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