启动应用的时候会卡在:
08:22:58,221 DEBUG IntegratorServiceImpl:46 - Adding Integrator [org.hibernate.cfg.beanvalidation.BeanValidationIntegrator].
08:22:58,226 DEBUG IntegratorServiceImpl:46 - Adding Integrator [org.hibernate.secure.spi.JaccIntegrator].
08:22:58,229 DEBUG IntegratorServiceImpl:46 - Adding Integrator [org.hibernate.cache.internal.CollectionCacheInvalidator].
08:22:58,320 INFO Version:37 - HHH000412: Hibernate Core {5.0.7.Final}
08:22:58,322 INFO Environment:213 - HHH000206: hibernate.properties not found
08:22:58,324 INFO Environment:317 - HHH000021: Bytecode provider name : javassist
08:22:58,353 DEBUG LocalXmlResourceResolver:57 - Interpreting public/system identifier : [-//Hibernate/Hibernate Configuration DTD 3.0//EN] - [http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd]
08:22:58,353 DEBUG LocalXmlResourceResolver:85 - Recognized hibernate-configuration identifier; attempting to resolve on classpath under org/hibernate/
08:22:58,357 DEBUG JaxbCfgProcessor:116 - cfg.xml document did not define namespaces; wrapping in custom event reader to introduce namespace information
08:22:58,511 DEBUG Configuration:722 - Building session factory using internal StandardServiceRegistryBuilder
08:22:58,519 DEBUG ServiceBinding:68 - Overriding existing service binding [org.hibernate.secure.spi.JaccService]
08:22:58,519 DEBUG Configuration:653 - Building session factory using provided StandardServiceRegistry
08:22:58,538 DEBUG RegionFactoryInitiator:88 - Cache region factory : org.hibernate.cache.internal.NoCachingRegionFactory
08:22:58,546 INFO Version:66 - HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
08:22:58,632 INFO ConnectionProviderInitiator:187 - HHH000130: Instantiating explicit connection provider: org.hibernate.connection.C3P0ConnectionProvider
08:22:58,637 INFO C3P0ConnectionProvider:117 - HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql:///exam
08:22:58,638 INFO C3P0ConnectionProvider:118 - HHH10001001: Connection properties: {user=root, password=****, autocommit=false}
08:22:58,638 INFO C3P0ConnectionProvider:121 - HHH10001003: Autocommit mode: false
08:22:58,934 INFO C3P0ConnectionProvider:201 - HHH10001007: JDBC isolation level: <unknown>
随后抛出如下异常:
08:23:29,343 WARN BasicResourcePool:1851 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@12bfebe -- 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 (30). Last acquisition attempt exception:
java.sql.SQLException
: Unknown system variable 'language'
at com.mysql.jdbc.SQLError.createSQLException(
SQLError.java:963
)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
MysqlIO.java:3966
)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
MysqlIO.java:3902
)
at com.mysql.jdbc.MysqlIO.sendCommand(
MysqlIO.java:2526
)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
MysqlIO.java:2673
)
at com.mysql.jdbc.ConnectionImpl.execSQL(
ConnectionImpl.java:2545
)
at com.mysql.jdbc.ConnectionImpl.execSQL(
ConnectionImpl.java:2503
)
at com.mysql.jdbc.StatementImpl.executeQuery(
StatementImpl.java:1369
)
at com.mysql.jdbc.ConnectionImpl.loadServerVariables(
ConnectionImpl.java:3833
)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(
ConnectionImpl.java:3283
)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(
ConnectionImpl.java:2297
)
at com.mysql.jdbc.ConnectionImpl.createNewIO(
ConnectionImpl.java:2083
)
at com.mysql.jdbc.ConnectionImpl.<init>(
ConnectionImpl.java:806
)
at com.mysql.jdbc.JDBC4Connection.<init>(
JDBC4Connection.java:47
)
at sun.reflect.GeneratedConstructorAccessor10.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(
Util.java:404
)
at com.mysql.jdbc.ConnectionImpl.getInstance(
ConnectionImpl.java:410
)
at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:328
)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(
DriverManagerDataSource.java:146
)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(
WrapperConnectionPoolDataSource.java:195
)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(
WrapperConnectionPoolDataSource.java:184
)
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:1810
)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(
ThreadPoolAsynchronousRunner.java:635
)
08:23:29,346 WARN BasicResourcePool:1851 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@125ba1c -- 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 (30). Last acquisition attempt exception:
java.sql.SQLException
: Unknown system variable 'language'
at com.mysql.jdbc.SQLError.createSQLException(
SQLError.java:963
)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
MysqlIO.java:3966
)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
MysqlIO.java:3902
)
at com.mysql.jdbc.MysqlIO.sendCommand(
MysqlIO.java:2526
)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
MysqlIO.java:2673
)
at com.mysql.jdbc.ConnectionImpl.execSQL(
ConnectionImpl.java:2545
)
at com.mysql.jdbc.ConnectionImpl.execSQL(
ConnectionImpl.java:2503
)
at com.mysql.jdbc.StatementImpl.executeQuery(
StatementImpl.java:1369
)
at com.mysql.jdbc.ConnectionImpl.loadServerVariables(
ConnectionImpl.java:3833
)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(
ConnectionImpl.java:3283
)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(
ConnectionImpl.java:2297
)
at com.mysql.jdbc.ConnectionImpl.createNewIO(
ConnectionImpl.java:2083
)
at com.mysql.jdbc.ConnectionImpl.<init>(
ConnectionImpl.java:806
)
at com.mysql.jdbc.JDBC4Connection.<init>(
JDBC4Connection.java:47
)
at sun.reflect.GeneratedConstructorAccessor10.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(
Util.java:404
)
at com.mysql.jdbc.ConnectionImpl.getInstance(
ConnectionImpl.java:410
)
at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:328
)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(
DriverManagerDataSource.java:146
)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(
WrapperConnectionPoolDataSource.java:195
)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(
WrapperConnectionPoolDataSource.java:184
)
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:1810
)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(
ThreadPoolAsynchronousRunner.java:635
)
08:23:29,343 WARN BasicResourcePool:1851 - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1d7070d -- 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 (30). Last acquisition attempt exception:
解决办法:此问题为MySql驱动版本与mysql版本不兼容导致,换一个较低版本的驱动即可解决。例如:换成mysql-connector-java-5.1.6.jar
转载于:https://www.cnblogs.com/ilovezihan/p/7323275.html
启动应用的时候会卡在:08:22:58,221 DEBUG IntegratorServiceImpl:46 - Adding Integrator [org.hibernate.cfg.beanvalidation.BeanValidationIntegrator].08:22:58,226 DEBUG IntegratorServiceImpl:46 - Adding Integrat...
1.出现这类
异常
,通常是jdbc版本与my
sql
版本不匹配,处理得方法:换jdbc版本
Exception in thread “main”
java
.
sql
.
SQLException
:
Unknown
system
variable
‘
lan
guage
’
at com.my
sql
.jdbc.
SQL
Error.create
SQLException
(
SQL
Error.
java
:998)
at com...
二:用的My
sql
的版本 5.6 用的连接 jar my
sql
-connector-
java
-5.1.36.jar
三:找到问题,my
sql
-connector-
java
-5.1.36.jar 版本太高了,换成
my
sql
-connector
报错
问题如下:
java
.
sql
.
SQLException
:
Unknown
system
variable
'
lan
guage
'
at com.my
sql
.jdbc.
SQL
Error.create
SQLException
(
SQL
Error.
java
:965) ~[my
sql
-connector-
java
-5.1.46.jar:5.1.46]
at com.my
sql
.jdbc.My
sql
IO....
今天在centos上用yum安装了my
sql
,然后就直接使用了,在项目启动过程中,看tomcat日志报了如题的错误
java
.
sql
.
SQLException
:
Unknown
system
variable
'
lan
guage
'
原来是因为my
sql
版本和jdbc driver版本不一致导致的。
我yum安装的是5.0版本的,而我jdbc driver版本是5.1的导致了以上错误。
java
.
sql
.
SQLException
:
Unknown
system
variable
'
lan
guage
'
at com.my
sql
.jdbc.
SQL
Error.create
SQLException
(
SQL
Error.
java
:964) ~[my
sql
-connector-
java
-5.1.40.jar:5.1.40]
at com.my
sql
.jdbc.My
sql
IO.checkE...