Daily Summary (1)

--------------------------2016.12.06----------------------------------------
1. Write scripts
(1) Why not set the rollback point directly?
Because the database on the server is used by many people, so in addition to their own operations, there are many people operating.
If you set the rollback point, many people will disappear after the rollback, so the savepoint is not available.
However, you can write your own script and then set the rollback.
(2) Three files required to write a script
First, you must back up the data that needs to be modified (CREATE TABLE T_table_name_ date as SELECT * from T_table_name);
Second, modify the operation;
Third, rollback operation (INSERT INTO T_table_name select * from t_table_name_ date,
Merge into T_table_name t1 using t_table_name_ date t2 on (T1. Properties =t2. Properties) when matched then update
Set T1. Modified property =T2. Pre-modification properties
)
(3) Attention to the problem during script writing
1) logic must be repeatedly clear, the operation must be first backup, then modify, and finally rollback.
2) only need to back up the things you modify, but also can only modify the backup things, or rollback will certainly fail.
(4) After the script is finished, you must remember to test yourself, to see if the data is rolled back successfully, and only if the rollback succeeds in order for the script to be successful, otherwise it will fail.
2, how to reproduce the error (for example: repeated coverage to reach the limit)
(1) test server:
http://172.20.11.14:7001/admin/
Http://172.20.11.14:7002/datahub.ws/services Multiple Interface Services
Http://172.20.11.14:7003/datahub.ws.customer/services/Customer Interface Service (Customer Tax Advantage Inquiry, customer information confirmation, customer claims inquiry)
(2) Invoking the Project Atomic service via SOAPUI
1) Find the corresponding description WSDL in the test server webservice;
2) Call in Soapui, enter the correct username, password, policy number
3) Start the service and carry out the underwriting operation;
3, when the multi-table operation involves foreign keys, it is important to note that the deletion of a dependency table, and finally delete the table without dependencies;
However, when rolling back, be sure to roll back tables with no dependencies, and finally roll back tables with dependencies
4, when the query error, must pay attention to the technical inquiry:
(1) skillfully use the UE Baidu Editor (when a number of repetitive changes, can be achieved by automatic generation in Excel, in the Baidu editor to replace the empty quotes),
(2) When the customer code does not exist, pay attention to the customer information confirmation interface, input five basic information to generate customer code;
(3) The data in the modified table in Oracle must be for update;
(4) through SOAPUI to carry out multiple underwriting operations, ResultCode 1 for success, ResultCode for 0 when the failure, the success of underwriting 10 times, then reached the ceiling.
(5) Ctrl+e in ctrl+e:oracle can retrieve the SQL statements that have been manipulated;
5, when there is a lock table in PL/SQL, it is necessary to kill the process;
The last way is to commit the transaction, rollback the transaction two buttons to keep gray state, need data to commit, or rollback;

--------------------------2016.12.07----------------------------------------
1, user name, password
Enter the username and password in svn, and the user name and password are displayed again:
Password entered incorrectly or the user name is incorrect
2. Configuring Marven Environment variables
When configuring Marven environment variables, note that m2_home
Also note that when configured in path, it needs to be used for different environment variables;
Test Marven If the installation is successful, mvn-version
3. See the difference between SVN and git
4. How to keep the 12th row in the top and bottom slide in Excel
How to make a drop-down box in Excel with no resources present

Daily Summary (1)