In order to solve the problem of http://www.cnblogs.com/zhjh256/p/5807086.html test MARIADB Connector, regular additions and deletions to check no problem.
This shipment was originally intended to solve the stored procedure bug, and the result was not compatible with MySQL JDBC.
In 1.4.6, the CPU immediately soared to 100%, causing the server to die.
Results helpless, look at 1.3.7 version, results prepare grammar check cannot 100% compatible with MySQL JDBC, as follows:
"Pool-1-thread-2" #22 prio=5 os_prio=0 tid=0x00007f6c8c00e800 nid=0x1aeb runnable [0x00007f6cc3ae5000]
Java.lang.Thread.State:RUNNABLE
At Java.util.regex.pattern$bmpcharproperty.match (pattern.java:3797)
At Java.util.regex.pattern$curly.match0 (pattern.java:4250)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$loop.matchinit (pattern.java:4806)
At Java.util.regex.pattern$prolog.match (pattern.java:4741)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$loop.match (pattern.java:4794)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4279)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.match (pattern.java:4785)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$branchconn.match (pattern.java:4568)
At Java.util.regex.pattern$grouptail.match (pattern.java:4717)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4604)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$grouphead.match (pattern.java:4658)
At Java.util.regex.pattern$loop.matchinit (pattern.java:4801)
At Java.util.regex.pattern$prolog.match (pattern.java:4741)
At Java.util.regex.pattern$curly.match0 (pattern.java:4272)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$loop.matchinit (pattern.java:4806)
At Java.util.regex.pattern$prolog.match (pattern.java:4741)
At Java.util.regex.pattern$slicei.match (pattern.java:3997)
At Java.util.regex.pattern$curly.match0 (pattern.java:4279)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$loop.matchinit (pattern.java:4806)
At Java.util.regex.pattern$prolog.match (pattern.java:4741)
At Java.util.regex.pattern$branch.match (pattern.java:4602)
At Java.util.regex.pattern$curly.match0 (pattern.java:4279)
At Java.util.regex.pattern$curly.match (pattern.java:4234)
At Java.util.regex.pattern$begin.match (pattern.java:3525)
At Java.util.regex.Matcher.match (matcher.java:1270)
At Java.util.regex.Matcher.matches (matcher.java:604)
At Org.mariadb.jdbc.MariaDbConnection.prepareCall (mariadbconnection.java:465)
At Org.apache.commons.dbcp.DelegatingConnection.prepareCall (delegatingconnection.java:308)
At Org.apache.commons.dbcp.poolingdatasource$poolguardconnectionwrapper.preparecall (PoolingDataSource.java:303)
At Sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
At Sun.reflect.NativeMethodAccessorImpl.invoke (nativemethodaccessorimpl.java:62)
At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:43)
At Java.lang.reflect.Method.invoke (method.java:497)
At Org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke (connectionlogger.java:61)
At Com.sun.proxy. $Proxy 12.prepareCall (Unknown Source)
At Org.apache.ibatis.executor.statement.CallableStatementHandler.instantiateStatement ( callablestatementhandler.java:77)
At Org.apache.ibatis.executor.statement.BaseStatementHandler.prepare (basestatementhandler.java:85)
At Org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare (routingstatementhandler.java:57)
At Org.apache.ibatis.executor.SimpleExecutor.prepareStatement (simpleexecutor.java:73)
At Org.apache.ibatis.executor.SimpleExecutor.doQuery (simpleexecutor.java:59)
At Org.apache.ibatis.executor.BaseExecutor.queryFromDatabase (baseexecutor.java:267)
At Org.apache.ibatis.executor.BaseExecutor.query (baseexecutor.java:137)
At Org.apache.ibatis.executor.CachingExecutor.query (cachingexecutor.java:96)
At Org.apache.ibatis.executor.CachingExecutor.query (cachingexecutor.java:77)
At Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (defaultsqlsession.java:108)
At Org.apache.ibatis.session.defaults.DefaultSqlSession.selectList (defaultsqlsession.java:102)
At Org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne (defaultsqlsession.java:66)
At Sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
At Sun.reflect.NativeMethodAccessorImpl.invoke (nativemethodaccessorimpl.java:62)
At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:43)
At Java.lang.reflect.Method.invoke (method.java:497)
At Org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke (sqlsessiontemplate.java:358)
At Com.sun.proxy. $Proxy 10.selectOne (Unknown Source)
At Org.mybatis.spring.SqlSessionTemplate.selectOne (sqlsessiontemplate.java:163)
At Org.apache.ibatis.binding.MapperMethod.execute (mappermethod.java:68)
At Org.apache.ibatis.binding.MapperProxy.invoke (mapperproxy.java:52)
At Com.sun.proxy. $Proxy 11.callProcedure (Unknown Source)
At Com.ld.net.task.taskexecutor$1.run (taskexecutor.java:172)
At Java.util.concurrent.ThreadPoolExecutor.runWorker (threadpoolexecutor.java:1142)
At Java.util.concurrent.threadpoolexecutor$worker.run (threadpoolexecutor.java:617)
At Java.lang.Thread.run (thread.java:745)
MARIADB connector Bug