view flys-aft/ChangeLog @ 4086:ee0c60757a94

Added transaction support flys-aft/trunk@3566 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 02 Jan 2012 15:13:58 +0000
parents 067341e86375
children aad1886ea226
line wrap: on
line source
2012-01-02	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/db/ConnectionBuilder.java:
	  Set auto commit of new connection to false to enable transaction.

	* src/main/java/de/intevation/db/ConnectedStatements.java:
	  Added methods to begin, commit and rollback transactions.
	  Relies on savepoint support which is check by database metadata.

2011-12-22	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/aft/River.java: Figure out
	  which gauges must be updated, which must be created.

	* src/main/java/de/intevation/aft/DIPSGauge.java: Store
	  info from AFT and FLYS, too.

	* src/main/resources/sql/flys-common.properties: Fetch the
	  official number, too.
2011-12-20	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/aft/River.java: Removed
	  index DIPS gauge number -> DIPS gauge.

	* src/main/java/de/intevation/aft/SyncContext.java: Readded
	  here, because the index can be shared by all rivers.

2011-12-20	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* doc/repair.xsl: Repair XSL transform which brings the 
	  DIPS gauge numbers of the 15 FLYS gauges to the same
	  numbers as they are used in "Pegel Online".

	  !!! The purpose of this script is to do more repairing !!!

	* doc/pegelstationen.xml: Sub document of repair. Used
	  for lookup the correct pegel numbers.

	* doc/conf.xml: Changed to optionally load the repair XSLT.

	* src/main/java/de/intevation/aft/Sync.java: Load the
	  repair XSL transformation if configured.

	* src/main/java/de/intevation/utils/XML.java: Added code
	  to make XSL transforms possible.

	* src/main/java/de/intevation/aft/River.java,
	  src/main/java/de/intevation/aft/Rivers.java: Fixed logging.

2011-12-20	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/aft/River.java,
	  src/main/java/de/intevation/aft/DIPSGauge.java: Make DIPS check
	  more verbose.

2011-12-16	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/db/SymbolicStatement.java:
	  Made the setX() methods cascadable.

	* src/main/java/de/intevation/aft/River.java: Fetches
	  the gauges from the database.

	* src/main/resources/sql/aft-common.properties,
	  src/main/resources/sql/flys-common.properties: Added gauges
	  statements.

2011-12-14	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/db/SymbolicStatement.java:
	  Added execute(), executeQuery() & Co.

	* src/main/java/de/intevation/aft/IdPair.java: New. Base class
	  for id pairs to identify same object in both databases.

	* src/main/java/de/intevation/aft/River.java: New. To sync
	  the objects of one river.

	* src/main/java/de/intevation/aft/Rivers.java: Figure out
	  only the rivers which are in both databases and sync them.

	* src/main/java/de/intevation/aft/Sync.java: Only pass the
	  connected statements to the sync.

	* src/main/resources/sql/flys-common.properties: Fixed SQL for
	  fetching the rivers.
	
	* pom.xml: Added dependency to PostgreSQL.

	* doc/conf.xml: SQLite needs a driver class.

2011-12-13	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/db/ConnectionBuilder.java: Removed 
	  statements here.

	* src/main/java/de/intevation/db/Statements.java: Added method
	  to access the hole map of statements.

	* src/main/java/de/intevation/db/ConnectedStatements.java: New.
	  A cache that binds prepared statements to a connection.

2011-12-13	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/db/ConnectionBuilder.java: Added
	  access to Statements.

	* src/main/java/de/intevation/db/SymbolicStatement.java: New.
	  Made top level from inner class of Statements.

	* src/main/java/de/intevation/db/Statements.java: Moved SymbolicStatement
	  out to top level class.

	* src/main/java/de/intevation/aft/Rivers.java: Syncing beginns at
	  river level.

	* src/main/java/de/intevation/aft/Sync.java: Start the syncing with
	  the rivers of both dbs.

2011-12-13	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* doc/conf.xml: Adjusted structure to be more generic.

	* src/main/java/de/intevation/utils/XML.java: Allow namespace aware
	  file parsing.

	* src/main/java/de/intevation/db/ConnectionBuilder.java: New. Evaluate
	  config and builds a new db connection.

	* src/main/java/de/intevation/aft/Sync.java: Load config file.

	* pom.xml: Added dependency to SQLite JDBC driver.

2011-12-13	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* doc/conf.xml: New. Configuration file.

2011-12-13	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* ChangeLog: New. Argh! Forgot to check it in before.

	* src/main/java/de/intevation/utils/XML.java: New. XML/XPath support.
	  Mainly a stripped down version of
	  de.intevation.artifacts.common.utils.XMLUtils

2011-12-12	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/db/Statements.java: Added support
	  for symbolic prepared statements.

2011-12-12	Sascha L. Teichmann	<sascha.teichmann@inteavtion.de>

	* src/main/java/de/intevation/db/Statements.java: New. Load statements
	  from ressources.

	* src/main/resources/sql/aft-common.properties: New. Common statements
	  for the AFT side of the sync.

	* src/main/resources/sql/flys-common.properties: New. Common statements
	  for the FLYS side of the sync.

	* pom.xml: Added dependency to log4j

http://dive4elements.wald.intevation.org