Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep

Source code: com/clra/rowing/Configuration.java


1   /*
2    * Copyright (c) Carnegie Lake Rowing Association 2002. All rights reserved.
3    * Distributed under the GPL license. See doc/COPYING.
4    * $RCSfile: Configuration.java,v $
5    * $Date: 2003/02/26 03:38:45 $
6    * $Revision: 1.4 $
7    */
8   
9   package com.clra.rowing;
10  
11  import com.clra.util.ConfigurationException;
12  import com.clra.util.DBConfiguration;
13  import java.io.InputStream;
14  import java.net.URL;
15  import java.util.Properties;
16  import org.apache.log4j.Category;
17  import org.apache.log4j.helpers.Loader;
18  
19  /**
20   * A collection of configurable properties used by this package.
21   * @version $Id: Configuration.java,v 1.4 2003/02/26 03:38:45 rphall Exp $
22   * @author <a href="mailto:rphall@pluto.njcc.com">Rick Hall</a>
23   */
24  public class Configuration {
25  
26    /** All methods are static */
27    private Configuration() {}
28  
29    private final static String base = Configuration.class.getName();
30    private final static Category theLog = Category.getInstance( base );
31  
32    /** Property that holds the JNDI location of the RowingSession factory */
33    public final static String PN_ROWINGSESSION_HOME =
34            "rowingsession.home";
35  
36    /** Property that holds the JNDI location of the Participant factory */
37    public final static String PN_PARTICIPANT_HOME =
38            "participant.home";
39  
40    /** Session SQL property-name prefix */
41    public final static String PN_PREFIX_SQL_SESSION = "sessionset.sql.";
42  
43    /** Participant SQL property-name prefix */
44    public final static String PN_PREFIX_SQL_PARTICIPANT = "participant.sql.";
45  
46    /** Enrollment SQL property-name prefix */
47    public final static String PN_PREFIX_SQL_ENROLLMENT = "enrollment.sql.";
48  
49    /** SQL date format spec */
50    public final static String PN_SQL_DATE_FORMAT =
51            PN_PREFIX_SQL_SESSION + "dateformat." + DBConfiguration.DBTYPE;
52  
53    /** All session id's */
54    public final static String PN_SQL_SESSION_01 =
55            PN_PREFIX_SQL_SESSION + "01." + DBConfiguration.DBTYPE;
56  
57    /** All sessions */
58    public final static String PN_SQL_SESSION_01A =
59            PN_PREFIX_SQL_SESSION + "01a." + DBConfiguration.DBTYPE;
60  
61    /** Specific Session by id */
62    public final static String PN_SQL_SESSION_02 =
63            PN_PREFIX_SQL_SESSION + "02." + DBConfiguration.DBTYPE;
64  
65    /** Sessions within a date range */
66    public final static String PN_SQL_SESSION_03 =
67            PN_PREFIX_SQL_SESSION + "03." + DBConfiguration.DBTYPE;
68  
69    /** Inserts a session */
70    public final static String PN_SQL_SESSION_04 =
71            PN_PREFIX_SQL_SESSION + "04." + DBConfiguration.DBTYPE;
72  
73    /** Deletes a session */
74    public final static String PN_SQL_SESSION_05 =
75            PN_PREFIX_SQL_SESSION + "05." + DBConfiguration.DBTYPE;
76  
77    /** Loads a session */
78    public final static String PN_SQL_SESSION_06 =
79            PN_PREFIX_SQL_SESSION + "06." + DBConfiguration.DBTYPE;
80  
81    /** Stores a session */
82    public final static String PN_SQL_SESSION_07 =
83            PN_PREFIX_SQL_SESSION + "07." + DBConfiguration.DBTYPE;
84  
85    /** Updates the next id for a rowing session */
86    public final static String PN_SQL_SESSION_08 =
87            PN_PREFIX_SQL_SESSION + "08." + DBConfiguration.DBTYPE;
88  
89    /** Selects the next id for a rowing session */
90    public final static String PN_SQL_SESSION_08A =
91            PN_PREFIX_SQL_SESSION + "08a." + DBConfiguration.DBTYPE;
92  
93    /** Participant identified by participant_id */
94    public final static String PN_SQL_PARTICIPANT_01 =
95            PN_PREFIX_SQL_PARTICIPANT + "01." + DBConfiguration.DBTYPE;
96  
97    /** Participants (and member names) associated with a rowing session */
98    public final static String PN_SQL_PARTICIPANT_02 =
99            PN_PREFIX_SQL_PARTICIPANT + "02." + DBConfiguration.DBTYPE;
100 
101   /** Participant identified by memberId and rowingId */
102   public final static String PN_SQL_PARTICIPANT_03 =
103           PN_PREFIX_SQL_PARTICIPANT + "03." + DBConfiguration.DBTYPE;
104 
105   /** Id's of all participants */
106   public final static String PN_SQL_PARTICIPANT_04 =
107           PN_PREFIX_SQL_PARTICIPANT + "04." + DBConfiguration.DBTYPE;
108 
109   /** Inserts a participant constrained by rowing state */
110   public final static String PN_SQL_PARTICIPANT_05 =
111           PN_PREFIX_SQL_PARTICIPANT + "05." + DBConfiguration.DBTYPE;
112 
113   /** Deletes a participant */
114   public final static String PN_SQL_PARTICIPANT_06 =
115           PN_PREFIX_SQL_PARTICIPANT + "06." + DBConfiguration.DBTYPE;
116 
117   /** Stores a participant */
118   public final static String PN_SQL_PARTICIPANT_07 =
119           PN_PREFIX_SQL_PARTICIPANT + "07." + DBConfiguration.DBTYPE;
120 
121   /** Updates the next id for a participant */
122   public final static String PN_SQL_PARTICIPANT_08 =
123           PN_PREFIX_SQL_PARTICIPANT + "08." + DBConfiguration.DBTYPE;
124 
125   /** Selects the next id for a participant */
126   public final static String PN_SQL_PARTICIPANT_08A =
127           PN_PREFIX_SQL_PARTICIPANT + "08a." + DBConfiguration.DBTYPE;
128 
129   /** Inserts non-null participation data into temporary enrollment table */
130   public final static String PN_SQL_ENROLLMENT_01 =
131           PN_PREFIX_SQL_ENROLLMENT + "01." + DBConfiguration.DBTYPE;
132 
133   /** Inserts null participation data into temporary enrollment table */
134   public final static String PN_SQL_ENROLLMENT_02 =
135           PN_PREFIX_SQL_ENROLLMENT + "02." + DBConfiguration.DBTYPE;
136 
137   /** Name of file that holds default values for this package */
138   private final static String DEFAULTS_FILE =
139           "com/clra/rowing/rowing.properties";
140 
141   /** Default properties for this package */
142   private final static Properties defaultProperties = new Properties();
143   static {
144     InputStream is = null;
145     try {
146       URL url = Loader.getResource( DEFAULTS_FILE, Configuration.class );
147       is = url.openStream();
148       defaultProperties.load( is );
149       if ( theLog.isDebugEnabled() ) {
150         theLog.debug( "loaded properties from '" + DEFAULTS_FILE + "'" );
151         java.util.Enumeration _e = defaultProperties.propertyNames();
152         while ( _e.hasMoreElements() ) {
153           theLog.debug( "property: " + _e.nextElement() );
154         }
155       }
156     }
157     catch( Exception x ){
158       String msg = "unable to load default properties from '"
159               + DEFAULTS_FILE + "'";
160       theLog.fatal(msg,x);
161       throw new IllegalStateException( msg );
162     }
163     finally {
164       if ( is != null ) {
165         try { is.close(); } catch( Exception x ) {}
166         is = null;
167       }
168     } // finally
169   } // static
170 
171   /** Utility that looks up a default property by name */
172   private static String getDefaultProperty( String PN ) {
173     // Precondition
174     if ( PN == null || PN.trim().length()== 0 ) {
175       throw new IllegalArgumentException( "invalid property name" );
176     }
177 
178     String retVal = defaultProperties.getProperty( PN );
179     if ( retVal == null || retVal.trim().length() == 0 ) {
180       String msg = "invalid or missing value for '" + PN + "'";
181       theLog.error(msg);
182       retVal = null;
183     }
184     else {
185       retVal = retVal.trim();
186     }
187 
188     return retVal;
189   } // getDefaultProperty(String)
190 
191   /** Utility that looks up a System property or assigns a default value */
192   private static String getProperty( String PN, String DEFAULT ) {
193     // Preconditions
194     //theLog.debug( "PN == '" + PN + "'" );
195     //theLog.debug( "DEFAULT == '" + DEFAULT + "'" );
196     if ( PN == null || PN.trim().length() == 0 ) {
197       throw new IllegalArgumentException( "invalid property name" );
198     }
199     if ( DEFAULT != null && DEFAULT.trim().length() == 0 ) {
200       DEFAULT = null;
201     }
202       
203     String retVal = System.getProperty( PN );
204     if ( retVal == null || retVal.trim().length() == 0 ) {
205       retVal = DEFAULT;
206     }
207     if ( retVal == null || retVal.trim().length() == 0 ) {
208       String msg = "no property for '" + PN + "'";
209       theLog.fatal( msg );
210       throw new IllegalStateException( msg );
211     }
212     retVal = retVal.trim();
213 
214     return retVal;
215   } // getProperty(String,String)
216 
217 
218   private static String _DEFAULT_ROWINGSESSION_HOME = null;
219   private static String _ROWINGSESSION_HOME = null;
220   static {
221     _DEFAULT_ROWINGSESSION_HOME = getDefaultProperty( PN_ROWINGSESSION_HOME );
222     theLog.info(
223         "DEFAULT_ROWINGSESSION_HOME == '" + _DEFAULT_ROWINGSESSION_HOME + "'");
224     _ROWINGSESSION_HOME = getProperty(
225         PN_ROWINGSESSION_HOME, _DEFAULT_ROWINGSESSION_HOME );
226     theLog.info( "ROWINGSESSION_HOME == '" + _ROWINGSESSION_HOME + "'" );
227   } // static
228 
229   public static String ROWINGSESSION_HOME() { return _ROWINGSESSION_HOME; }
230 
231   private static String _DEFAULT_PARTICIPANT_HOME = null;
232   private static String _PARTICIPANT_HOME = null;
233   static {
234     _DEFAULT_PARTICIPANT_HOME =
235         getDefaultProperty( PN_PARTICIPANT_HOME );
236     theLog.info( "DEFAULT_PARTICIPANT_HOME == '"
237         + _DEFAULT_PARTICIPANT_HOME + "'");
238     _PARTICIPANT_HOME = getProperty(
239         PN_PARTICIPANT_HOME, _DEFAULT_PARTICIPANT_HOME );
240     theLog.info("PARTICIPANT_HOME == '" + _PARTICIPANT_HOME + "'");
241   } // static
242 
243   public static String PARTICIPANT_HOME() {
244     return _PARTICIPANT_HOME;
245   }
246 
247   /** SQL that selects up all sessions */
248   private static String DEFAULT_SQL_DATE_FORMAT = null;
249   public static String SQL_DATE_FORMAT = null;
250   static {
251     DEFAULT_SQL_DATE_FORMAT = getDefaultProperty( PN_SQL_DATE_FORMAT );
252     theLog.info("DEFAULT_SQL_DATE_FORMAT == '" + DEFAULT_SQL_DATE_FORMAT + "'");
253     SQL_DATE_FORMAT = getProperty(PN_SQL_DATE_FORMAT, DEFAULT_SQL_DATE_FORMAT);
254     theLog.info( "SQL_DATE_FORMAT == '" + SQL_DATE_FORMAT + "'" );
255   } // static
256 
257   /** SQL that selects all session id's */
258   private static String DEFAULT_SQL_SESSION_01 = null;
259   public static String SQL_SESSION_01 = null;
260   static {
261     DEFAULT_SQL_SESSION_01 = getDefaultProperty( PN_SQL_SESSION_01 );
262     theLog.info( "DEFAULT_SQL_SESSION_01 == '" + DEFAULT_SQL_SESSION_01 + "'" );
263     SQL_SESSION_01 = getProperty( PN_SQL_SESSION_01, DEFAULT_SQL_SESSION_01 );
264     theLog.info( "SQL_SESSION_01 == '" + SQL_SESSION_01 + "'" );
265   } // static
266 
267   /** SQL that selects all sessions */
268   private static String DEFAULT_SQL_SESSION_01A = null;
269   public static String SQL_SESSION_01A = null;
270   static {
271     DEFAULT_SQL_SESSION_01A = getDefaultProperty( PN_SQL_SESSION_01A );
272     theLog.info("DEFAULT_SQL_SESSION_01A == '" + DEFAULT_SQL_SESSION_01A + "'");
273     SQL_SESSION_01A = getProperty( PN_SQL_SESSION_01A,DEFAULT_SQL_SESSION_01A );
274     theLog.info( "SQL_SESSION_01A == '" + SQL_SESSION_01A + "'" );
275   } // static
276 
277   /** SQL that selects a session by id */
278   private static String DEFAULT_SQL_SESSION_02 = null;
279   public static String SQL_SESSION_02 = null;
280   static {
281     DEFAULT_SQL_SESSION_02 = getDefaultProperty( PN_SQL_SESSION_02 );
282     theLog.info( "DEFAULT_SQL_SESSION_02 == '" + DEFAULT_SQL_SESSION_02 + "'" );
283     SQL_SESSION_02 = getProperty( PN_SQL_SESSION_02, DEFAULT_SQL_SESSION_02 );
284     theLog.info( "SQL_SESSION_02 == '" + SQL_SESSION_02 + "'" );
285   } // static
286 
287   /** SQL that selects sessions within an inclusive date range */
288   private static String DEFAULT_SQL_SESSION_03 = null;
289   public static String SQL_SESSION_03 = null;
290   static {
291     DEFAULT_SQL_SESSION_03 = getDefaultProperty( PN_SQL_SESSION_03 );
292     theLog.info( "DEFAULT_SQL_SESSION_03 == '" + DEFAULT_SQL_SESSION_03 + "'" );
293     SQL_SESSION_03 = getProperty( PN_SQL_SESSION_03, DEFAULT_SQL_SESSION_03 );
294     theLog.info( "SQL_SESSION_03 == '" + SQL_SESSION_03 + "'" );
295   } // static
296 
297   /** SQL that inserts a rowing session */
298   private static String DEFAULT_SQL_SESSION_04 = null;
299   public static String SQL_SESSION_04 = null;
300   static {
301     DEFAULT_SQL_SESSION_04 = getDefaultProperty( PN_SQL_SESSION_04 );
302     theLog.info( "DEFAULT_SQL_SESSION_04 == '" + DEFAULT_SQL_SESSION_04 + "'" );
303     SQL_SESSION_04 = getProperty( PN_SQL_SESSION_04, DEFAULT_SQL_SESSION_04 );
304     theLog.info( "SQL_SESSION_04 == '" + SQL_SESSION_04 + "'" );
305   } // static
306 
307   /** SQL that deletes a session */
308   private static String DEFAULT_SQL_SESSION_05 = null;
309   public static String SQL_SESSION_05 = null;
310   static {
311     DEFAULT_SQL_SESSION_05 = getDefaultProperty( PN_SQL_SESSION_05 );
312     theLog.info( "DEFAULT_SQL_SESSION_05 == '" + DEFAULT_SQL_SESSION_05 + "'" );
313     SQL_SESSION_05 = getProperty( PN_SQL_SESSION_05, DEFAULT_SQL_SESSION_05 );
314     theLog.info( "SQL_SESSION_05 == '" + SQL_SESSION_05 + "'" );
315   } // static
316 
317   /** SQL that loads a session */
318   private static String DEFAULT_SQL_SESSION_06 = null;
319   public static String SQL_SESSION_06 = null;
320   static {
321     DEFAULT_SQL_SESSION_06 = getDefaultProperty( PN_SQL_SESSION_06 );
322     theLog.info( "DEFAULT_SQL_SESSION_06 == '" + DEFAULT_SQL_SESSION_06 + "'" );
323     SQL_SESSION_06 = getProperty( PN_SQL_SESSION_06, DEFAULT_SQL_SESSION_06 );
324     theLog.info( "SQL_SESSION_06 == '" + SQL_SESSION_06 + "'" );
325   } // static
326 
327   /** SQL that stores a session */
328   private static String DEFAULT_SQL_SESSION_07 = null;
329   public static String SQL_SESSION_07 = null;
330   static {
331     DEFAULT_SQL_SESSION_07 = getDefaultProperty( PN_SQL_SESSION_07 );
332     theLog.info( "DEFAULT_SQL_SESSION_07 == '" + DEFAULT_SQL_SESSION_07 + "'" );
333     SQL_SESSION_07 = getProperty( PN_SQL_SESSION_07, DEFAULT_SQL_SESSION_07 );
334     theLog.info( "SQL_SESSION_07 == '" + SQL_SESSION_07 + "'" );
335   } // static
336 
337   /** Updates the next id for a rowing session */
338   private static String DEFAULT_SQL_SESSION_08 = null;
339   public static String SQL_SESSION_08 = null;
340   static {
341     DEFAULT_SQL_SESSION_08 = getDefaultProperty( PN_SQL_SESSION_08 );
342     theLog.info( "DEFAULT_SQL_SESSION_08 == '" + DEFAULT_SQL_SESSION_08 + "'" );
343     SQL_SESSION_08 = getProperty( PN_SQL_SESSION_08, DEFAULT_SQL_SESSION_08 );
344     theLog.info( "SQL_SESSION_08 == '" + SQL_SESSION_08 + "'" );
345   } // static
346 
347   /** Selects the next id for a rowing session */
348   private static String DEFAULT_SQL_SESSION_08A = null;
349   public static String SQL_SESSION_08A = null;
350   static {
351     DEFAULT_SQL_SESSION_08A = getDefaultProperty( PN_SQL_SESSION_08A );
352     theLog.info("DEFAULT_SQL_SESSION_08A == '" + DEFAULT_SQL_SESSION_08A + "'");
353     SQL_SESSION_08A = getProperty( PN_SQL_SESSION_08A, DEFAULT_SQL_SESSION_08A);
354     theLog.info( "SQL_SESSION_08A == '" + SQL_SESSION_08A + "'" );
355   } // static
356 
357   /** Loads a participant identified by participant_id */
358   private static String DEFAULT_SQL_PARTICIPANT_01 = null;
359   public static String SQL_PARTICIPANT_01 = null;
360   static {
361     DEFAULT_SQL_PARTICIPANT_01 = getDefaultProperty( PN_SQL_PARTICIPANT_01 );
362     theLog.info(
363       "DEFAULT_SQL_PARTICIPANT_01 == '" + DEFAULT_SQL_PARTICIPANT_01 + "'" );
364     SQL_PARTICIPANT_01 =
365       getProperty( PN_SQL_PARTICIPANT_01, DEFAULT_SQL_PARTICIPANT_01 );
366     theLog.info( "SQL_PARTICIPANT_01 == '" + SQL_PARTICIPANT_01 + "'" );
367   } // static
368 
369   /** Loads a participants (and their member names) in a rowing session */
370   private static String DEFAULT_SQL_PARTICIPANT_02 = null;
371   public static String SQL_PARTICIPANT_02 = null;
372   static {
373     DEFAULT_SQL_PARTICIPANT_02 = getDefaultProperty( PN_SQL_PARTICIPANT_02 );
374     theLog.info(
375       "DEFAULT_SQL_PARTICIPANT_02 == '" + DEFAULT_SQL_PARTICIPANT_02 + "'" );
376     SQL_PARTICIPANT_02 =
377       getProperty( PN_SQL_PARTICIPANT_02, DEFAULT_SQL_PARTICIPANT_02 );
378     theLog.info( "SQL_PARTICIPANT_02 == '" + SQL_PARTICIPANT_02 + "'" );
379   } // static
380 
381   /** Loads a participant (possibly null) identified by member and rowing id */
382   private static String DEFAULT_SQL_PARTICIPANT_03 = null;
383   public static String SQL_PARTICIPANT_03 = null;
384   static {
385     DEFAULT_SQL_PARTICIPANT_03 = getDefaultProperty( PN_SQL_PARTICIPANT_03 );
386     theLog.info(
387       "DEFAULT_SQL_PARTICIPANT_03 == '" + DEFAULT_SQL_PARTICIPANT_03 + "'" );
388     SQL_PARTICIPANT_03 =
389       getProperty( PN_SQL_PARTICIPANT_03, DEFAULT_SQL_PARTICIPANT_03 );
390     theLog.info( "SQL_PARTICIPANT_03 == '" + SQL_PARTICIPANT_03 + "'" );
391   } // static
392 
393   /** Selects id's of all participants */
394   private static String DEFAULT_SQL_PARTICIPANT_04 = null;
395   public static String SQL_PARTICIPANT_04 = null;
396   static {
397     DEFAULT_SQL_PARTICIPANT_04 = getDefaultProperty( PN_SQL_PARTICIPANT_04 );
398     theLog.info(
399       "DEFAULT_SQL_PARTICIPANT_04 == '" + DEFAULT_SQL_PARTICIPANT_04 + "'" );
400     SQL_PARTICIPANT_04 =
401       getProperty( PN_SQL_PARTICIPANT_04, DEFAULT_SQL_PARTICIPANT_04 );
402     theLog.info( "SQL_PARTICIPANT_04 == '" + SQL_PARTICIPANT_04 + "'" );
403   } // static
404 
405   /** Inserts a participant constrained by rowing state */
406   private static String DEFAULT_SQL_PARTICIPANT_05 = null;
407   public static String SQL_PARTICIPANT_05 = null;
408   static {
409     DEFAULT_SQL_PARTICIPANT_05 = getDefaultProperty( PN_SQL_PARTICIPANT_05 );
410     theLog.info(
411       "DEFAULT_SQL_PARTICIPANT_05 == '" + DEFAULT_SQL_PARTICIPANT_05 + "'" );
412     SQL_PARTICIPANT_05 =
413       getProperty( PN_SQL_PARTICIPANT_05, DEFAULT_SQL_PARTICIPANT_05 );
414     theLog.info( "SQL_PARTICIPANT_05 == '" + SQL_PARTICIPANT_05 + "'" );
415   } // static
416 
417   /** Deletes a participant */
418   private static String DEFAULT_SQL_PARTICIPANT_06 = null;
419   public static String SQL_PARTICIPANT_06 = null;
420   static {
421     DEFAULT_SQL_PARTICIPANT_06 = getDefaultProperty( PN_SQL_PARTICIPANT_06 );
422     theLog.info(
423       "DEFAULT_SQL_PARTICIPANT_06 == '" + DEFAULT_SQL_PARTICIPANT_06 + "'" );
424     SQL_PARTICIPANT_06 =
425       getProperty( PN_SQL_PARTICIPANT_06, DEFAULT_SQL_PARTICIPANT_06 );
426     theLog.info( "SQL_PARTICIPANT_06 == '" + SQL_PARTICIPANT_06 + "'" );
427   } // static
428 
429   /** Stores a participant */
430   private static String DEFAULT_SQL_PARTICIPANT_07 = null;
431   public static String SQL_PARTICIPANT_07 = null;
432   static {
433     DEFAULT_SQL_PARTICIPANT_07 = getDefaultProperty( PN_SQL_PARTICIPANT_07 );
434     theLog.info(
435       "DEFAULT_SQL_PARTICIPANT_07 == '" + DEFAULT_SQL_PARTICIPANT_07 + "'" );
436     SQL_PARTICIPANT_07 =
437       getProperty( PN_SQL_PARTICIPANT_07, DEFAULT_SQL_PARTICIPANT_07 );
438     theLog.info( "SQL_PARTICIPANT_07 == '" + SQL_PARTICIPANT_07 + "'" );
439   } // static
440 
441   /** Updates the next id for a participant */
442   private static String DEFAULT_SQL_PARTICIPANT_08 = null;
443   public static String SQL_PARTICIPANT_08 = null;
444   static {
445     DEFAULT_SQL_PARTICIPANT_08 = getDefaultProperty( PN_SQL_PARTICIPANT_08 );
446     theLog.info(
447       "DEFAULT_SQL_PARTICIPANT_08 == '" + DEFAULT_SQL_PARTICIPANT_08 + "'" );
448     SQL_PARTICIPANT_08 =
449       getProperty( PN_SQL_PARTICIPANT_08, DEFAULT_SQL_PARTICIPANT_08 );
450     theLog.info( "SQL_PARTICIPANT_08 == '" + SQL_PARTICIPANT_08 + "'" );
451   } // static
452 
453   /** Selects the next id for a participant */
454   private static String DEFAULT_SQL_PARTICIPANT_08A = null;
455   public static String SQL_PARTICIPANT_08A = null;
456   static {
457     DEFAULT_SQL_PARTICIPANT_08A = getDefaultProperty( PN_SQL_PARTICIPANT_08A );
458     theLog.info(
459       "DEFAULT_SQL_PARTICIPANT_08A == '" + DEFAULT_SQL_PARTICIPANT_08A + "'" );
460     SQL_PARTICIPANT_08A =
461       getProperty( PN_SQL_PARTICIPANT_08A, DEFAULT_SQL_PARTICIPANT_08A );
462     theLog.info( "SQL_PARTICIPANT_08A == '" + SQL_PARTICIPANT_08A + "'" );
463   } // static
464 
465   /** Inserts non-null participation data into temporary enrollment table */
466   private static String DEFAULT_SQL_ENROLLMENT_01 = null;
467   public static String SQL_ENROLLMENT_01 = null;
468   static {
469     DEFAULT_SQL_ENROLLMENT_01 = getDefaultProperty( PN_SQL_ENROLLMENT_01 );
470     theLog.info(
471       "DEFAULT_SQL_ENROLLMENT_01 == '" + DEFAULT_SQL_ENROLLMENT_01 + "'" );
472     SQL_ENROLLMENT_01 =
473       getProperty( PN_SQL_ENROLLMENT_01, DEFAULT_SQL_ENROLLMENT_01 );
474     theLog.info( "SQL_ENROLLMENT_01 == '" + SQL_ENROLLMENT_01 + "'" );
475   } // static
476 
477   /** Inserts null participation data into temporary enrollment table */
478   private static String DEFAULT_SQL_ENROLLMENT_02 = null;
479   public static String SQL_ENROLLMENT_02 = null;
480   static {
481     DEFAULT_SQL_ENROLLMENT_02 = getDefaultProperty( PN_SQL_ENROLLMENT_02 );
482     theLog.info(
483       "DEFAULT_SQL_ENROLLMENT_02 == '" + DEFAULT_SQL_ENROLLMENT_02 + "'" );
484     SQL_ENROLLMENT_02 =
485       getProperty( PN_SQL_ENROLLMENT_02, DEFAULT_SQL_ENROLLMENT_02 );
486     theLog.info( "SQL_ENROLLMENT_02 == '" + SQL_ENROLLMENT_02 + "'" );
487   } // static
488 
489 } // Configuration
490 
491 /*
492  * $Log: Configuration.java,v $
493  * Revision 1.4  2003/02/26 03:38:45  rphall
494  * Added copyright and GPL license
495  *
496  * Revision 1.3  2003/02/19 22:09:15  rphall
497  * Removed gratuitous use of CLRA acronym
498  *
499  */
500