001: /* ====================================================================
002: * The Jcorporate Apache Style Software License, Version 1.2 05-07-2002
003: *
004: * Copyright (c) 1995-2002 Jcorporate Ltd. All rights reserved.
005: *
006: * Redistribution and use in source and binary forms, with or without
007: * modification, are permitted provided that the following conditions
008: * are met:
009: *
010: * 1. Redistributions of source code must retain the above copyright
011: * notice, this list of conditions and the following disclaimer.
012: *
013: * 2. Redistributions in binary form must reproduce the above copyright
014: * notice, this list of conditions and the following disclaimer in
015: * the documentation and/or other materials provided with the
016: * distribution.
017: *
018: * 3. The end-user documentation included with the redistribution,
019: * if any, must include the following acknowledgment:
020: * "This product includes software developed by Jcorporate Ltd.
021: * (http://www.jcorporate.com/)."
022: * Alternately, this acknowledgment may appear in the software itself,
023: * if and wherever such third-party acknowledgments normally appear.
024: *
025: * 4. "Jcorporate" and product names such as "Expresso" must
026: * not be used to endorse or promote products derived from this
027: * software without prior written permission. For written permission,
028: * please contact info@jcorporate.com.
029: *
030: * 5. Products derived from this software may not be called "Expresso",
031: * or other Jcorporate product names; nor may "Expresso" or other
032: * Jcorporate product names appear in their name, without prior
033: * written permission of Jcorporate Ltd.
034: *
035: * 6. No product derived from this software may compete in the same
036: * market space, i.e. framework, without prior written permission
037: * of Jcorporate Ltd. For written permission, please contact
038: * partners@jcorporate.com.
039: *
040: * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
041: * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
042: * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
043: * DISCLAIMED. IN NO EVENT SHALL JCORPORATE LTD OR ITS CONTRIBUTORS
044: * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
045: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
046: * TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
047: * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
048: * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
049: * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
050: * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
051: * SUCH DAMAGE.
052: * ====================================================================
053: *
054: * This software consists of voluntary contributions made by many
055: * individuals on behalf of the Jcorporate Ltd. Contributions back
056: * to the project(s) are encouraged when you make modifications.
057: * Please send them to support@jcorporate.com. For more information
058: * on Jcorporate Ltd. and its products, please see
059: * <http://www.jcorporate.com/>.
060: *
061: * Portions of this software are based upon other open source
062: * products and are subject to their respective licenses.
063: */
064:
065: package com.jcorporate.expresso.core.db.tests;
066:
067: import com.jcorporate.expresso.core.db.DBConnection;
068: import com.jcorporate.expresso.core.db.DBConnectionPool;
069: import com.jcorporate.expresso.core.db.DBException;
070: import com.jcorporate.expresso.core.db.exception.PoolFullException;
071: import com.jcorporate.expresso.core.misc.DateTime;
072: import com.jcorporate.expresso.services.test.ExpressoTestCase;
073: import com.jcorporate.expresso.services.test.TestSystemInitializer;
074: import junit.framework.TestSuite;
075:
076: /**
077: * Unit test for the DBConnectionPool
078: *
079: * @author Michael Rimov
080: * @version $Revision: 1.2 $ on $Date: 2004/11/17 20:48:22 $
081: */
082:
083: public class DBConnectionPoolTest extends ExpressoTestCase {
084: static final int NUM_STRESS_THREADS = 60;
085: static final int NUM_ITERATIONS = 20;
086:
087: /**
088: * Default testing constructor
089: *
090: * @param testName the Test Name
091: */
092: public DBConnectionPoolTest(String testName) throws Exception {
093: super (testName);
094: }
095:
096: public static void main(String[] args) throws Exception {
097: junit.textui.TestRunner.run(suite());
098: }
099:
100: public static junit.framework.Test suite() throws Exception {
101: return new TestSuite(DBConnectionPoolTest.class);
102: }
103:
104: public void tearDown() {
105: try {
106: DBConnectionPool.getInstance(
107: TestSystemInitializer.getTestContext())
108: .disconnectAll();
109: } catch (DBException ex) {
110: }
111: }
112:
113: /**
114: * Tests to make sure basic connection pool capabilities are there.
115: */
116: public void testConnectionPool() {
117: try {
118: System.out.println("\nBegin connection pool tests:"
119: + DateTime.getDateTimeString());
120:
121: DBConnectionPool myPool = DBConnectionPool
122: .getInstance(TestSystemInitializer.getTestContext());
123: int maxConnections = myPool.getMaxConnections();
124: DBConnection connections[] = new DBConnection[maxConnections];
125: System.out.println("Maximum connections in the pool is: "
126: + maxConnections);
127:
128: for (int i = 0; i <= 5000; i++) {
129: for (int j = 0; j < maxConnections; j++) {
130: connections[j] = myPool.getConnection("Test " + j);
131: }
132:
133: for (int j = 0; j < maxConnections; j++) {
134: myPool.release(connections[j]);
135: }
136: }
137:
138: System.out.println("End connection pool tests:"
139: + DateTime.getDateTimeString());
140: } catch (DBException ex) {
141: ex.printStackTrace();
142: fail("Caught an exception attempting DBConnectionPool Test "
143: + ex.getMessage());
144: }
145:
146: }
147:
148: /**
149: * This test attempts to check to make sure the new DBConnection.release()
150: * method is working.
151: */
152: public void testNewRelease() {
153: try {
154: System.out.println("\nBegin new connection pool tests:"
155: + DateTime.getDateTimeString());
156:
157: DBConnectionPool myPool = DBConnectionPool
158: .getInstance(TestSystemInitializer.getTestContext());
159: int maxConnections = myPool.getMaxConnections();
160: DBConnection connections[] = new DBConnection[maxConnections];
161: System.out.println("Maximum connections in the pool is: "
162: + maxConnections);
163:
164: for (int i = 0; i <= 100; i++) {
165: for (int j = 0; j < maxConnections; j++) {
166: connections[j] = myPool.getConnection("Test " + j);
167: connections[j]
168: .execute("SELECT COUNT(*) FROM CONTROLLERSECURITY");
169: }
170:
171: for (int j = 0; j < maxConnections; j++) {
172: myPool.release(connections[j]);
173: }
174: }
175:
176: System.out.println("End new connection pool tests:"
177: + DateTime.getDateTimeString());
178: } catch (DBException ex) {
179: ex.printStackTrace();
180: fail("Caught an exception attempting DBConnectionPool Test "
181: + ex.getMessage());
182: }
183:
184: }
185:
186: /**
187: * In this test, we try to create the maximum number of connections and then
188: * attempt to allocate one more. It should throw an exception or return
189: * a connection.
190: */
191: public void testFullPool() {
192: try {
193: DBConnectionPool myPool = DBConnectionPool
194: .getInstance(TestSystemInitializer.getTestContext());
195: int maxConnections = myPool.getMaxConnections();
196: DBConnection connections[] = new DBConnection[maxConnections];
197: System.out.println("Maximum connections in the pool is: "
198: + maxConnections);
199:
200: for (int j = 0; j < maxConnections; j++) {
201: connections[j] = myPool.getConnection("Test " + j);
202: }
203:
204: try {
205: DBConnection breakConnection = myPool
206: .getConnection("Breaking Connection");
207: fail("The last connection SHOULD have thrown an exception");
208: } catch (DBException dbe) {
209: assertTrue("Must receive a PoolFullException",
210: dbe instanceof PoolFullException);
211: }
212:
213: for (int j = 0; j < maxConnections; j++) {
214: myPool.release(connections[j]);
215: }
216: } catch (DBException ex) {
217: ex.printStackTrace();
218: fail("Caught an exception attempting DBConnectionPool Test "
219: + ex.getMessage());
220: }
221: }
222:
223: /**
224: * Generates lots of threads that bang away on the connection pool attempting to
225: * get it to die.
226: */
227: public void testConnectionPoolStressTest() {
228: DBConnectionPoolStressThread theThreads[] = new DBConnectionPoolStressThread[NUM_STRESS_THREADS];
229:
230: for (int i = 0; i < NUM_STRESS_THREADS; i++) {
231: theThreads[i] = new DBConnectionPoolStressThread(
232: "DBConnectionPool Thread " + i);
233: }
234:
235: for (int i = 0; i < NUM_STRESS_THREADS; i++) {
236: theThreads[i].start();
237: }
238:
239: for (int i = 0; i < NUM_STRESS_THREADS; i++) {
240: try {
241: theThreads[i].join();
242: } catch (InterruptedException ex) {
243: }
244: }
245:
246: boolean failures = false;
247: for (int i = 0; i < NUM_STRESS_THREADS; i++) {
248: System.out.println("Status for thread: "
249: + theThreads[i].getName()
250: + " number of pool fulls: "
251: + theThreads[i].getNumPoolFulls() + " errors: "
252: + theThreads[i].getErrors());
253:
254: if (theThreads[i].getErrors() != null) {
255: failures = true;
256: }
257: }
258:
259: assertTrue("There were failures.", failures == false);
260:
261: }
262: }
|