Tomcat：会话持久性不与MySQL一起使用

我正在使用MySQL在Tomcat中添加会话持久性，但不幸的是，它不工作。数据库中没有什么我试图保存会话信息，以便用户即使在tomcat重新启动后也能login。这是我有的configuration：

表格：

create database tomcat; create table tomcat$sessions ( id varchar(100) not null primary key, valid char(1) not null, maxinactive int not null, lastaccess bigint, data mediumblob );

context.xml：

 <Manager className="org.apache.catalina.session.PersistentManager" debug="3" saveOnRestart="true" maxActiveSessions="-1" minIdleSwap="-1" maxIdleSwap="-1" maxIdleBackup="-1"> <Store className="org.apache.catalina.session.JDBCStore" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://localhost/tomcat?user=USERNAME&amp;password=PASSWORD&amp;useSSL=false" sessionTable="tomcat$sessions" sessionIdCol="id" sessionDataCol="data" sessionValidCol="valid" sessionMaxInactiveCol="maxinactive" sessionLastAccessedCol="lastaccess" checkInterval="60" debug="99" /> </Manager>

logging.properties：

 # To see debug messages in TldLocationsCache, uncomment the following line: #org.apache.jasper.compiler.TldLocationsCache.level = FINE org.apache.catalina.session.PersistentManager.level = ALL org.apache.catalina.session.PersistentManager.useParentHandlers = true org.apache.catalina.session.level = ALL org.apache.catalina.session.useParentHandlers = true

catalina.out：

 Feb 17, 2017 2:24:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: Start expire sessions PersistentManager at 1487337861731 sessioncount 1 Feb 17, 2017 2:24:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: End expire sessions PersistentManager processingTime 16 expired sessions: 0 Feb 17, 2017 2:25:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: Start expire sessions PersistentManager at 1487337921759 sessioncount 1 Feb 17, 2017 2:25:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: End expire sessions PersistentManager processingTime 13 expired sessions: 0 Feb 17, 2017 2:26:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: Start expire sessions PersistentManager at 1487337981776 sessioncount 1 Feb 17, 2017 2:26:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: End expire sessions PersistentManager processingTime 9 expired sessions: 0 Feb 17, 2017 2:27:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: Start expire sessions PersistentManager at 1487338041789 sessioncount 1 Feb 17, 2017 2:27:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: End expire sessions PersistentManager processingTime 16 expired sessions: 0 Feb 17, 2017 2:28:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: Start expire sessions PersistentManager at 1487338101809 sessioncount 1 Feb 17, 2017 2:28:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: End expire sessions PersistentManager processingTime 15 expired sessions: 0 Feb 17, 2017 2:29:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: Start expire sessions PersistentManager at 1487338161833 sessioncount 1 Feb 17, 2017 2:29:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: End expire sessions PersistentManager processingTime 15 expired sessions: 0 Feb 17, 2017 2:30:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: Start expire sessions PersistentManager at 1487338221852 sessioncount 1 Feb 17, 2017 2:30:21 PM org.apache.catalina.session.PersistentManagerBase processExpires FINE: End expire sessions PersistentManager processingTime 14 expired sessions: 0 Feb 17, 2017 2:30:34 PM org.apache.catalina.core.StandardServer await INFO: A valid shutdown command was received via the shutdown port. Stopping the Server instance.

catalina.sh：

 CATALINA_OPTS="$CATALINA_OPTS -server -Xms3g -XX:+UseParallelGC -XX:ParallelGCThreads=2 -Dspring.security.strategy=MODE_INHERITABLETHREADLOCAL -Dorg.apache.catalina.session.StandardSession.ACTIVITY_CHECK=true"