1. /*
  2. * $Header: /home/cvs/jakarta-commons/dbutils/src/java/org/apache/commons/dbutils/QueryLoader.java,v 1.1 2003/11/02 19:15:23 dgraham Exp $
  3. * $Revision: 1.1 $
  4. * $Date: 2003/11/02 19:15:23 $
  5. *
  6. * ====================================================================
  7. *
  8. * The Apache Software License, Version 1.1
  9. *
  10. * Copyright (c) 2003 The Apache Software Foundation. All rights
  11. * reserved.
  12. *
  13. * Redistribution and use in source and binary forms, with or without
  14. * modification, are permitted provided that the following conditions
  15. * are met:
  16. *
  17. * 1. Redistributions of source code must retain the above copyright
  18. * notice, this list of conditions and the following disclaimer.
  19. *
  20. * 2. Redistributions in binary form must reproduce the above copyright
  21. * notice, this list of conditions and the following disclaimer in
  22. * the documentation and/or other materials provided with the
  23. * distribution.
  24. *
  25. * 3. The end-user documentation included with the redistribution, if
  26. * any, must include the following acknowledgement:
  27. * "This product includes software developed by the
  28. * Apache Software Foundation (http://www.apache.org/)."
  29. * Alternately, this acknowledgement may appear in the software itself,
  30. * if and wherever such third-party acknowledgements normally appear.
  31. *
  32. * 4. The names "The Jakarta Project", "Commons", and "Apache Software
  33. * Foundation" must not be used to endorse or promote products derived
  34. * from this software without prior written permission. For written
  35. * permission, please contact apache@apache.org.
  36. *
  37. * 5. Products derived from this software may not be called "Apache"
  38. * nor may "Apache" appear in their names without prior written
  39. * permission of the Apache Software Foundation.
  40. *
  41. * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
  42. * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
  43. * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  44. * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
  45. * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  46. * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  47. * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
  48. * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  49. * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
  50. * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
  51. * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
  52. * SUCH DAMAGE.
  53. * ====================================================================
  54. *
  55. * This software consists of voluntary contributions made by many
  56. * individuals on behalf of the Apache Software Foundation. For more
  57. * information on the Apache Software Foundation, please see
  58. * <http://www.apache.org/>.
  59. *
  60. */
  61. package org.apache.commons.dbutils;
  62. import java.io.IOException;
  63. import java.io.InputStream;
  64. import java.util.HashMap;
  65. import java.util.Map;
  66. import java.util.Properties;
  67. /**
  68. * <code>QueryLoader</code> loads properties files filled with query name to
  69. * SQL mappings. It acts as a registry for sets of queries so that multiple
  70. * copies of the same queries aren't loaded into memory. This class is thread
  71. * safe.
  72. *
  73. * @author David Graham
  74. */
  75. public class QueryLoader {
  76. /**
  77. * The Singleton instance of this class.
  78. */
  79. private static final QueryLoader instance = new QueryLoader();
  80. /**
  81. * Return an instance of this class.
  82. * @return The Singleton instance.
  83. */
  84. public static QueryLoader instance() {
  85. return instance;
  86. }
  87. /**
  88. * Maps query set names to Maps of their queries.
  89. */
  90. private Map queries = new HashMap();
  91. /**
  92. * QueryLoader constructor.
  93. */
  94. protected QueryLoader() {
  95. super();
  96. }
  97. /**
  98. * Loads a Map of query names to SQL values. The Maps are cached so a
  99. * subsequent request to load queries from the same path will return
  100. * the cached Map.
  101. *
  102. * @param path The path that the ClassLoader will use to find the file.
  103. * This is <strong>not</strong> a file system path. If you had a jarred
  104. * Queries.properties file in the com.yourcorp.app.jdbc package you would
  105. * pass "/com/yourcorp/app/jdbc/Queries.properties" to this method.
  106. * @throws IOException
  107. * @throws IllegalArgumentException if the ClassLoader can't find a file at
  108. * the given path.
  109. */
  110. public synchronized Map load(String path) throws IOException {
  111. Map queryMap = (Map) this.queries.get(path);
  112. if (queryMap == null) {
  113. queryMap = this.loadQueries(path);
  114. this.queries.put(path, queryMap);
  115. }
  116. return queryMap;
  117. }
  118. /**
  119. * Loads a properties file into a Map object.
  120. * @param path The path that the ClassLoader will use to find the file.
  121. * @throws IOException
  122. */
  123. private Map loadQueries(String path) throws IOException {
  124. InputStream in = QueryLoader.class.getResourceAsStream(path);
  125. if (in == null) {
  126. throw new IllegalArgumentException(path + " not found.");
  127. }
  128. Properties props = new Properties();
  129. props.load(in);
  130. // Copy to HashMap for better performance
  131. return new HashMap(props);
  132. }
  133. /**
  134. * Removes the queries for the given path from the cache.
  135. * @param path The path that the queries were loaded from.
  136. */
  137. public synchronized void unload(String path){
  138. this.queries.remove(path);
  139. }
  140. }