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

annotate backend/src/main/java/org/dive4elements/river/backend/SedDBCredentials.java @ 8029:cdb9f6d97f6a

Added method to importer session to fetch the measurement station for given (river, km).

author	Sascha L. Teichmann <teichmann@intevation.de>
date	Thu, 10 Jul 2014 18:02:08 +0200
parents	4c3ccf2b0304
children	c5a7aae52396

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
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	87 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	88 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	89
76c75c8b9ee0 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_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	91 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	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_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	94 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	95 "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	96 "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	97
76c75c8b9ee0 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 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	99 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	100 "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	101 "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	102
76c75c8b9ee0 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 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	104 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	105 "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	106 "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	107
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	108 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	109 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	110 "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	111
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	112 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	113 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	114 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	115 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	116 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	117 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	118 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	119 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	120 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	121 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	122 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	123 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	124 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	125 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	126 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	127 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	128 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	129 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	130 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	131 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	132 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	133 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	134 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	135 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	136 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	137 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	138 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	139 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	140 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	141 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	142 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	143 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	144 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	145 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	146 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	147 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	148 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	149 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	150 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	151 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	152 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	153 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	154 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	155 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	156 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	157 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	158 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	159 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	160 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	161 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	162 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	163 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	164 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	165 };
76c75c8b9ee0 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
76c75c8b9ee0 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 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	168
76c75c8b9ee0 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 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	170 }
76c75c8b9ee0 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
76c75c8b9ee0 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 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	173 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	174 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	175 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	176 String driver,
5194 92c8f8d1a3ba Fix Credentials parameter order Andre Heinecke <aheinecke@intevation.de> parents: 5193 diff changeset	177 String url,
92c8f8d1a3ba Fix Credentials parameter order Andre Heinecke <aheinecke@intevation.de> parents: 5193 diff changeset	178 String connectionInitSqls
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	179 ) {
5194 92c8f8d1a3ba Fix Credentials parameter order Andre Heinecke <aheinecke@intevation.de> parents: 5193 diff changeset	180 super(
92c8f8d1a3ba Fix Credentials parameter order Andre Heinecke <aheinecke@intevation.de> parents: 5193 diff changeset	181 user, password, dialect, driver, url, connectionInitSqls, 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	182 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	183
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	184 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	185 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	186 String user =
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	187 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	188 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	189 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	190 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	191 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	192 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	193 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	194 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	195 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	196 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	197 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	198 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	199 DEFAULT_CONNECTION_INIT_SQLS);
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	200
76c75c8b9ee0 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 instance = new SedDBCredentials(
5194 92c8f8d1a3ba Fix Credentials parameter order Andre Heinecke <aheinecke@intevation.de> parents: 5193 diff changeset	202 user, password, dialect, driver, url, connectionInitSqls);
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	203 }
76c75c8b9ee0 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 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	205 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	206
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	207 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	208 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	209 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	210 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	211 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	212 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	213 DEFAULT_URL,
fb9dcc68b9c2 Possible fix for flys/1202. Initial SQL statements can now be issued at connection creation. Sascha L. Teichmann <teichmann@intevation.de> parents: 3333 diff changeset	214 DEFAULT_CONNECTION_INIT_SQLS);
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	215 }
76c75c8b9ee0 SedDB: Make access to SedDB configurable over conf.xml and provide access to sessions. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	216 }
76c75c8b9ee0 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 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/backend/SedDBCredentials.java @ 8029:cdb9f6d97f6a