grails - java.lang.NoClassDefFoundError:com/mysql/jdbc/ParameterBindings

Question

服务器运行超过一天后，我看到此错误。服务器启动时没有错误。

org.springframework.jms.listener.adapter.ListenerExecutionFailedException: Listener method 'onMessage' threw exception; nested exception is java.lang.NoClassDefFoundError: com/mysql/jdbc/ParameterBindings
        at grails.plugin.jms.listener.adapter.PersistenceContextAwareListenerAdapter.invokeListenerMethod(PersistenceContextAwareListenerAdapter.groovy:44)
        at grails.plugin.jms.listener.adapter.LoggingListenerAdapter.onMessage(LoggingListenerAdapter.groovy:48)
        at grails.plugin.jms.listener.adapter.PersistenceContextAwareListenerAdapter.onMessage(PersistenceContextAwareListenerAdapter.groovy:33)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: com/mysql/jdbc/ParameterBindings
        at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1450)
        at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4165)
        at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4069)

Answer 1

此问题可能是由于数据库不 Activity 引起的。以下设置可以帮助您长时间保持数据库连接处于 Activity 状态:

timeBetweenEvictionRunsMillis = 5000
minEvictableIdleTimeMillis = 60000
validationQuery = "SELECT 1"
validationQueryTimeout = 3
validationInterval = 15000
testOnBorrow = true
autoReconnect=true
testWhileIdle = true