java/sql-dk/src/info/globalcode/sql/dk/configuration/DatabaseDefinition.java
author František Kučera <franta-hg@frantovo.cz>
Thu, 25 Sep 2014 17:50:40 +0200
branchv_0
changeset 179 236332caeb29
parent 155 eb3676c6929b
child 184 53fb05ce504c
permissions -rw-r--r--
Basic JMX management/reporting – counters for commands and records
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     1
/**
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     2
 * SQL-DK
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     3
 * Copyright © 2013 František Kučera (frantovo.cz)
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     4
 *
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     5
 * This program is free software: you can redistribute it and/or modify
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     6
 * it under the terms of the GNU General Public License as published by
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     7
 * the Free Software Foundation, either version 3 of the License, or
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     8
 * (at your option) any later version.
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     9
 *
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    10
 * This program is distributed in the hope that it will be useful,
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    13
 * GNU General Public License for more details.
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    14
 *
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    15
 * You should have received a copy of the GNU General Public License
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    16
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    17
 */
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    18
package info.globalcode.sql.dk.configuration;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    19
30
b7ea47b2d4ca class for xmlns constants
František Kučera <franta-hg@frantovo.cz>
parents: 29
diff changeset
    20
import static info.globalcode.sql.dk.Xmlns.CONFIGURATION;
27
24aa5199bfd6 DatabaseConnection: just change package
František Kučera <franta-hg@frantovo.cz>
parents: 26
diff changeset
    21
import info.globalcode.sql.dk.DatabaseConnection;
179
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    22
import info.globalcode.sql.dk.jmx.ConnectionManagement;
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    23
import java.lang.management.ManagementFactory;
29
d66858b4b563 more configuration, more JAXB, more formatters
František Kučera <franta-hg@frantovo.cz>
parents: 27
diff changeset
    24
import java.sql.SQLException;
179
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    25
import java.util.Hashtable;
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    26
import java.util.logging.Level;
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    27
import java.util.logging.Logger;
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    28
import javax.management.MBeanServer;
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    29
import javax.management.ObjectName;
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    30
import javax.xml.bind.annotation.XmlElement;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    31
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    32
/**
155
eb3676c6929b more JavaDoc
František Kučera <franta-hg@frantovo.cz>
parents: 106
diff changeset
    33
 * Configured (but not yet connected) database connection.
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    34
 *
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    35
 * @author Ing. František Kučera (frantovo.cz)
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    36
 */
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    37
public class DatabaseDefinition implements NameIdentified {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    38
179
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    39
	private static final Logger log = Logger.getLogger(DatabaseDefinition.class.getName());
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    40
	private String name;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    41
	private String url;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    42
	private String userName;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    43
	private String password;
104
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    44
	private Properties properties = new Properties();
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    45
30
b7ea47b2d4ca class for xmlns constants
František Kučera <franta-hg@frantovo.cz>
parents: 29
diff changeset
    46
	@XmlElement(name = "name", namespace = CONFIGURATION)
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    47
	@Override
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    48
	public String getName() {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    49
		return name;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    50
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    51
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    52
	public void setName(String name) {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    53
		this.name = name;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    54
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    55
30
b7ea47b2d4ca class for xmlns constants
František Kučera <franta-hg@frantovo.cz>
parents: 29
diff changeset
    56
	@XmlElement(name = "url", namespace = CONFIGURATION)
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    57
	public String getUrl() {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    58
		return url;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    59
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    60
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    61
	public void setUrl(String url) {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    62
		this.url = url;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    63
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    64
30
b7ea47b2d4ca class for xmlns constants
František Kučera <franta-hg@frantovo.cz>
parents: 29
diff changeset
    65
	@XmlElement(name = "userName", namespace = CONFIGURATION)
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    66
	public String getUserName() {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    67
		return userName;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    68
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    69
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    70
	public void setUserName(String userName) {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    71
		this.userName = userName;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    72
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    73
30
b7ea47b2d4ca class for xmlns constants
František Kučera <franta-hg@frantovo.cz>
parents: 29
diff changeset
    74
	@XmlElement(name = "password", namespace = CONFIGURATION)
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    75
	public String getPassword() {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    76
		return password;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    77
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    78
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    79
	public void setPassword(String password) {
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    80
		this.password = password;
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    81
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    82
104
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    83
	@XmlElement(name = "property", namespace = CONFIGURATION)
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    84
	public Properties getProperties() {
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    85
		return properties;
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    86
	}
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    87
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    88
	public void setProperties(Properties properties) {
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    89
		this.properties = properties;
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    90
	}
245f1b88a3e6 formatter/database properties
František Kučera <franta-hg@frantovo.cz>
parents: 30
diff changeset
    91
106
e9c3583580c8 use database properties
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
    92
	/**
155
eb3676c6929b more JavaDoc
František Kučera <franta-hg@frantovo.cz>
parents: 106
diff changeset
    93
	 * @param properties ad-hoc properties from CLI options (for the JDBC driver)
179
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    94
	 * @param jmxBean JMX management bean for progress reporting | null = disable JMX
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    95
	 */
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    96
	public DatabaseConnection connect(Properties properties, ConnectionManagement jmxBean) throws SQLException {
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    97
		return new DatabaseConnection(this, properties, jmxBean);
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    98
	}
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
    99
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
   100
	/**
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
   101
	 * @see #connect(info.globalcode.sql.dk.configuration.Properties, java.lang.String)
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
   102
	 * With disabled JMX reporting.
106
e9c3583580c8 use database properties
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   103
	 */
e9c3583580c8 use database properties
František Kučera <franta-hg@frantovo.cz>
parents: 104
diff changeset
   104
	public DatabaseConnection connect(Properties properties) throws SQLException {
179
236332caeb29 Basic JMX management/reporting – counters for commands and records
František Kučera <franta-hg@frantovo.cz>
parents: 155
diff changeset
   105
		return new DatabaseConnection(this, properties, null);
26
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   106
	}
4ec8e5534eb9 configuration basics
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
   107
}