01: /**
02: * Library name : Primrose - A Java Database Connection Pool.
03: * Published by Ben Keeping, http://primrose.org.uk .
04: * Copyright (C) 2004 Ben Keeping, primrose.org.uk
05: * Email: Use "Contact Us Form" on website
06: *
07: * This library is free software; you can redistribute it and/or
08: * modify it under the terms of the GNU Lesser General Public
09: * License as published by the Free Software Foundation; either
10: * version 2.1 of the License, or (at your option) any later version.
11: *
12: * This library is distributed in the hope that it will be useful,
13: * but WITHOUT ANY WARRANTY; without even the implied warranty of
14: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15: * Lesser General Public License for more details.
16: *
17: * You should have received a copy of the GNU Lesser General Public
18: * License along with this library; if not, write to the Free Software
19: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
20: */package uk.org.primrose.pool.core.loadrules;
21:
22: import uk.org.primrose.Logger;
23: import uk.org.primrose.pool.core.Pool;
24:
25: /**
26: *
27: * @author sedj
28: * If the 'failoverPool' parameter is set, the 'checkSQL' parameter
29: * must also be set. This is because to determine if a DB is down, and the failoverPool
30: * should be used, a piece of SQL needs to be defined (such as 'select 1 from dual')
31: * which will not throw a user exception (basically some SQL guaranteed to work if the DB is up).
32: */
33: public class FailoverPool implements LoadRule {
34:
35: public void runCheck(Pool pool, Logger logger)
36: throws LoadRuleException {
37: logger.info("[Pool@" + pool.getPoolName()
38: + "] Checking 'failoverPool' rule ...");
39: if (pool.getOnExceptionCheckSQL() == null
40: || pool.getOnExceptionCheckSQL().length() == 0) {
41: throw new LoadRuleException(
42: "Pool config parameter 'onExceptionCheckSQL' must be specified if you wish to use the 'failoverPool' parameter.");
43: }
44: if (pool.getDumpConnectionOnSQLException() == null
45: || !pool.getDumpConnectionOnSQLException()
46: .equalsIgnoreCase("true")) {
47: throw new LoadRuleException(
48: "Pool config parameter 'dumpConnectionOnSQLException' must be set to 'true' if you wish to use the 'failoverPool' parameter. (dumpConnectionOnSQLException="
49: + pool.getDumpConnectionOnSQLException()
50: + ")");
51: }
52:
53: if (pool.getWaitForConnectionIfDatabaseIsDown()
54: .equalsIgnoreCase("true")) {
55: throw new LoadRuleException(
56: "Pool config parameter 'waitForConnectionIfDatabaseIsDown' must be set to 'false' if you wish to use the 'failoverPool' parameter. (waitForConnectionIfDatabaseIsDown="
57: + pool
58: .getWaitForConnectionIfDatabaseIsDown()
59: + ")");
60: }
61: }
62:
63: }
|