Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/backend/SedDBCredentials.java @ 8485:026f4c684ee5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make maxWait configurable and wait for 30 seconds
author "Tom Gottfried <tom@intevation.de>"
date Fri, 28 Nov 2014 16:34:40 +0100
parents c5a7aae52396
children 6a4bdcccfa4d
rev   line source
5844
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
2 * Software engineering by Intevation GmbH
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
3 *
5992
4c3ccf2b0304 Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5874
diff changeset
4 * This file is Free Software under the GNU AGPL (>=v3)
5844
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
5992
4c3ccf2b0304 Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5874
diff changeset
6 * documentation coming with Dive4Elements River for details.
5844
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
7 */
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
8
5829
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
9 package org.dive4elements.river.backend;
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
10
5829
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
11 import org.dive4elements.artifacts.common.utils.Config;
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
12
5874
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
13 import org.dive4elements.river.seddb.model.Bezugspegel;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
14 import org.dive4elements.river.seddb.model.Bezugspegelgew;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
15 import org.dive4elements.river.seddb.model.BezugspegelgewId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
16 import org.dive4elements.river.seddb.model.Bild;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
17 import org.dive4elements.river.seddb.model.Gewaesser;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
18 import org.dive4elements.river.seddb.model.Gfaenger;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
19 import org.dive4elements.river.seddb.model.Glotlinks;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
20 import org.dive4elements.river.seddb.model.GlotlinksId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
21 import org.dive4elements.river.seddb.model.Glotrechte;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
22 import org.dive4elements.river.seddb.model.Gprobe;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
23 import org.dive4elements.river.seddb.model.GprobeId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
24 import org.dive4elements.river.seddb.model.Gsiebsatz;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
25 import org.dive4elements.river.seddb.model.Gsiebung;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
26 import org.dive4elements.river.seddb.model.Gsiebungsieb;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
27 import org.dive4elements.river.seddb.model.GsiebungsiebId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
28 import org.dive4elements.river.seddb.model.Hpeilpunkt;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
29 import org.dive4elements.river.seddb.model.HpeilpunktId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
30 import org.dive4elements.river.seddb.model.Hpeilung;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
31 import org.dive4elements.river.seddb.model.Messung;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
32 import org.dive4elements.river.seddb.model.Messunglotcount;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
33 import org.dive4elements.river.seddb.model.MessunglotcountId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
34 import org.dive4elements.river.seddb.model.Messungsta;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
35 import org.dive4elements.river.seddb.model.MessungstaId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
36 import org.dive4elements.river.seddb.model.Messunguferbezug;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
37 import org.dive4elements.river.seddb.model.MessunguferbezugId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
38 import org.dive4elements.river.seddb.model.Mpeilpunkt;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
39 import org.dive4elements.river.seddb.model.MpeilpunktId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
40 import org.dive4elements.river.seddb.model.Mpeilung;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
41 import org.dive4elements.river.seddb.model.Probebild;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
42 import org.dive4elements.river.seddb.model.Siebanalyse;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
43 import org.dive4elements.river.seddb.model.Slotlinks;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
44 import org.dive4elements.river.seddb.model.SlotlinksId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
45 import org.dive4elements.river.seddb.model.Slotrechte;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
46 import org.dive4elements.river.seddb.model.Sohlprobe;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
47 import org.dive4elements.river.seddb.model.Sohltest;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
48 import org.dive4elements.river.seddb.model.Sprobe;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
49 import org.dive4elements.river.seddb.model.SprobeId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
50 import org.dive4elements.river.seddb.model.Ssiebung;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
51 import org.dive4elements.river.seddb.model.Ssiebungsieb;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
52 import org.dive4elements.river.seddb.model.SsiebungsiebId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
53 import org.dive4elements.river.seddb.model.Station;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
54 import org.dive4elements.river.seddb.model.Stationgew;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
55 import org.dive4elements.river.seddb.model.StationgewId;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
56 import org.dive4elements.river.seddb.model.TmpGloChanged;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
57 import org.dive4elements.river.seddb.model.TmpMesAchanged;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
58 import org.dive4elements.river.seddb.model.TmpMesGchanged;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
59 import org.dive4elements.river.seddb.model.TmpMesQchanged;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
60 import org.dive4elements.river.seddb.model.TmpMesSchanged;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
61 import org.dive4elements.river.seddb.model.Zzarchiv;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
62 import org.dive4elements.river.seddb.model.Zzprobenahmeart;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
63 import org.dive4elements.river.seddb.model.Zzsondierungart;
7ba4815a52a4 river backend: Adjusted internal references to SedDB hibernate model.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
64 import org.dive4elements.river.seddb.model.Zzthema;
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
65
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
66 public class SedDBCredentials
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
67 extends Credentials
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
68 {
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
69 public static final String XPATH_USER =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
70 "/artifact-database/seddb-database/user/text()";
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
71
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
72 public static final String XPATH_PASSWORD =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
73 "/artifact-database/seddb-database/password/text()";
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
74
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
75 public static final String XPATH_DIALECT =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
76 "/artifact-database/seddb-database/dialect/text()";
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
77
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
78 public static final String XPATH_DRIVER =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
79 "/artifact-database/seddb-database/driver/text()";
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
80
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
81 public static final String XPATH_URL =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
82 "/artifact-database/seddb-database/url/text()";
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
83
5193
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
84 public static final String XPATH_CONNECTION_INIT_SQLS =
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
85 "/artifact-database/seddb-database/connection-init-sqls/text()";
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
86
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
87 public static final String XPATH_VALIDATION_QUERY =
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
88 "/artifact-database/seddb-database/validation-query/text()";
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
89
8485
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
90 public static final String XPATH_MAX_WAIT =
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
91 "/artifact-database/seddb-database/max-wait/text()";
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
92
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
93 public static final String DEFAULT_USER =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
94 System.getProperty("flys.seddb.user", "seddb");
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
95
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
96 public static final String DEFAULT_PASSWORD =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
97 System.getProperty("flys.seddb.password", "seddb");
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
98
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
99 public static final String DEFAULT_DIALECT =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
100 System.getProperty(
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
101 "flys.seddb.dialect",
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
102 "org.hibernate.dialect.PostgreSQLDialect");
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
103
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
104 public static final String DEFAULT_DRIVER =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
105 System.getProperty(
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
106 "flys.seddb.driver",
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
107 "org.postgresql.Driver");
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
108
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
109 public static final String DEFAULT_URL =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
110 System.getProperty(
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
111 "flys.seddb.url",
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
112 "jdbc:postgresql://localhost:5432/seddb");
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
113
5193
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
114 public static final String DEFAULT_CONNECTION_INIT_SQLS =
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
115 System.getProperty(
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
116 "flys.seddb.connection.init.sqls");
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
117
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
118 public static final String DEFAULT_VALIDATION_QUERY =
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
119 System.getProperty(
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
120 "flys.seddb.connection.validation.query");
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
121
8485
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
122 public static final String DEFAULT_MAX_WAIT =
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
123 System.getProperty("flys.seddb.connection.max.wait");
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
124
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
125 public static final Class [] CLASSES = {
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
126 BezugspegelgewId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
127 Bezugspegelgew.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
128 Bezugspegel.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
129 Bild.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
130 Gewaesser.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
131 Gfaenger.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
132 GlotlinksId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
133 Glotlinks.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
134 Glotrechte.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
135 GprobeId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
136 Gprobe.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
137 Gsiebsatz.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
138 Gsiebung.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
139 GsiebungsiebId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
140 Gsiebungsieb.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
141 HpeilpunktId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
142 Hpeilpunkt.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
143 Hpeilung.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
144 Messung.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
145 MessunglotcountId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
146 Messunglotcount.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
147 MessungstaId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
148 Messungsta.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
149 MessunguferbezugId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
150 Messunguferbezug.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
151 MpeilpunktId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
152 Mpeilpunkt.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
153 Mpeilung.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
154 Probebild.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
155 Siebanalyse.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
156 SlotlinksId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
157 Slotlinks.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
158 Slotrechte.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
159 Sohlprobe.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
160 Sohltest.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
161 SprobeId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
162 Sprobe.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
163 Ssiebung.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
164 SsiebungsiebId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
165 Ssiebungsieb.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
166 StationgewId.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
167 Stationgew.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
168 Station.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
169 TmpGloChanged.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
170 TmpMesAchanged.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
171 TmpMesGchanged.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
172 TmpMesQchanged.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
173 TmpMesSchanged.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
174 Zzarchiv.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
175 Zzprobenahmeart.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
176 Zzsondierungart.class,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
177 Zzthema.class
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
178 };
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
179
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
180 private static Credentials instance;
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
181
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
182 public SedDBCredentials() {
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
183 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
184
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
185 public SedDBCredentials(
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
186 String user,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
187 String password,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
188 String dialect,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
189 String driver,
5194
92c8f8d1a3ba Fix Credentials parameter order
Andre Heinecke <aheinecke@intevation.de>
parents: 5193
diff changeset
190 String url,
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
191 String connectionInitSqls,
8485
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
192 String validationQuery,
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
193 String maxWait
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
194 ) {
5194
92c8f8d1a3ba Fix Credentials parameter order
Andre Heinecke <aheinecke@intevation.de>
parents: 5193
diff changeset
195 super(
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
196 user, password, dialect, driver, url,
8485
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
197 connectionInitSqls, validationQuery, maxWait, CLASSES);
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
198 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
199
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
200 public static synchronized Credentials getInstance() {
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
201 if (instance == null) {
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
202 String user =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
203 Config.getStringXPath(XPATH_USER, DEFAULT_USER);
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
204 String password =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
205 Config.getStringXPath(XPATH_PASSWORD, DEFAULT_PASSWORD);
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
206 String dialect =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
207 Config.getStringXPath(XPATH_DIALECT, DEFAULT_DIALECT);
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
208 String driver =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
209 Config.getStringXPath(XPATH_DRIVER, DEFAULT_DRIVER);
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
210 String url =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
211 Config.getStringXPath(XPATH_URL, DEFAULT_URL);
5193
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
212 String connectionInitSqls =
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
213 Config.getStringXPath(
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
214 XPATH_CONNECTION_INIT_SQLS,
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
215 DEFAULT_CONNECTION_INIT_SQLS);
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
216 String validationQuery =
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
217 Config.getStringXPath(
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
218 XPATH_VALIDATION_QUERY,
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
219 DEFAULT_VALIDATION_QUERY);
8485
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
220 String maxWait =
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
221 Config.getStringXPath(XPATH_MAX_WAIT, DEFAULT_MAX_WAIT);
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
222
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
223 instance = new SedDBCredentials(
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
224 user, password, dialect, driver, url,
8485
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
225 connectionInitSqls, validationQuery, maxWait);
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
226 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
227 return instance;
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
228 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
229
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
230 public static Credentials getDefault() {
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
231 return new SedDBCredentials(
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
232 DEFAULT_USER,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
233 DEFAULT_PASSWORD,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
234 DEFAULT_DIALECT,
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
235 DEFAULT_DRIVER,
5193
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 3333
diff changeset
236 DEFAULT_URL,
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
237 DEFAULT_CONNECTION_INIT_SQLS,
8485
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
238 DEFAULT_VALIDATION_QUERY,
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
239 DEFAULT_MAX_WAIT
026f4c684ee5 Make maxWait configurable and wait for 30 seconds
"Tom Gottfried <tom@intevation.de>"
parents: 8470
diff changeset
240 );
3333
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
241 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
242 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
243 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
http://dive4elements.wald.intevation.org