Updates Issue 542
Merged all changes related to time zone processing on MySQL from 2.2.1 branch to trunk.  

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2691 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Fixes issue 1066 :
Regular expression used by the parser was not properly catching backquotes

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2692 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Remove .tmp from filename

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2693 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 992
CONT-34

Most of the implementation of dsctl utility, except the 'set' command and -log option.

* Notes of Importance *

n1.) Successfully executed commands are logged into dsctl.log, while errors are not. The idea behind this is to have a single audit log of all operations on position, in case they need to be reviewed. Errors are logged into stderr (see bellow) instead. -log option is not implemented at this point. dsctl uses log4j-dsctl.properties file, which can be adjusted manually, if needed.

n2.) stderr is used extensively. All errors go into stderr. Scripts that call dsctl should check for output there. For example: 'get' command will output JSON to stdout, but, upon failure, a message to stderr.

n3.) Exit codes are used too. Non-zero means there was an error while executing command. There are different codes for different errors, but they are not structured or documented at this point.

* QA Testing Requirements *

At minimum the following QA testing is required at this point:

t1.) Slight possibility for a regression: SqlCommitSeqno position retrieval query has been adjusted by adding two fields (task_id and update_timestamp). All relational DBMS types should be checked that they still work (i.e. Replicator starts up and transactions are correctly updated and read from trep_commit_seqno table).

t2.) Tests for 'get' and 'reset' commands for all file-based DBMS types. Both master and slaves should be checked. I have tested MySQL and Redshift.

t3.) Test behavior of 'get' and 'reset' on parallel replication with more than one channel.

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2694 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 992
CONT-34

Reducing two SQL queries, with same content, into a single one to avoid (and fix one that already appeared) bugs.

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2695 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 992
CONT-34
Status: QA

`dsctl set` implementation for SQL and file datasources.

* QA Testing Requirements *

t4.) Special care for Hadoop cases of get/reset/set combinations.

t5.) Check that `trepctl status` works after `dsctl set` under file datasources.

t5.) Check that parallel replication works. I.e. that running `reset`, then `set` and launching Replicator re-creates all the channels for both SQL and file datasources.

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2696 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 1070
Corrected formatting of MySQL DATETIME in applier to apply nano-second precision correctly.  Also fixed along the way an bug in initializing SQL load scripts in SqlConnectionManager that popped up in time-related data testing.  (Scripts were being ignored.)

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2697 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 1072
Fixed debug message

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2699 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
CONT-53

Adding the ping method based on the echo server. To enable it modify in the manager configuration file: policy.liveness.hostPingMethods=echo. The client sends the "Hello" message to the specified echo server and expects it back.

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2701 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
ading uptime to diagnostic package

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2702 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
CONT-53

Adding 'tping' utility. Usage: tping hostname portnumber timeout. The timeout is in milliseconds.

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2703 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
CONT-53

Fixed typo.

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2704 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 1065
Adding a way to identify whether a mysql connection supports microseconds precision
This is achieved by checking the datatype of timestamp variable (LONG if no microseconds / DOUBLE in the other case)

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2705 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 1065
Extracting microseconds part for the timestamp ('set timestamp = x') and storing them as options
(as this does not require a change of THL)

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2706 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 1065
Now applying microseconds to 'set timestamp = x'

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2707 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 1073
Added new call to SqlDataSource to allocate client managed JDBC connection so that status calls on MySQL do not generate a NullPointerException due to race conditions on pipeline startup and shutdown. 

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2708 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 1064

Make the test coverage conditional.

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2709 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Issue 1065
Fixed and simplified applier code

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2710 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Jira CONT-149. Adding a retry with sudo -n for capturing MySQL error log into diagnostic package

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2711 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928
Update Jira CONT-149. Inreasing MySQL error log lines to capture to 1000

git-svn-id: http://tungsten-replicator.googlecode.com/svn/trunk@2712 9f5e3340-5c9a-25cb-7c1c-c133a2e9e928