Mercurial > dive4elements > river
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 : |