添加链接
link之家
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接
相关文章推荐
绅士的书包  ·  女主渣撩修罗场np - 百度·  2 月前    · 
淡定的核桃  ·  Genetic testing - ...·  3 月前    · 
激动的莲藕  ·  平水韵如何使用? - 知乎·  1 年前    · 
宽容的大白菜  ·  南方周末·  1 年前    · 

启动应用的时候会卡在:

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...