annotate backend/src/main/java/org/dive4elements/river/backend/SedDBCredentials.java @ 8470:c5a7aae52396

Added a validation SQL query to database backends. Enable it by storing something like "SELECT 1 FROM DUAL" in config under /artifact-database/backend-database/validation-query/text() or /artifact-database/seddb-database/validation-query/text().
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 12 Nov 2014 13:31:53 +0100
parents 4c3ccf2b0304
children 026f4c684ee5
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
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
90 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
91 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
92
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_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
94 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
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_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
97 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
98 "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
99 "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
100
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 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
102 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
103 "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
104 "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
105
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 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
107 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
108 "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
109 "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
110
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
111 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
112 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
113 "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
114
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
115 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
116 System.getProperty(
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
117 "flys.seddb.connection.validation.query");
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
118
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
119 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
120 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
121 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
122 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
123 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
124 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
125 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
126 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
127 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
128 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
129 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
130 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
131 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
132 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
133 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
134 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
135 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
136 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
137 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
138 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
139 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
140 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
141 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
142 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
143 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
144 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
145 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
146 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
147 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
148 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
149 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
150 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
151 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
152 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
153 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
154 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
155 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
156 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
157 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
158 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
159 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
160 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
161 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
162 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
163 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
164 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
165 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
166 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
167 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
168 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
169 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
170 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
171 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
172 };
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
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 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
175
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 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
177 }
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 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
180 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
181 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
182 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
183 String driver,
5194
92c8f8d1a3ba Fix Credentials parameter order
Andre Heinecke <aheinecke@intevation.de>
parents: 5193
diff changeset
184 String url,
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
185 String connectionInitSqls,
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
186 String validationQuery
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
187 ) {
5194
92c8f8d1a3ba Fix Credentials parameter order
Andre Heinecke <aheinecke@intevation.de>
parents: 5193
diff changeset
188 super(
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
189 user, password, dialect, driver, url,
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
190 connectionInitSqls, validationQuery, 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
191 }
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
192
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
193 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
194 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
195 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
196 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
197 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
198 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
199 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
200 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
201 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
202 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
203 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
204 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
205 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
206 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
207 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
208 DEFAULT_CONNECTION_INIT_SQLS);
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
209 String validationQuery =
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
210 Config.getStringXPath(
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
211 XPATH_VALIDATION_QUERY,
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
212 DEFAULT_VALIDATION_QUERY);
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
213
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
214 instance = new SedDBCredentials(
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
215 user, password, dialect, driver, url,
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
216 connectionInitSqls, validationQuery);
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
217 }
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
218 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
219 }
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
220
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
221 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
222 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
223 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
224 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
225 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
226 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
227 DEFAULT_URL,
8470
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
228 DEFAULT_CONNECTION_INIT_SQLS,
c5a7aae52396 Added a validation SQL query to database backends.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5992
diff changeset
229 DEFAULT_VALIDATION_QUERY);
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
230 }
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 }
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 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

http://dive4elements.wald.intevation.org