ssm框架中1. mysql无法连接的错误 2.访问jsp时 HTTP ERROR 500 PWC6033 3.maven报错：不再支持源选项 5。请使用 6 或更高版本

 

• mysql 驱动 修改maven中预设的版本，Project Structure->Dependencies额外导入驱动不管用
  • 导致无法连接的错误
• 修改连接密码

• p:url="jdbc:mysql://127.0.0.1:3306/sampledb?useSSL=FALSE&serverTimezone=UTC"

  •  

                     不添加useSSL=FALSE

** BEGIN NESTED EXCEPTION ** 
javax.net.ssl.SSLException
MESSAGE: closing inbound before receiving peer's close_notify

STACKTRACE:

javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:129)
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:117)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:308)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:264)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:255)
	at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:645)
	at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:624)
	at com.mysql.cj.protocol.a.NativeProtocol.quit(NativeProtocol.java:1312)
	at com.mysql.cj.NativeSession.quit(NativeSession.java:182)
	at com.mysql.cj.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:1750)
	at com.mysql.cj.jdbc.ConnectionImpl.close(ConnectionImpl.java:720)
	at org.apache.commons.dbcp.DelegatingConnection.close(DelegatingConnection.java:247)
	at org.apache.commons.dbcp.PoolableConnection.reallyClose(PoolableConnection.java:122)
	at org.apache.commons.dbcp.PoolableConnectionFactory.destroyObject(PoolableConnectionFactory.java:628)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1562)

......

** END NESTED EXCEPTION **

• 不添加 serverTimezone=UTC

警告: Caught exception while allowing TestExecutionListener [org.springframework.test.context.transaction.TransactionalTestExecutionListener@58ea606c] to process 'before' execution of test method [public void com.smart.service.UserServiceTest.testAddLoginLog()] for test instance [com.smart.service.UserServiceTest@62230c58]
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:245)
	。。
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
。。
Caused by: java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
。。
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
。。

• &  ->  &    在xml的中需要将 & 写成&

严重: Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTestExecutionListener@1dac5ef] to prepare test instance [com.smart.service.UserServiceTest@c333c60]
java.lang.IllegalStateException: Failed to load ApplicationContext

jetty插件配置

•              <plugin>
                  <groupId>org.eclipse.jetty</groupId>
                  <artifactId>jetty-maven-plugin</artifactId>
                  <version>9.4.11.v20180605</version>
                  <configuration>
                      <httpConnector>
                          <port>8000</port>
                          <host>localhost</host>
                      </httpConnector>
                      <scanIntervalSeconds>1</scanIntervalSeconds>
                  </configuration>
              </plugin>

  jetty版本过低导致的错误   访问jsp页面时

  • HTTP ERROR 500
    Problem accessing /test/. Reason:
    
        PWC6033: Unable to compile class for JSP
    
    PWC6199: Generated servlet error:
    The type java.io.ObjectInputStream cannot be resolved. It is indirectly referenced from required .class files
    
    PWC6199: Generated servlet error:
    java.util.Vector cannot be resolved to a type
    
    PWC6199: Generated servlet error:
    Vector cannot be resolved to a type
    
    Caused by:
    org.apache.jasper.JasperException: PWC6033: Unable to compile class for JSP
    ....

     

• maven报错：不再支持源选项 5。请使用 6 或更高版本。

  pom.xml文件中增加maven编译的jdk版本设置，maven.compiler.source和maven.compiler.target，另外java.version最好也加上
  
       <properties>
          <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
          <maven.compiler.encoding>UTF-8</maven.compiler.encoding>
          <java.version>1.8</java.version>
          <maven.compiler.source>1.8</maven.compiler.source>
          <maven.compiler.target>1.8</maven.compiler.target>
      </properties> 
  

  
  错误具体信息：https://blog.csdn.net/moshowgame/article/details/81369327 

•