[root@localhost Desktop]# rpm -qa | grep mysql
[root@localhost Desktop]# ll /zwf
total 875352
drwxrwsr-x. 9 100 users 4096 Aug 2 09:34 eclipse
drwxr-xr-x. 5 root root 4096 Aug 2 10:04 eclipse_workspace
drwxr-xr-x. 3 root root 4096 Aug 2 11:48 j2ee_workspace
drwxr-xr-x. 8 uucp 143 4096 Apr 10 2015 JDK7
-rwxrw-rw-. 1 root root 1609 Aug 2 12:35 Linux-Centos 7下mysql 5.7.9的rpm包的安装方式.txt
-rw-rw-rw-. 1 root root 1609 Apr 1 02:20 Linux-Centos 7下mysql 5.7.9的rpm包的安装方式.txt~
drwxr-xr-x. 2 root root 4096 Aug 2 12:13 logs
-rwxrw-rw-. 1 root root 448163840 Mar 31 20:57 mysql-5.7.17-1.el6.i686.rpm-bundle.tar
-rw-r--r--. 1 7155 31415 23161684 Nov 29 2016 mysql-community-client-5.7.17-1.el6.i686.rpm
-rw-r--r--. 1 7155 31415 335564 Nov 29 2016 mysql-community-common-5.7.17-1.el6.i686.rpm
-rw-r--r--. 1 7155 31415 3522268 Nov 29 2016 mysql-community-devel-5.7.17-1.el6.i686.rpm
-rw-r--r--. 1 7155 31415 37789324 Nov 29 2016 mysql-community-embedded-5.7.17-1.el6.i686.rpm
-rw-r--r--. 1 7155 31415 121592928 Nov 29 2016 mysql-community-embedded-devel-5.7.17-1.el6.i686.rpm
-rw-r--r--. 1 7155 31415 2103784 Nov 29 2016 mysql-community-libs-5.7.17-1.el6.i686.rpm
-rw-r--r--. 1 7155 31415 1692720 Nov 29 2016 mysql-community-libs-compat-5.7.17-1.el6.i686.rpm
-rw-r--r--. 1 7155 31415 156213704 Nov 29 2016 mysql-community-server-5.7.17-1.el6.i686.rpm
-rw-r--r--. 1 7155 31415 101736932 Nov 29 2016 mysql-community-test-5.7.17-1.el6.i686.rpm
drwxr-xr-x. 10 root root 4096 Aug 2 10:04 Tomcat7
[root@localhost Desktop]# rpm -ivh /zwf/mysql-community-common-5.7.17-1.el6.i686.rpm
warning: /zwf/mysql-community-common-5.7.17-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ########################################### [100%]
1:mysql-community-common ########################################### [100%]
[root@localhost Desktop]# rpm -ivh /zwf/mysql-community-libs-5.7.17-1.el6.i686.rpm
warning: /zwf/mysql-community-libs-5.7.17-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ########################################### [100%]
1:mysql-community-libs ########################################### [100%]
[root@localhost Desktop]# rpm -ivh /zwf/mysql-community-client-5.7.17-1.el6.i686.rpm
warning: /zwf/mysql-community-client-5.7.17-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ########################################### [100%]
1:mysql-community-client ########################################### [100%]
[root@localhost Desktop]# rpm -ivh /zwf/mysql-community-server-5.7.17-1.el6.i686.rpm
warning: /zwf/mysql-community-server-5.7.17-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ########################################### [100%]
1:mysql-community-server ########################################### [100%]
[root@localhost Desktop]# rpm -qa | grep mysql
mysql-community-client-5.7.17-1.el6.i686
mysql-community-server-5.7.17-1.el6.i686
mysql-community-common-5.7.17-1.el6.i686
mysql-community-libs-5.7.17-1.el6.i686
[root@localhost Desktop]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost Desktop]# netstat -anp|grep mysqld
[root@localhost Desktop]# service mysqld start
Initializing MySQL database: [ OK ]
Installing validate password plugin: [ OK ]
Starting mysqld: [ OK ]
[root@localhost Desktop]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost Desktop]# rpm -qal | grep mysql
/usr/share/doc/rsyslog-5.8.10/ommysql.html
/usr/share/doc/rsyslog-5.8.10/rsyslog_mysql.html
/usr/bin/mysql
/usr/bin/mysql_config_editor
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqlimport
/usr/bin/mysqlpump
/usr/bin/mysqlshow
/usr/bin/mysqlslap
/usr/share/doc/mysql-community-client-5.7.17
/usr/share/doc/mysql-community-client-5.7.17/COPYING
/usr/share/doc/mysql-community-client-5.7.17/README
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysql_config_editor.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqlbinlog.1.gz
/usr/share/man/man1/mysqlcheck.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlimport.1.gz
/usr/share/man/man1/mysqlpump.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/mysqlslap.1.gz
/usr/share/vim/vim72/syntax/mysql.vim
/usr/lib/python2.6/site-packages/sos/plugins/mysql.py
/usr/lib/python2.6/site-packages/sos/plugins/mysql.pyc
/usr/lib/python2.6/site-packages/sos/plugins/mysql.pyo
/etc/init.d/mysqld
/etc/logrotate.d/mysql
/usr/bin/mysql_install_db
/usr/bin/mysql_plugin
/usr/bin/mysql_secure_installation
/usr/bin/mysql_ssl_rsa_setup
/usr/bin/mysql_tzinfo_to_sql
/usr/bin/mysql_upgrade
/usr/bin/mysqld_multi
/usr/bin/mysqld_safe
/usr/bin/mysqldumpslow
/usr/lib/mysql/mecab
/usr/lib/mysql/mecab/dic
/usr/lib/mysql/mecab/dic/ipadic_euc-jp
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/char.bin
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/dicrc
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/left-id.def
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/matrix.bin
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/pos-id.def
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/rewrite.def
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/right-id.def
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/sys.dic
/usr/lib/mysql/mecab/dic/ipadic_euc-jp/unk.dic
/usr/lib/mysql/mecab/dic/ipadic_sjis
/usr/lib/mysql/mecab/dic/ipadic_sjis/char.bin
/usr/lib/mysql/mecab/dic/ipadic_sjis/dicrc
/usr/lib/mysql/mecab/dic/ipadic_sjis/left-id.def
/usr/lib/mysql/mecab/dic/ipadic_sjis/matrix.bin
/usr/lib/mysql/mecab/dic/ipadic_sjis/pos-id.def
/usr/lib/mysql/mecab/dic/ipadic_sjis/rewrite.def
/usr/lib/mysql/mecab/dic/ipadic_sjis/right-id.def
/usr/lib/mysql/mecab/dic/ipadic_sjis/sys.dic
/usr/lib/mysql/mecab/dic/ipadic_sjis/unk.dic
/usr/lib/mysql/mecab/dic/ipadic_utf-8
/usr/lib/mysql/mecab/dic/ipadic_utf-8/char.bin
/usr/lib/mysql/mecab/dic/ipadic_utf-8/dicrc
/usr/lib/mysql/mecab/dic/ipadic_utf-8/left-id.def
/usr/lib/mysql/mecab/dic/ipadic_utf-8/matrix.bin
/usr/lib/mysql/mecab/dic/ipadic_utf-8/pos-id.def
/usr/lib/mysql/mecab/dic/ipadic_utf-8/rewrite.def
/usr/lib/mysql/mecab/dic/ipadic_utf-8/right-id.def
/usr/lib/mysql/mecab/dic/ipadic_utf-8/sys.dic
/usr/lib/mysql/mecab/dic/ipadic_utf-8/unk.dic
/usr/lib/mysql/mecab/etc
/usr/lib/mysql/mecab/etc/mecabrc
/usr/lib/mysql/plugin
/usr/lib/mysql/plugin/adt_null.so
/usr/lib/mysql/plugin/auth_socket.so
/usr/lib/mysql/plugin/connection_control.so
/usr/lib/mysql/plugin/debug
/usr/lib/mysql/plugin/debug/adt_null.so
/usr/lib/mysql/plugin/debug/auth_socket.so
/usr/lib/mysql/plugin/debug/connection_control.so
/usr/lib/mysql/plugin/debug/group_replication.so
/usr/lib/mysql/plugin/debug/ha_example.so
/usr/lib/mysql/plugin/debug/innodb_engine.so
/usr/lib/mysql/plugin/debug/keyring_file.so
/usr/lib/mysql/plugin/debug/keyring_udf.so
/usr/lib/mysql/plugin/debug/libmemcached.so
/usr/lib/mysql/plugin/debug/libpluginmecab.so
/usr/lib/mysql/plugin/debug/locking_service.so
/usr/lib/mysql/plugin/debug/mypluglib.so
/usr/lib/mysql/plugin/debug/mysql_no_login.so
/usr/lib/mysql/plugin/debug/mysqlx.so
/usr/lib/mysql/plugin/debug/rewrite_example.so
/usr/lib/mysql/plugin/debug/rewriter.so
/usr/lib/mysql/plugin/debug/semisync_master.so
/usr/lib/mysql/plugin/debug/semisync_slave.so
/usr/lib/mysql/plugin/debug/validate_password.so
/usr/lib/mysql/plugin/debug/version_token.so
/usr/lib/mysql/plugin/group_replication.so
/usr/lib/mysql/plugin/ha_example.so
/usr/lib/mysql/plugin/innodb_engine.so
/usr/lib/mysql/plugin/keyring_file.so
/usr/lib/mysql/plugin/keyring_udf.so
/usr/lib/mysql/plugin/libmemcached.so
/usr/lib/mysql/plugin/libpluginmecab.so
/usr/lib/mysql/plugin/locking_service.so
/usr/lib/mysql/plugin/mypluglib.so
/usr/lib/mysql/plugin/mysql_no_login.so
/usr/lib/mysql/plugin/mysqlx.so
/usr/lib/mysql/plugin/rewrite_example.so
/usr/lib/mysql/plugin/rewriter.so
/usr/lib/mysql/plugin/semisync_master.so
/usr/lib/mysql/plugin/semisync_slave.so
/usr/lib/mysql/plugin/validate_password.so
/usr/lib/mysql/plugin/version_token.so
/usr/sbin/mysqld
/usr/sbin/mysqld-debug
/usr/share/doc/mysql-community-server-5.7.17
/usr/share/doc/mysql-community-server-5.7.17/COPYING
/usr/share/doc/mysql-community-server-5.7.17/ChangeLog
/usr/share/doc/mysql-community-server-5.7.17/INFO_BIN
/usr/share/doc/mysql-community-server-5.7.17/INFO_SRC
/usr/share/doc/mysql-community-server-5.7.17/README
/usr/share/doc/mysql-community-server-5.7.17/my-default.cnf
/usr/share/man/man1/mysql.server.1.gz
/usr/share/man/man1/mysql_install_db.1.gz
/usr/share/man/man1/mysql_plugin.1.gz
/usr/share/man/man1/mysql_secure_installation.1.gz
/usr/share/man/man1/mysql_ssl_rsa_setup.1.gz
/usr/share/man/man1/mysql_tzinfo_to_sql.1.gz
/usr/share/man/man1/mysql_upgrade.1.gz
/usr/share/man/man1/mysqld_multi.1.gz
/usr/share/man/man1/mysqld_safe.1.gz
/usr/share/man/man1/mysqldumpslow.1.gz
/usr/share/man/man1/mysqlman.1.gz
/usr/share/man/man8/mysqld.8.gz
/usr/share/mysql/dictionary.txt
/usr/share/mysql/fill_help_tables.sql
/usr/share/mysql/innodb_memcached_config.sql
/usr/share/mysql/install_rewriter.sql
/usr/share/mysql/magic
/usr/share/mysql/my-default.cnf
/usr/share/mysql/mysql-log-rotate
/usr/share/mysql/mysql_security_commands.sql
/usr/share/mysql/mysql_sys_schema.sql
/usr/share/mysql/mysql_system_tables.sql
/usr/share/mysql/mysql_system_tables_data.sql
/usr/share/mysql/mysql_test_data_timezone.sql
/usr/share/mysql/uninstall_rewriter.sql
/var/lib/mysql
/var/lib/mysql-files
/var/lib/mysql-keyring
/var/run/mysqld
/usr/share/selinux/devel/include/services/mysql.if
/usr/share/doc/mysql-community-common-5.7.17
/usr/share/doc/mysql-community-common-5.7.17/COPYING
/usr/share/doc/mysql-community-common-5.7.17/README
/usr/share/mysql/bulgarian
/usr/share/mysql/bulgarian/errmsg.sys
/usr/share/mysql/charsets
/usr/share/mysql/charsets/Index.xml
/usr/share/mysql/charsets/README
/usr/share/mysql/charsets/armscii8.xml
/usr/share/mysql/charsets/ascii.xml
/usr/share/mysql/charsets/cp1250.xml
/usr/share/mysql/charsets/cp1251.xml
/usr/share/mysql/charsets/cp1256.xml
/usr/share/mysql/charsets/cp1257.xml
/usr/share/mysql/charsets/cp850.xml
/usr/share/mysql/charsets/cp852.xml
/usr/share/mysql/charsets/cp866.xml
/usr/share/mysql/charsets/dec8.xml
/usr/share/mysql/charsets/geostd8.xml
/usr/share/mysql/charsets/greek.xml
/usr/share/mysql/charsets/hebrew.xml
/usr/share/mysql/charsets/hp8.xml
/usr/share/mysql/charsets/keybcs2.xml
/usr/share/mysql/charsets/koi8r.xml
/usr/share/mysql/charsets/koi8u.xml
/usr/share/mysql/charsets/latin1.xml
/usr/share/mysql/charsets/latin2.xml
/usr/share/mysql/charsets/latin5.xml
/usr/share/mysql/charsets/latin7.xml
/usr/share/mysql/charsets/macce.xml
/usr/share/mysql/charsets/macroman.xml
/usr/share/mysql/charsets/swe7.xml
/usr/share/mysql/czech
/usr/share/mysql/czech/errmsg.sys
/usr/share/mysql/danish
/usr/share/mysql/danish/errmsg.sys
/usr/share/mysql/dutch
/usr/share/mysql/dutch/errmsg.sys
/usr/share/mysql/english
/usr/share/mysql/english/errmsg.sys
/usr/share/mysql/errmsg-utf8.txt
/usr/share/mysql/estonian
/usr/share/mysql/estonian/errmsg.sys
/usr/share/mysql/french
/usr/share/mysql/french/errmsg.sys
/usr/share/mysql/german
/usr/share/mysql/german/errmsg.sys
/usr/share/mysql/greek
/usr/share/mysql/greek/errmsg.sys
/usr/share/mysql/hungarian
/usr/share/mysql/hungarian/errmsg.sys
/usr/share/mysql/italian
/usr/share/mysql/italian/errmsg.sys
/usr/share/mysql/japanese
/usr/share/mysql/japanese/errmsg.sys
/usr/share/mysql/korean
/usr/share/mysql/korean/errmsg.sys
/usr/share/mysql/norwegian
/usr/share/mysql/norwegian-ny
/usr/share/mysql/norwegian-ny/errmsg.sys
/usr/share/mysql/norwegian/errmsg.sys
/usr/share/mysql/polish
/usr/share/mysql/polish/errmsg.sys
/usr/share/mysql/portuguese
/usr/share/mysql/portuguese/errmsg.sys
/usr/share/mysql/romanian
/usr/share/mysql/romanian/errmsg.sys
/usr/share/mysql/russian
/usr/share/mysql/russian/errmsg.sys
/usr/share/mysql/serbian
/usr/share/mysql/serbian/errmsg.sys
/usr/share/mysql/slovak
/usr/share/mysql/slovak/errmsg.sys
/usr/share/mysql/spanish
/usr/share/mysql/spanish/errmsg.sys
/usr/share/mysql/swedish
/usr/share/mysql/swedish/errmsg.sys
/usr/share/mysql/ukrainian
/usr/share/mysql/ukrainian/errmsg.sys
/usr/share/man/man5/mysql_table.5.gz
/etc/ld.so.conf.d/mysql-i386.conf
/usr/lib/mysql
/usr/lib/mysql/libmysqlclient.so.20
/usr/lib/mysql/libmysqlclient.so.20.3.4
/usr/share/doc/mysql-community-libs-5.7.17
/usr/share/doc/mysql-community-libs-5.7.17/COPYING
/usr/share/doc/mysql-community-libs-5.7.17/README
/usr/share/selinux/targeted/mysql.pp.bz2
[root@localhost Desktop]# mysql -P 3306 -h 127.0.0.1 -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost Desktop]# mysql -P 3306 -h 127.0.0.1 -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost Desktop]# mysql -P 3306 -h 127.0.0.1 -u root -P
mysql: [ERROR] mysql: option '-P' requires an argument
[root@localhost Desktop]# mysql -P 3306 -h 127.0.0.1 -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost Desktop]# /usr/bin/mysqladmin -u root password 123456
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[root@localhost Desktop]# /usr/bin/mysqladmin -u root password 123456
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[root@localhost Desktop]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost Desktop]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost Desktop]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
[root@localhost Desktop]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[1] 5116
[root@localhost Desktop]# 2017-08-02T19:59:39.936757Z mysqld_safe Logging to '/var/log/mysqld.log'.
2017-08-02T19:59:39.957441Z mysqld_safe Logging to '/var/log/mysqld.log'.
2017-08-02T19:59:40.063253Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[root@localhost Desktop]#
[root@localhost Desktop]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
mysql> UPDATE user SET authentication_string=PASSWORD('newpassword') where USER='root';
Query OK, 1 row affected, 1 warning (0.07 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)
mysql> quit
Bye
[root@localhost Desktop]# /etc/init.d/mysqld restart
2017-08-02T20:02:02.581750Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[1]+ Done mysqld_safe --user=mysql --skip-grant-tables --skip-networking
[root@localhost Desktop]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost Desktop]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.17
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> UPDATE user SET authentication_string=PASSWORD('root') where USER='root';
ERROR 1046 (3D000): No database selected
mysql> use mysql
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> show databases
-> ;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> show database
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> quit;
Bye
[root@localhost Desktop]#
[root@localhost Desktop]# mysql -u root mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost Desktop]#
[root@localhost Desktop]#
[root@localhost Desktop]#
[root@localhost Desktop]#
[root@localhost Desktop]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
[root@localhost Desktop]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking
2017-08-02T20:06:59.953017Z mysqld_safe Logging to '/var/log/mysqld.log'.
2017-08-02T20:06:59.957013Z mysqld_safe Logging to '/var/log/mysqld.log'.
2017-08-02T20:06:59.992796Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Aug 02, 2017 11:46:07 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:HRMS' did not find a matching property.
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version: Apache Tomcat/7.0.67
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server built: Dec 7 2015 13:07:11 UTC
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server number: 7.0.67.0
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Name: Linux
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Version: 2.6.32-504.el6.i686
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Architecture: i386
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Java Home: /zwf/JDK7/jre
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Version: 1.7.0_80-b15
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Vendor: Oracle Corporation
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_BASE: /zwf/Tomcat7
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_HOME: /zwf/Tomcat7
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:55436
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.base=/zwf/Tomcat7
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.home=/zwf/Tomcat7
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dwtp.deploy=/zwf/Tomcat7/webapps
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.endorsed.dirs=/zwf/Tomcat7/endorsed
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dfile.encoding=UTF-8
Aug 02, 2017 11:46:07 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /zwf/JDK7/jre/lib/i386/client:/zwf/JDK7/jre/lib/i386::/usr/java/packages/lib/i386:/lib:/usr/lib
Aug 02, 2017 11:46:07 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8089"]
Aug 02, 2017 11:46:07 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Aug 02, 2017 11:46:07 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 684 ms
Aug 02, 2017 11:46:07 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Aug 02, 2017 11:46:07 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.67
Aug 02, 2017 11:46:09 PM org.apache.catalina.startup.TldConfig execute
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
Aug 02, 2017 11:46:09 PM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
Aug 02, 2017 11:46:09 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
[org.springframework.web.context.ContextLoader]Root WebApplicationContext: initialization started
[org.springframework.web.context.support.XmlWebApplicationContext]Refreshing Root WebApplicationContext: startup date [Wed Aug 02 23:46:09 PDT 2017]; root of context hierarchy
[org.springframework.beans.factory.xml.XmlBeanDefinitionReader]Loading XML bean definitions from file [/zwf/Tomcat7/webapps/HRMS/WEB-INF/classes/spring-context.xml]
[org.springframework.beans.factory.config.PropertyPlaceholderConfigurer]Loading properties file from class path resource [config.properties]
[org.springframework.beans.factory.support.DefaultListableBeanFactory]Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@16d50a6: defining beans [mvcContentNegotiationManager,org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping#0,org.springframework.format.support.FormattingConversionServiceFactoryBean#0,org.springframework.validation.beanvalidation.LocalValidatorFactoryBean#0,org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter#0,org.springframework.web.servlet.handler.MappedInterceptor#0,org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver#0,org.springframework.web.servlet.mvc.annotation.ResponseStatusExceptionResolver#0,org.springframework.web.servlet.mvc.support.DefaultHandlerExceptionResolver#0,org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping,org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter,org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter,exceptionIntercept,employeesInternshipController,accountController,employeesFormalController,positionController,trainingController,moduleController,departmentController,roleController,addressController,supportController,employeesDepartureController,roleModuleServiceImpl,trainingServiceImpl,employeesServiceImpl,employeesLogServiceImpl,positionServiceImpl,accountServiceImpl,moduleServiceImpl,addressServiceImpl,roleServiceImpl,departmentServiceImpl,employeesTrainingLogDao,positionDao,trainingNoteDao,accountRoleDao,addressDao,provinceDao,moduleDao,choosePoliticsDao,roleDao,trainingDao,chooseMarriageDao,employeesLogDao,townshipDao,cityDao,accountDao,roleModuleDao,villageDao,chooseEducationDao,countyDao,chooseNationalDao,departmentDao,employeesCompanyDao,employeesDetailDao,employeesBasicDao,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,multipartResolver,dataSource,sessionFactory,txManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,org.springframework.web.servlet.handler.MappedInterceptor#1,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor]; root of factory hierarchy
[com.mchange.v2.log.MLog]MLog clients using log4j logging.
[com.mchange.v2.c3p0.C3P0Registry]Initializing c3p0-0.9.5-pre8 [built 04-April-2014 04:08:13 -0700; debug? true; trace: 10]
[org.hibernate.cfg.annotations.Version]Hibernate Annotations 3.4.0.GA
[org.hibernate.cfg.Environment]Hibernate 3.2.1
[org.hibernate.cfg.Environment]hibernate.properties not found
[org.hibernate.cfg.Environment]Bytecode provider name : cglib
[org.hibernate.cfg.Environment]using JDK 1.4 java.sql.Timestamp handling
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeModule
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeModule on table te_module
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeProvince
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeProvince on table te_province
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeEmployeesBasic
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeEmployeesBasic on table te_employees_basic
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeCounty
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeCounty on table te_county
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeCity
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeCity on table te_city
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeTrainingNote
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeTrainingNote on table te_training_note
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeChooseMarriage
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeChooseMarriage on table te_choose_marriage
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeEmployeesCompany
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeEmployeesCompany on table te_employees_company
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeTraining
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeTraining on table te_training
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TePosition
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TePosition on table te_position
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeChooseEducation
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeChooseEducation on table te_choose_education
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeChooseNational
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeChooseNational on table te_choose_national
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeChoosePolitics
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeChoosePolitics on table te_choose_politics
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeEmployeesDetail
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeEmployeesDetail on table te_employees_detail
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeEmployeesLog
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeEmployeesLog on table te_employees_log
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeDepartment
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeDepartment on table te_department
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeAccountRole
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeAccountRole on table te_account_role
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeRoleModule
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeRoleModule on table te_role_module
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeVillage
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeVillage on table te_village
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeTownship
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeTownship on table te_township
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeAddress
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeAddress on table te_address
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeRole
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeRole on table te_role
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeEmployeesTrainingLog
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeEmployeesTrainingLog on table te_employees_training_log
[org.hibernate.cfg.AnnotationBinder]Binding entity from annotated class: com.empl.mgr.model.TeAccount
[org.hibernate.cfg.annotations.EntityBinder]Bind entity com.empl.mgr.model.TeAccount on table te_account
[org.hibernate.cfg.AnnotationConfiguration]Hibernate Validator not found: ignoring
[org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean]Building new Hibernate SessionFactory
[org.hibernate.cfg.search.HibernateSearchEventListenerRegister]Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
[org.hibernate.connection.ConnectionProviderFactory]Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
[com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource]Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 10, acquireRetryDelay -> 2000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> z8kflt9p1aak8do1ucuwpi|d6847b, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceUseNamedDriverClass -> false, identityToken -> z8kflt9p1aak8do1ucuwpi|d6847b, idleConnectionTestPeriod -> 60, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://127.0.0.1:3306/hrms?setUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 50, maxPoolSize -> 50, maxStatements -> 200, maxStatementsPerConnection -> 200, minPoolSize -> 8, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
[com.mchange.v2.resourcepool.BasicResourcePool]com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@15644bf -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor21.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:172)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1814)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 20 more
[com.mchange.v2.resourcepool.BasicResourcePool]com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@27d21 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor21.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:172)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1814)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 20 more
[com.mchange.v2.resourcepool.BasicResourcePool]Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@cd0613 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[com.mchange.v2.resourcepool.BasicResourcePool]Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@cd0613 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[com.mchange.v2.resourcepool.BasicResourcePool]com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4525aa -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor21.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:172)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1814)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 20 more
[com.mchange.v2.resourcepool.BasicResourcePool]Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@cd0613 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[com.mchange.v2.resourcepool.BasicResourcePool]com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@fd87b1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor21.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:172)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1814)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 20 more
[com.mchange.v2.resourcepool.BasicResourcePool]Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@cd0613 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[org.hibernate.util.JDBCExceptionReporter]SQL Error: 0, SQLState: null
[org.hibernate.util.JDBCExceptionReporter]Connections could not be acquired from the underlying database!
[org.hibernate.cfg.SettingsFactory]Could not obtain connection metadata
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:863)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:782)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:188)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:271)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:121)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:623)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1075)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:979)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:438)
at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1188)
at org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:277)
at org.springframework.web.servlet.handler.AbstractHandlerMapping.detectMappedInterceptors(AbstractHandlerMapping.java:221)
at org.springframework.web.servlet.handler.AbstractHandlerMapping.initApplicationContext(AbstractHandlerMapping.java:196)
at org.springframework.context.support.ApplicationObjectSupport.initApplicationContext(ApplicationObjectSupport.java:119)
at org.springframework.web.context.support.WebApplicationObjectSupport.initApplicationContext(WebApplicationObjectSupport.java:72)
at org.springframework.context.support.ApplicationObjectSupport.setApplicationContext(ApplicationObjectSupport.java:73)
at org.springframework.context.support.ApplicationContextAwareProcessor.invokeAwareInterfaces(ApplicationContextAwareProcessor.java:117)
at org.springframework.context.support.ApplicationContextAwareProcessor.postProcessBeforeInitialization(ApplicationContextAwareProcessor.java:92)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:396)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1505)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1422)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:606)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:526)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:756)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:683)
... 97 more
[com.mchange.v2.resourcepool.BasicResourcePool]com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@8860cc -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor21.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:172)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1814)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 20 more
[com.mchange.v2.resourcepool.BasicResourcePool]com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1ed364e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor21.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:172)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1814)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 20 more
[com.mchange.v2.resourcepool.BasicResourcePool]com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1bd7f3f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.GeneratedConstructorAccessor21.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:172)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1814)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 20 more
[com.mchange.v2.resourcepool.BasicResourcePool]Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@cd0613 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[com.mchange.v2.resourcepool.BasicResourcePool]Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@cd0613 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[com.mchange.v2.resourcepool.BasicResourcePool]Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@cd0613 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[org.hibernate.dialect.Dialect]Using dialect: org.hibernate.dialect.MySQL5Dialect
[org.hibernate.transaction.TransactionFactoryFactory]Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
[org.hibernate.transaction.TransactionManagerLookupFactory]No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[org.hibernate.cfg.SettingsFactory]Automatic flush during beforeCompletion(): disabled
[org.hibernate.cfg.SettingsFactory]Automatic session close at end of transaction: disabled
[org.hibernate.cfg.SettingsFactory]Scrollable result sets: disabled
[org.hibernate.cfg.SettingsFactory]JDBC3 getGeneratedKeys(): disabled
[org.hibernate.cfg.SettingsFactory]Connection release mode: auto
[org.hibernate.cfg.SettingsFactory]Maximum outer join fetch depth: 2
[org.hibernate.cfg.SettingsFactory]Default batch fetch size: 1
[org.hibernate.cfg.SettingsFactory]Generate SQL with comments: disabled
[org.hibernate.cfg.SettingsFactory]Order SQL updates by primary key: disabled
[org.hibernate.cfg.SettingsFactory]Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[org.hibernate.hql.ast.ASTQueryTranslatorFactory]Using ASTQueryTranslatorFactory
[org.hibernate.cfg.SettingsFactory]Query language substitutions: {}
[org.hibernate.cfg.SettingsFactory]JPA-QL strict compliance: disabled
[org.hibernate.cfg.SettingsFactory]Second-level cache: enabled
[org.hibernate.cfg.SettingsFactory]Query cache: disabled
[org.hibernate.cfg.SettingsFactory]Cache provider: org.hibernate.cache.NoCacheProvider
[org.hibernate.cfg.SettingsFactory]Optimize cache for minimal puts: disabled
[org.hibernate.cfg.SettingsFactory]Structured second-level cache entries: disabled
[org.hibernate.cfg.SettingsFactory]Statistics: disabled
[org.hibernate.cfg.SettingsFactory]Deleted entity synthetic identifier rollback: disabled
[org.hibernate.cfg.SettingsFactory]Default entity-mode: pojo
[org.hibernate.impl.SessionFactoryImpl]building session factory
[org.hibernate.impl.SessionFactoryObjectFactory]Not binding factory to JNDI, no JNDI name configured
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/internship/findChoose],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesInternshipController.findChoose()
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/internship/saveEmployeesInfo],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesInternshipController.saveEmployeesInfo(java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/internship/findEmployeesInternshipList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesInternshipController.findEmployeesInternshipList(int,java.lang.String,long,long,int,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/internship/findEmployeesInternshipPage],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesInternshipController.findEmployeesInternshipPage(int,java.lang.String,long,long,int,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/internship/enroll],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesInternshipController.enroll(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/internship/eliminate],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesInternshipController.eliminate(long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/internship/findEmployeesInfo],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesInternshipController.findEmployeesInfo(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/internship/modifyEmployeesInfo],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesInternshipController.modifyEmployeesInfo(java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/findAccountInfo],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.findAccountInfo(javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/addAccount],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.addAccount(java.lang.String,java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/findAccountList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.findAccountList(int,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/findAccountPage],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.findAccountPage(int,java.lang.String)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/delAccount],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.delAccount(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/initPassword],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.initPassword(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/modifyNickname],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.modifyNickname(long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/findAccountById],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.findAccountById(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/addAccountRole],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.addAccountRole(long,java.lang.String,boolean,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/account/findRole],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.AccountController.findRole(java.lang.String)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/formal/findEmployeesTrainingList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesFormalController.findEmployeesInternshipList(int,java.lang.String,long,long,int,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/formal/findEmployeesTrainingPage],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesFormalController.findEmployeesInternshipPage(int,java.lang.String,long,long,int,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/formal/findTrainingRecord],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesFormalController.findCanTrainingList(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/formal/departure],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesFormalController.departure(long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/position/findPositionPage],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.PositionController.findPositionPage(int,long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/position/addPosition],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.PositionController.addPosition(long,java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/position/deletePosition],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.PositionController.deletePosition(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/position/findPositionById],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.PositionController.findPositionById(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/position/modifyPosition],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.PositionController.modifyPosition(long,long,java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/position/findAllDepartment],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.PositionController.findAllDepartment()
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/position/findPositionListInfo],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.PositionController.findPositionListInfo(int,long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/findEmployeesList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.findEmployeesList(long,long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/addTraining],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.addTraining(java.lang.String,java.lang.String,java.lang.String,java.lang.String,boolean,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/modifyTraining],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.modifyTraining(long,java.lang.String,java.lang.String,java.lang.String,java.lang.String,boolean,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/findTrainingList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.findTrainingList(java.lang.String,int,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/findTrainingPage],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.findTrainingPage(java.lang.String,int,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/findTrainingInfoById],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.findTrainingInfoById(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/findRecord],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.showRecord(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/addTrainingByEmplId],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.addTrainingByEmplId(long,long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/delEmployeesTrainingRecord],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.delEmployeesTrainingRecord(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/stopEmployeesTraining],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.stopEmployeesTraining(long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/evaluationEmployeesTraining],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.evaluationEmployeesTraining(long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/addAllTraining],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.addAllTraining(long,long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/start],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.start(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/stop],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.stop(long,java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/training/delete],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.TrainingController.delete(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findMenu],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.ModuleController.findMenu(javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findModuleParameter],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.ModuleController.findModuleParameter(java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/department/setPrincipal],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.DepartmentController.setPrincipal(long,long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/department/findDepartmentList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.DepartmentController.findDepartmentList(int,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/department/findDepartmentCount],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.DepartmentController.findDepartmentCount(int,java.lang.String)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/department/findDepartmentById],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.DepartmentController.findDepartmentById(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/department/modifyDepartment],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.DepartmentController.modifyDepartment(long,java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/department/addDepartment],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.DepartmentController.addDepartment(java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/department/deleteDepartment],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.DepartmentController.deleteDepartment(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/department/findDeptEmplList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.DepartmentController.findDeptEmplList(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/role/findRoleList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.RoleController.findRoleList(int,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/role/findRolePage],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.RoleController.findRolePage(int,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/role/modifyRole],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.RoleController.modifyRole(long,java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/role/deleteRole],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.RoleController.deleteRole(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/role/findRoleById],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.RoleController.findRoleById(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/role/findAllModule],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.RoleController.findAllModule(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/role/setRoleSecureValid],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.RoleController.setRoleSecureValid(long,java.lang.String,int,boolean)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/role/addRole],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.RoleController.addRole(java.lang.String,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findProvinceAll],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.AddressController.findProvinceAll()
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findCityByProvinceId],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.AddressController.findCityByProvinceId(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findCountyByCityId],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.AddressController.findCountyByCityId(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findTownshipByCountyId],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.AddressController.findTownshipByCountyId(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findVillageByTownshipId],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.AddressController.findVillageByTownshipId(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/0/findVerifydCode],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public void com.empl.mgr.controller.support.SupportController.findVerifydCode(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findBreadcrumb],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.SupportController.findBreadcrumb(java.lang.String)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/mdoifyPass],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.SupportController.mdoifyPass(java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findDepartment],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.SupportController.findDepartment()
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findPositionByDeptId],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.SupportController.findPositionByDeptId(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/uploadImg],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public java.util.Map<java.lang.String, java.lang.Object> com.empl.mgr.controller.support.SupportController.uploadImg(org.springframework.web.multipart.MultipartFile,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) throws java.lang.Exception
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/findEmployeesRecord],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.SupportController.findEmployeesRecord(long)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/0/acctLogin],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.SupportController.login(java.lang.String,java.lang.String,java.lang.String,javax.servlet.http.HttpServletRequest)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/exit],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.support.SupportController.exit(javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/departure/findEmployeesInternshipList],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesDepartureController.findEmployeesInternshipList(int,java.lang.String,long,long,int,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/departure/findEmployeesInternshipPage],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesDepartureController.findEmployeesInternshipPage(int,java.lang.String,long,long,int,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/departure/findDepartureNote],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesDepartureController.findDepartureNote(long,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/departure/enrollEmployees],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesDepartureController.enrollEmployees(long,java.lang.String,javax.servlet.http.HttpSession)
[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping]Mapped "{[/employees/departure/destroy],methods=[],params=[],headers=[],consumes=[],produces=[],custom=[]}" onto public com.empl.mgr.support.JSONReturn com.empl.mgr.controller.EmployeesDepartureController.destroy(long,javax.servlet.http.HttpSession)
[org.hibernate.validator.util.Version]Hibernate Validator 4.2.0.Final
[org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver]Detected @ExceptionHandler methods in exceptionIntercept
[root@localhost Desktop]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show global variables like 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout | 28800 |
+---------------+-------+
1 row in set (0.70 sec)
mysql>
mysql> SHOW GLOBAL VARIABLES LIKE 'interactive_timeout'
-> ;
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| interactive_timeout | 28800 |
+---------------------+-------+
1 row in set (0.00 sec)
mysql>
mysql> set global wait_timeout=604800;
Query OK, 0 rows affected (0.05 sec)
mysql>
mysql> set global interactive_timeout=604800;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> COMMIT;
Query OK, 0 rows affected (0.00 sec)
mysql>
[root@localhost ~]# /etc/init.d/mysqld status
mysqld (pid 7732) is running...
[root@localhost ~]# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@localhost ~]# /etc/init.d/mysqld status
mysqld (pid 10469) is running...