Some problems encountered in work

1. There is no getter for property named 'batchno' in 'class db._default.Spd_podtl', It may be caused by duplicate packages （ rind ）
2. 'truncated incorrect double value：'XXXXX'',mysql Report errors , The reason is that the types of fields associated with the table are inconsistent , for example String = double
3. The timer starts , But there is no record in the operation history , It may be that the parameter is too long, causing the execution timer to fail
4. View the path of the project according to the port number ：

[user]$ lsof -i:8888
COMMAND   PID USER   FD   TYPE    DEVICE SIZE/OFF NODE NAME
java    12432 hscm  318u  IPv4 148424932      0t0  TCP *:wta-wsp-s (LISTEN)
java    12432 hscm  354u  IPv4 564688135      0t0  TCP localhost.localdomain:wta-wsp-s->192.168.1.103:57311 (ESTABLISHED)
java    12432 hscm  356u  IPv4 564681184      0t0  TCP localhost.localdomain:wta-wsp-s->192.168.1.103:57314 (ESTABLISHED)
java    12432 hscm  357u  IPv4 564686142      0t0  TCP localhost.localdomain:wta-wsp-s->192.168.1.103:57315 (ESTABLISHED)
java    12432 hscm  358u  IPv4 564170753      0t0  TCP localhost.localdomain:wta-wsp-s->192.168.1.103:57312 (ESTABLISHED)
[user]$ ll /proc/12432
# This is one of the output lines, which is the path 
lrwxrwxrwx  1 hscm hscm 0 7 month   14 15:28 cwd -> /home/hscm/spd-px/bin

5. Lock first and then query
6. root Account remote login is not available , You can log on to the server , Should be root The account does not authorize remote computer login

grant all privileges on *.* to ' user name '@'%' identified by ' The login password ' with grant option;
flush privileges;

7. In bad mood , Keep early hours
8. js Addition, subtraction, multiplication and division lose accuracy ：

//  Add 
function floatAdd(arg1, arg2) {
    
	var r1, r2, m;
	try {
    
		r1 = arg1.toString().split(".")[1].length;
	} catch (e) {
    
		r1 = 0;
	}
	try {
    
		r2 = arg2.toString().split(".")[1].length;
	} catch (e) {
    
		r2 = 0;
	}
	m = Math.pow(10, Math.max(r1, r2));
	return (floatMultiply(arg1 , m) + floatMultiply(arg2 , m)) / m;
}
 
//  reduce 
function floatSub(arg1, arg2) {
    
	var r1, r2, m, n;
	try {
    
		r1 = arg1.toString().split(".")[1].length;
	} catch (e) {
    
		r1 = 0;
	}
	try {
    
		r2 = arg2.toString().split(".")[1].length;
	} catch (e) {
    
		r2 = 0;
	}
	m = Math.pow(10, Math.max(r1, r2));
	//  Dynamic control precision length 
	n = (r1 >= r2) ? r1 : r2;
	return ((floatMultiply(arg1 , m) - floatMultiply(arg2 , m)) / m).toFixed(n);
}
 
//  ride 
function floatMultiply(arg1, arg2) {
    
	if(arg1 == null || arg2 == null){
    
		return null;
	}
	var n1,n2;
	var r1, r2; //  Decimal digit 
	try {
    
		r1 = arg1.toString().split(".")[1].length;
	} catch (e) {
    
		r1 = 0;
	}
	try {
    
		r2 = arg2.toString().split(".")[1].length;
	} catch (e) {
    
		r2 = 0;
	}
	n1 = Number(arg1.toString().replace(".", ""));
	n2 = Number(arg2.toString().replace(".", ""));
	return n1 * n2 / Math.pow(10, r1+r2);
}
 
//  except 
function floatDivide(arg1, arg2) {
    
	if(arg1 == null){
    
		return null;
	}
	if(arg2 == null || arg2 == 0){
    
		return null;
	}
	var n1,n2;
	var r1, r2; //  Decimal digit 
	try {
    
		r1 = arg1.toString().split(".")[1].length;
	} catch (e) {
    
		r1 = 0;
	}
	try {
    
		r2 = arg2.toString().split(".")[1].length;
	} catch (e) {
    
		r2 = 0;
	}
	n1 = Number(arg1.toString().replace(".", ""));
	n2 = Number(arg2.toString().replace(".", ""));
	return (n1 / n2) * Math.pow(10, r2 - r1);
}

9. Error in access address
   java.net.UnknownHostException Unable to open page :
   You need to configure ip domain name ：
   vi /etc/hosts
   Add a row ip Computer name （ Input hostname Check the computer name ）
   10.java The correct configuration of the environment does not work , Restarting the system can solve .
   11.mysql Configuration file for my.ini May be in C:\ProgramData\MySQL\MySQL Server 5.7 Next