\u6211\u7ec8\u4e8e\u627e\u5230\u4e86\u51fa\u95ee\u9898\u7684\u7ebf\u7a0b\u4e86\u3002<\/P>
\n
\u901a\u8fc7thread dump \u6211\u53d1\u73b0\u5982\u4e0b\u7ebf\u7a0b\u4e00\u76f4\u5728\u8fd0\u884c\uff1a
“resin-tcp-connection-*:80-6075” daemon prio=1 tid=0x0857aac8 nid=0x7fb0 runnable [0x82dfe000..0x82dff19c]
at org.logicalcobwebs.proxool.FatalSqlExceptionHelper.testException(FatalSqlExceptionHelper.java:116)
at org.logicalcobwebs.proxool.FatalSqlExceptionHelper.testException(FatalSqlExceptionHelper.java:103)
at org.logicalcobwebs.proxool.AbstractProxyStatement.testException(AbstractProxyStatement.java:65)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:146)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Statement$$EnhancerByCGLIB$$1a91e2dc.close()
at com.tag.db.doEndTag(valuetag.java:438)
at _jsp._rst._eng_0aa__jsp._jspService(_products_0viewinfo__jsp.java:75)
at com.caucho.jsp.JavaPage.service(JavaPage.java:60)
at com.caucho.jsp.Page.pageservice(Page.java:570)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:159)
at com.kenfor.exutil.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:152)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
at com.kenfor.exutil.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:152)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:267)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:388)
– locked <0x5c472008> (a java.lang.Object)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)
at com.caucho.util.ThreadPool.run(ThreadPool.java:423)
at java.lang.Thread.run(Thread.java:595)<\/P>
\n
\u7136\u540e\u6211\u53c8\u67e5\u770b\u4e86\u9876\u7ea7\u7684\u4ee3\u7801\u8c03\u7528
at org.logicalcobwebs.proxool.FatalSqlExceptionHelper.testException(FatalSqlExceptionHelper.java:116)
\u4e5f\u5c31\u662ftestException\u8fd9\u4e2a\u65b9\u6cd5\u4e00\u76f4\u5728\u6267\u884c\uff0c\u6211\u4e0d\u6e05\u695a\u4e3a\u4ec0\u4e48\u4e3a\u4f1a\u51fa\u73b0\u5982\u6b64\u6b7b\u5faa\u73af\u3002<\/P>
\n
\u6211\u60f3\u95ee\u95ee\u5927\u5bb6\uff0c\u4ec0\u4e48\u6837\u7684\u4ee3\u7801\u4f1a\u5bfc\u81f4proxool\u7684testException\u4e00\u76f4\u8fd0\u884c\u7740\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u4e0d\u77e5\u9053\u662f\u5206\u6570\u4e0d\u591f\uff0c\u8fd8\u662f\u4eba\u624d\u7a00\u5c11\uff0c\u600e\u4e48\u5c31\u6ca1\u4eba\u56de\u7b54\u5462\u3002\u90c1\u95f7<\/P>
\n
——————————————————————————–<\/P>
\n
\u4e3a\u4ec0\u4e48\u4f1a\u91cd\u590d\u51fa\u73b0\uff1a
at com.kenfor.exutil.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:152)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
at com.kenfor.exutil.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:152)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
\u8c01\u80fd\u544a\u8bc9\u6211\u554a\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u672c\u6765proxool\u662f\u5f88\u6709\u53e3\u7891\u7684\u8fde\u63a5\u6c60 \uff0c\u600e\u4e48\u4f1a\u5bfc\u81f4<\/P>
\n
at org.logicalcobwebs.proxool.FatalSqlExceptionHelper.testException(FatalSqlExceptionHelper.java:116)\u4e2dtestException\u8fd0\u884c\u6ca1\u5b8c\u6ca1\u4e86\u5462\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u52aa\u529b\u63a5\u5206\u5347\u7ea7\u4e2d…\u5e2e\u4f60up!<\/P>
\n
——————————————————————————–<\/P>
\n
filter \u6b7b\u5faa\u73af\u8c03\u7528\uff1f<\/P>
\n
——————————————————————————–<\/P>
\n
\u56de\u590d\uff1aiihero(\u963f\u9ed1\u54e5)<\/P>
\n
\u5e94\u8be5\u4e0d\u662ffilter\u7684\u5f15\u8d77\u7684\uff0c\u5982\u679c\u662ffilter\u7684\u8bdd\uff0c\u90a3\u6240\u6709\u7684\u9875\u9762\u90fd\u4f1a\u5f88\u5bb9\u6613\u8fdb\u5165\u6b7b\u5faa\u73af\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u4e0b\u9762\u5c31\u662f\u8fd9\u4e2a\u6c38\u8fdc\u4e0d\u7ed3\u675f\u7684\u65b9\u6cd5\uff0c\u6211\u770b\u4e86\u4e00\u4e0b\u6e90\u4ee3\u7801\uff0c\u867d\u7136\u6709\u5faa\u73af\u90e8\u5206\uff0c\u4f46\u4e5f\u4e0d\u5bfc\u81f4\u6b7b\u5faa\u73af\uff0c
\u5927\u4f19\u5e2e\u6211\u5206\u6790\u4e00\u4e0b\uff0c\u5177\u4f53\u662f\u4ec0\u4e48\u539f\u56e0\u4f1a\u5bfc\u81f4\u4e0b\u9762\u7684\u4ee3\u7801\u4e00\u76f4\u6267\u884c\uff1f
\/**
* Test to see if an exception is a fatal one
* @param cpd the definition so we can find out what a fatal exception looks like
* @param t the exception to test
* @param level the recursion level (max 20)
* @return true if it is fatal
*\/
protected static boolean testException(ConnectionPoolDefinitionIF cpd, Throwable t, int level) {
boolean fatalSqlExceptionDetected = false;
Iterator i = cpd.getFatalSqlExceptions().iterator();
while (i.hasNext()) {
if (t.getMessage() != null && t.getMessage().indexOf((String) i.next()) > -1) {
\/\/ This SQL exception indicates a fatal problem with this connection.
fatalSqlExceptionDetected = true;
}
}<\/P>
\n
\/\/ If it isn’t fatal, then try testing the contained exception
if (!fatalSqlExceptionDetected && level < 20) {
Throwable cause = getCause(t);
if (cause != null) {
fatalSqlExceptionDetected = testException(cpd, cause, level + 1);
}
}<\/P>
\n
return fatalSqlExceptionDetected;
}<\/P>
\n
——————————————————————————–<\/P>
\n
while (i.hasNext()) {
if (t.getMessage() != null && t.getMessage().indexOf((String) i.next()) > -1) {
\/\/ This SQL exception indicates a fatal problem with this connection.
fatalSqlExceptionDetected = true;
}
}<\/P>
\n
t.getMessage() != null\u8fd9\u53e5\u8bdd\u4e0d\u6210\u7acb\u7684\u8bdd\uff0c\u5c31\u6ca1\u673a\u4f1a\u8c03\u7528i.next\uff08\uff09
\u5c31\u6b7b\u5faa\u73af\u4e86\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u5728\u7f51\u4e0a\u5927\u5bb6\u90fd\u5bf9proxool\u8d5e\u8d4f\u6709\u52a0\uff0c\u4f46\u662f\u6211\u4eec\u7684\u9879\u76ee\u51fa\u73b0\u5982\u6b64\u4e25\u91cd\u7684\u9519\u8bef\uff0c\u5b9e\u5c5e\u4e0d\u5e94\u8be5\uff0c
\u8bf7\u5144\u5f1f\u4eec\u5e2e\u6211\u67e5\u660e\u6b64\u539f\u56e0\uff0c\u4e0d\u8ba9\u6211\u518d\u53bb\u6000\u7591proxool\u7684\u8fc7\u9519\u4e86\uff0c\u628a\u6e05\u767d\u7559proxool\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u56de\u590d:zhmt(\u4e0d\u723d\u4f60\u5c31\u7528\u5206\u7838\u6211\uff01\uff01\uff01) <\/P>
\n
t.getMessage() != null\u4e0d\u6210\u7acb\uff0c\u4e5f\u5e94\u8be5\u4f1a\u518d\u6b21\u8c03\u7528i.hasNext()\u5427<\/P>
\n
——————————————————————————–<\/P>
\n
\u8bf7\u5927\u4f19\u5e2e\u6211\u628a\u94c1\u9876\u8d77\u6765\uff0c\u90fd\u5feb\u4e24\u5929\u4e86\uff0c\u8fd8\u662f\u6ca1\u627e\u5230\u7b54\u6848\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u4f60\u8bf4\u7684\u9519\u4e86\uff0c&& \u8fd0\u7b97\u662f\u4ece\u5de6\u5230\u53f3\uff0c\u5de6\u8fb9\u7684\u4e0d\u6210\u7acb\uff0c\u76f4\u63a5\u5c31\u8fd4\u56defalse\u4e86\uff0c\u4e0d\u518d\u8ba1\u7b97\u53f3\u8fb9\u7684\u3002\u6240\u4ee5\u4e0d\u8c03\u7528i.next\uff08\uff09\u3002<\/P>
\n
\u697c\u4e3b\u8981\u52a0\u5f3a\u57fa\u7840\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u4f60\u53ef\u4ee5\u5199\u4e2a\u5c0f\u4f8b\u5b50\u6d4b\u8bd5\u4e00\u4e0b\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u5f53 t.getMessage() != null\u4e0d\u6210\u7acb\u65f6\uff0c\u662f\u201ct.getMessage().indexOf((String) i.next()) > -1\u201d\u6ca1\u673a\u4f1a\u6267\u884c\u3002\u4e0d\u662fi.hasNext<\/P>
\n
——————————————————————————–<\/P>
\n
\u56de\u590d: zhmt(\u4e0d\u723d\u4f60\u5c31\u7528\u5206\u7838\u6211\uff01\uff01\uff01) <\/P>
\n
\u6211\u8fd8\u662f\u4e0d\u660e\u767d\uff0ct.getMessage() != null\u8fd9\u53e5\u8bdd\u4e0d\u6210\u7acb\u7684\u8bdd\uff0c\u5c31\u4f1a\u5bfc\u81f4\u6b7b\u5faa\u73af\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u5c31\u7b97\u201ct.getMessage().indexOf((String) i.next()) > -1\u4e0d\u77e5\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5bfc\u81f4\u6b7b\u5faa\u73af\u554a\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u6211\u4e0a\u9762\u7684\u90a3\u6bb5\u4ee3\u7801\u662f\u4eceproxool\u4e2d\u53d6\u51fa\u6765\u7684\uff0c\u5982\u679c\u8fd9\u4e48\u5bb9\u6613\u5c31\u6b7b\u5faa\u73af\u4e86\uff0c\u90a3\u6211\u5c31\u8981\u6000\u7591\u8fd9\u4e2a\u4e1c\u897f\u7684\u5b89\u5168\u6027\u5566\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u4f60\u7684\u95ee\u9898\u7684\u80cc\u666f\u662f\u4ec0\u4e48\u554a\uff1f
\u4e0d\u80fd\u5149\u770b\u8fd9\u4e00\u70b9\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
resin-tcp-connection-*:80-6075″ daemon prio=1 tid=0x0857aac8 nid=0x7fb0 runnable <\/P>
\n
\u8fd9\u662f\u4e2a\u5b88\u62a4\u7ebf\u7a0b\uff0c\uff08daemon\uff09\uff0c\u4e00\u76f4\u8fd0\u884c\u7684\u8bdd\uff0c\u662f\u5f88\u6b63\u5e38\u7684\u3002\u53ef\u80fd\u95ee\u9898\u4e0d\u5728\u8fd9\u91cc\uff0c\u4f60\u7684\u662f\u4ec0\u4e48\u6027\u80fd\u95ee\u9898\u554a\uff1f<\/P>
\n
——————————————————————————–<\/P>
\n
\u597d\uff0c\u90a3\u6211\u5c31\u8bf4\u8bf4\u80cc\u666f \uff1a<\/P>
\n
\u6211\u7ef4\u62a4\u7684\u662f\u4e2a\u7f51\u7ad9\u9879\u76ee\uff0c\u7f51\u7ad9\u7ecf\u5e38\u670d\u52a1\u5668cpu 99%,\u5e76\u4e14\u4e0a\u53bb\u4e86\u5c31\u4e0d\u4e0b\u6765\u4e86\uff0c\u5f00\u59cb\u6211\u5c31\u786e\u5b9a\u662f
\u6b7b\u5faa\u73af\u7684\u95ee\u9898\uff0c\u4f46\u662f\u627e\u4e0d\u5230\u6839\u636e\uff0c\u524d\u4e24\u5929\u6211\u7528kill -3 pid,\u6bcf\u96945\u5206\u949fThread Dump\u4e00\u4e0b\uff0c\u53d1\u73b0
\u4e0a\u9762\u7684\u7ebf\u7a0b\u4e00\u76f4\u5728\u865a\u62df\u673a(JVM\uff09\u91cc\u9762\u8fd0\u884c\u8005\u3002\u90a3\u53ea\u6709\u6b7b\u5faa\u73af\u624d\u4e0d\u4f1a\u9000\u51fa\u7684\u3002
\u6211\u4e0d\u77e5\u9053\u6211\u8bb2\u6e05\u695a\u6ca1\uff1f<\/P>
\n
——————————————————————————–<\/P>
\n
daemon\u662f\u5b88\u62a4\u8fdb\u7a0b\uff0c\u4f46\u662f\u4e0d\u5e94\u8be5\u4e0d\u7ed3\u675f\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u4f60\u786e\u4fe1\u662f\u8fd9\u4e2a\u7ebf\u7a0b\u542f\u52a8\u540ecpu\u624d\u5230100\uff05\u7684\u5417\uff1f<\/P>
\n
——————————————————————————–<\/P>
\n
\u662f\u7684\u3002\u5728\u5e73\u65f6\uff0c\u6211\u627e\u4e0d\u5230\u8fd9\u6837\u7684\u7ebf\u7a0b\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u6211\u67e5\u4e86\u4e00\u4e0b\u5b83\u7684\u6e90\u7801\uff0c\u8fd9\u4e2a\u7c7b\u662f\u7528\u6765\u68c0\u67e5\u4e00\u4e2a\u5f02\u5e38\u662f\u5426\u662f\u4e25\u91cd\u5f02\u5e38\uff0c\u5b83\u80fd\u4e00\u76f4\u8fd0\u884c\u8bf4\u660e\u4f60\u7684\u5e94\u7528\u5bfc\u81f4\u4e86\u5f88\u591asql\u5f02\u5e38\u3002\u5982\u679c\u8fd9\u4e2apool\u662f\u7ecf\u8fc7\u5927\u5bb6\u7684\u68c0\u9a8c\u7684\u8bdd\uff0c\u53ef\u80fd\u4f60\u7684\u5e94\u7528\u4e2d\uff0c\u54ea\u4e00\u90e8\u5206\u7684sql\u8c03\u7528\u5f88\u6709\u95ee\u9898\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u662f\u7684\uff0c\u4f46\u662f\u5f88\u591a\u5f02\u5e38\u4e5f\u4f1a\u6709\u4e2a\u6570\u91cf\u9650\u5236\u554a\uff0c\u53ef\u80fd\u5904\u7406\u6821\u9a8c\u7684\u901f\u5ea6\u6162\u554a\uff0c\u800c\u4e0d\u4f1a\u51fa\u73b0\uff0c\u6b7b\u5faa\u73af\u554a\u3002
\u5728\u9875\u9762\u4e0a\u4f20\u5165\u7684sql\u8bed\u53e5\u96be\u514d\u6709\u4e9b\u95ee\u9898\uff0c\u6211\u6d4b\u8bd5\u8fc7\uff0c\u4e00\u822c\u60c5\u51b5\u4e0b\uff0c\u7cfb\u7edf\u4f1a\u81ea\u52a8\u5904\u7406\u7684\uff0c\u4f46\u662f\u6211\u60f3\u5728\u5c31\u4e0d\u660e\u767d\uff0c\u4ec0\u4e48\u60c5\u51b5\u4e0b\uff0c\u4ec0\u4e48\u6837\u7684SQL\u8bed\u53e5\u4f1a\u5bfc\u81f4\u6b7b\u5faa\u73af\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u4f60\u770b\u4e86\u6709\u591a\u5c11\u4e2a\u8fd9\u6837\u7ebf\u7a0b\u4e86\u5417\uff1f
\u53ef\u80fd\u4e0d\u662f\u6b7b\u5faa\u73af\uff0c\u800c\u662f\u7ebf\u7a0b\u7ed3\u675f\u540e\u53c8\u88ab\u542f\u52a8\u8d77\u6765\u3002\u6216\u8005\u662f\u542f\u52a8\u4e86\u591a\u4e2a\u8fd9\u6837\u7684\u7ebf\u7a0b\u3002
\u5982\u679c\u4e0d\u662f\u6211\u611f\u624d\u8bf4\u7684\u90a3\u4e2a\u6b7b\u5faa\u73af\u7684\uff0c\u5c31\u4e0d\u53ef\u80fd\u51fa\u73b0\u6b7b\u5faa\u73af\u4e86\uff08next\u548chasNext\u8981\u6210\u5bf9\u4f7f\u7528\u624d\u4e0d\u4f1a\u6b7b\u5728\u90a3\uff0c\u5982\u679c\u53ea\u4f7f\u7528hasNext\u800c\u4e0d\u4f7f\u7528next\uff0c\u90a3\u4e48iterator\u662f\u4e0d\u5f80\u4e0b\u8d70\u7684\uff0c\u5c31\u4f1a\u6b7b\u4e86\u3002\uff09\u3002
\u53e6\u5916\u5b83\u7684\u9012\u5f52\u8c03\u7528\u4e5f\u4e0d\u4f1a\u8d85\u8fc720\u5c42\uff0c\u6240\u4ee5\u4e5f\u4e0d\u4f1a\u6b7b\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u6211\u89c9\u5f97\u4ece\u81ea\u5df1\u7684\u5e94\u7528\u4e0a\u6765\u6539\u8fdb\u5e94\u8be5\u66f4\u597d\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u56de\u590d\uff1azhmt(\u4e0d\u723d\u4f60\u5c31\u7528\u5206\u7838\u6211\uff01\uff01\uff01) <\/P>
\n
\u4f60\u8bf4\u7684\u6709\u9053\u7406\uff0c\u5982\u679c t.getMessage() ==null\u7684\u8bdd\uff0c\u5c31\u4f1a\u9677\u5165\u6b7b\u5faa\u73af\u3002<\/P>
\n
\u4f46\u662f\u6211\u770b\u6211\u4eec\u7684\u4ee3\u7801\u90fd\u662f\u6309\u7167JDBC\u89c4\u8303\u6765\u5199\u7684\u554a\u3002<\/P>
\n
\u4e0b\u9762\u6211\u8d34\u4e9b\u539f\u7801\uff0c\u5e2e\u6211\u770b\u770b\u6709\u4ec0\u4e48\u95ee\u9898\u3002<\/P>
\n
<\/P>
\n
——————————————————————————–<\/P>
\n
public HashMap getdbValue(PoolBean pool) throws Exception
{
if(pool.getLog().isDebugEnabled())
pool.getLog().debug(“star getdbValue”);<\/P>
\n
String system_name = pool.getDatabaseInfo().getSystemName();
HashMap result = null;
String temp_sql = createSql();
if(temp_sql == null)
throw new SQLException(“not sql statement”);<\/P>
\n
Statement stmt = null;
ResultSet rs = null;
Connection con = null;
try
{
con = pool.getNoInfoConnection();\/\/ .getConnection();
con.setReadOnly(true);
stmt = con.createStatement();
rs = stmt.executeQuery(temp_sql);
\/\/ rs = stmt.executeQuery(sql);
if (rs != null) {
ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
if (rs.next()) {
result = new HashMap();
for (int i = 1; i <= colCount; i++) {
String name = rsmd.getColumnName(i);
name = name.toLowerCase();
String type_name = rsmd.getColumnTypeName(i).toLowerCase();
\/\/ System.out.println(“field name : ” + name + ” , type_anme : ” + type_name);
if (“text”.equals(type_name)) {
\/\/\u5f53\u5b57\u6bb5\u7c7b\u578b\u4e3atext\u65f6\uff0c\u5982\u679c\u76f4\u63a5\u7528rs.getObject(i)\u53d6\u6570\u636e\uff0c\u5728jtds1.0\u7248\u672c\u4e2d\u4e0d\u80fd\u76f4\u63a5\u53d6\u51fa\uff0c\u6539\u4e3a\u4ee5\u4e0b\u65b9\u5f0f\u5373\u53ef 2005-07-22 \u5f20\u8d35\u5e73
String tt_str = rs.getString(i);
\/\/ System.out.println(“text — “+tt_str);
if (tt_str == null)
tt_str = “”;
else
tt_str = tt_str.trim();
result.put(name.trim(), tt_str);
}
else {
Object obj_value = rs.getObject(i);
if (obj_value instanceof java.lang.String) {
String t_str = null;
if (obj_value == null)
t_str = “”;
else
t_str = String.valueOf(obj_value).trim();
result.put(name.trim(), t_str);
}
else {
result.put(name.trim(), obj_value);
}
}
}
}
rsmd = null;
}
rs.close();
stmt.close();
con.setReadOnly(false);
con.close();
}
catch(SQLException e)
{
\/\/CloseCon.Close(con);
pool.getLog().error(system_name+”,”+e.getMessage()+”,sql:”+temp_sql);
throw new SQLException(“database perform error : ” + e.getMessage());
}
finally
{
CloseCon.Close(con);
}<\/P>
\n
return result;<\/P>
\n
}<\/P>
\n
\u4ece\u7ebf\u7a0b\u5806\u6808\u4e0a\u770b$java.sql.Statement$$EnhancerByCGLIB$$1a91e2dc.close()
\uff0c\u662f\u4ecestmt.close()\u8fdb\u53bb\u7684\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u89c9\u5f97\u4e0d\u89c4\u8303
rs.close();
stmt.close();
con.setReadOnly(false);
con.close();<\/P>
\n
\u4ee5\u4e0a\u8fd9\u4e9b\u4e1c\u897f\u90fd\u8981\u653e\u5728finnally\u5757\u4e2d\u7684\u3002<\/P>
\n
\u6211\u6ca1\u7528\u8fc7PoolBean\uff0c\u4e0d\u77e5\u9053\u600e\u4e48\u7528\uff0c\u89c9\u5f97\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u597d\u50cf\u6ca1\u591a\u5927\u95ee\u9898\u3002\u4f60\u5012\u7f51\u4e0a\u641c\u7d22\u8d44\u6599\u770b\u770b\u5427\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u4f60\u770b\u4e0bFilter\u91cc\u9762\u7684\u8df3\u8f6c\u662f\u4e0d\u662f\u9519\u4e86\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u56de\u590d\uff1azhmt(\u4e0d\u723d\u4f60\u5c31\u7528\u5206\u7838\u6211\uff01\uff01\uff01) <\/P>
\n
PoolBean \u662f\u6211\u4eec\u81ea\u5df1\u5199\u7684\u4e00\u4e2a\u7c7b\uff0c\u4e3b\u8981\u662f\u505a\u8ddf\u8fde\u63a5\u6c60\u7684\u8854\u63a5\u5de5\u4f5c\u3002<\/P>
\n
\u662f\u7684\uff0c\u4e0d\u662f\u5f88\u89c4\u8303\uff0c\u4f46\u662f\u8fd9\u6837\u4e5f\u5e94\u8be5\u4e0d\u4f1a\u5bfc\u81f4proxool\u6b7b\u5faa\u73af\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u6211\u4eec\u81ea\u5df1\u7684Filter\u7c7b\uff0c\u770b\u770b\u6709\u4ec0\u4e48\u95ee\u9898\u3002<\/P>
\n
public class SetCharacterEncodingFilter implements Filter {<\/P>
\n
Log log = LogFactory.getLog(this.getClass().getName());<\/P>
\n
\/\/ —————————————————– Instance Variables<\/P>
\n
\/**
* The default character encoding to set for requests that pass through
* this filter.
*\/
protected String encoding = null;<\/P>
\n
\/**
* The filter configuration object we are associated with. If this value
* is null, this filter instance is not currently configured.
*\/
protected FilterConfig filterConfig = null;<\/P>
\n
\/**
* \u4e0a\u4f20\u6587\u4ef6\u7684\u6700\u5927\u5927\u5c0f
*\/
protected int fileMaxLength = 200*1024; \/\/200K<\/P>
\n
\/**
* Should a character encoding specified by the client be ignored?
*\/
protected boolean ignore = true;<\/P>
\n
\/**
* Take this filter out of service.
*\/
public void destroy() {<\/P>
\n
this.encoding = null;
this.filterConfig = null;<\/P>
\n
}<\/P>
\n
\/**
* Select and set (if specified) the character encoding to be used to
* interpret request parameters for this request.
*
* @param request The servlet request we are processing
* @param result The servlet response we are creating
* @param chain The filter chain we are processing
*
* @exception IOException if an input\/output error occurs
* @exception ServletException if a servlet error occurs
*\/
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain)
throws IOException, ServletException {<\/P>
\n
\/\/ Conditionally select and set the character encoding to be used<\/P>
\n
HttpServletRequest t_re = (HttpServletRequest) request;<\/P>
\n
String re_uri = trimString(t_re.getRequestURI());
String re_host = trimString(t_re.getServerName());
String qu_str = trimString(t_re.getQueryString());<\/P>
\n
if (re_uri.indexOf(“.do”) > 0)
{
if (log.isInfoEnabled())
log.info(re_host + re_uri + “?” + qu_str);<\/P>
\n
try
{<\/P>
\n
if (ignore || (request.getCharacterEncoding() == null)) {
String encoding = selectEncoding(request);
if (encoding != null)
request.setCharacterEncoding(encoding);
}
\/\/ Pass control on to the next filter
chain.doFilter(request, response);
}
catch(Exception e)
{
\/\/ e.printStackTrace();
String error_mes = e.getMessage();
String strServerName = null;
String strQueryString = null;
String requestUrl = null;
String remoteAddr = null;
String referer = “”;
if(error_mes.indexOf(“reset”)<0 )
{
try {
strServerName = t_re.getServerName();
strQueryString = t_re.getQueryString();
requestUrl = t_re.getRequestURI();
\/\/ strQueryString = CodeTransfer.ISOToUnicode(strQueryString);
referer = t_re.getHeader(“referer”);
remoteAddr = t_re.getRemoteAddr();
}
catch (Exception e1) {}
if (error_mes != null && !”null”.equals(error_mes)&& error_mes.length() > 0) {
log.error(“,exception:” +
error_mes + strServerName + ” , ” + strQueryString + ” , ” +
requestUrl + ” , ” + referer);
\/\/ System.out.println(“exception at filter:” +
\/\/ error_mes);
}<\/P>
\n
}
if(log.isInfoEnabled())
log.info(strServerName + ” , ” + strQueryString+ ” , ” + requestUrl + ” , ” + referer);
}<\/P>
\n
}<\/P>
\n
\/**
* Place this filter into service.
*
* @param filterConfig The filter configuration object
*\/
public void init(FilterConfig filterConfig) throws ServletException {<\/P>
\n
this.filterConfig = filterConfig;
this.encoding = filterConfig.getInitParameter(“encoding”);
String value = filterConfig.getInitParameter(“ignore”);
String file_max_length = filterConfig.getInitParameter(“file_max_length”);
if(file_max_length!=null && file_max_length.length() >0)
{
fileMaxLength = com.kenfor.util.MyUtil.getStringToInt(file_max_length,200)*1024;
}<\/P>
\n
if (value == null)
this.ignore = true;
else if (value.equalsIgnoreCase(“true”))
this.ignore = true;
else if (value.equalsIgnoreCase(“yes”))
this.ignore = true;
else
this.ignore = false;<\/P>
\n
}<\/P>
\n
\/**
* Select an appropriate character encoding to be used, based on the
* characteristics of the current request and\/or filter initialization
* parameters. If no character encoding should be set, return
* null.
* <\/P>
\n
* The default implementation unconditionally returns the value configured
* by the encoding initialization parameter for this
* filter.
*
* @param request The servlet request we are processing
*\/
protected String selectEncoding(ServletRequest request) {<\/P>
\n
return (this.encoding);<\/P>
\n
}
private String trimString(String value)
{
String result = “”;
if(value !=null)
result = value.trim();<\/P>
\n
return result;
}<\/P>
\n
}<\/P>
\n
<\/P>
\n
<\/P>
\n
——————————————————————————–<\/P>
\n
\u5982\u679c\u771f\u7684\u662fproxool\uff0c\u90a3\u6211\u5e94\u8be5\u611f\u5230\u6b23\u6170\uff0c\u5982\u679c\u662f\u6211\u4eec\u5199\u7684\u4ee3\u7801\u4e0d\u5f53\u5f15\u8d77\u7684\uff0c\u4f46\u6211\u5c31\u771f\u7684\u65e0\u5730\u4e4b\u5bb9\u4e86\u3002<\/P>
\n
——————————————————————————–<\/P>
\n
\u5475\u5475\uff0c\u8fd9\u4e2a\u6211\u4e5f\u641e\u4e0d\u6e05\u695a\uff0c\u697c\u4e3b\u6700\u597d\u628a\u4f60\u4eec\u7684\u90a3\u4e2apoolBean\u81ea\u5df1\u6d4b\u8bd5\u4e00\u4e0b\u3002
\u80fd\u627e\u5230\u90a3\u79cd\u60c5\u51b5\u4e0b\u51fa\u90a3\u4e2a\u9519\u8bef\u662f\u6700\u597d\u7684\u3002<\/P>
\n
\u770b\u770b\u5faa\u73af\u4f7f\u7528\u7684\u65f6\u5019\u662f\u5426\u4e5f\u629b\u51fa\u8fd9\u4e2a\u5f02\u5e38\uff0c\u5982\u679c\u8fd9\u6837\u7684\u8bdd\u5c31\u67e5\u67e5\u54ea\u7684\u95ee\u9898\u5427\u3002\u5982\u679c\u4e0d\u51fa\u9519\uff0c\u53ef\u80fd\u5c31\u662fsql\u5199\u7684\u6709\u95ee\u9898\u4e86\u3002<\/P>
\n
\u6211\u7ec8\u4e8e\u627e\u5230\u4e86\u51fa\u95ee\u9898\u7684\u7ebf\u7a0b\u4e86\u3002 \u901a\u8fc7thread dump \u6211\u53d1\u73b0\u5982\u4e0b\u7ebf\u7a0b\u4e00\u76f4\u5728\u8fd0\u884c\uff1a“resin-tcp-connection-*:80-6075” daemon prio=1 tid=0x0857aac8 nid=0x7fb0 runnable [0x82dfe000..0x82dff19c]at org.logicalcobwebs.proxool.FatalSqlExceptionHelper.testException(FatalSqlExceptionHelper.java:116)at org.logicalcobwebs.proxool.FatalSqlExceptionHelper.testException(FatalSqlExceptionHelper.java:103)at org.logicalcobwebs.proxool.AbstractProxyStatement.testException(AbstractProxyStatement.java:65)at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:146)at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)at $java.sql.Statement$$EnhancerByCGLIB$$1a91e2dc.close()at com.tag.db.doEndTag(valuetag.java:438)at _jsp._rst._eng_0aa__jsp._jspService(_products_0viewinfo__jsp.java:75)at com.caucho.jsp.JavaPage.service(JavaPage.java:60)at com.caucho.jsp.Page.pageservice(Page.java:570)at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:159)at com.kenfor.exutil.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:152)at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)at com.kenfor.exutil.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:152)at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178)at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:267)at com.caucho.server.port.TcpConnection.run(TcpConnection.java:388)– locked <0x5c472008> (a java.lang.Object)at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)at com.caucho.util.ThreadPool.run(ThreadPool.java:423)at java.lang.Thread.run(Thread.java:595) \u7136\u540e\u6211\u53c8\u67e5\u770b\u4e86\u9876\u7ea7\u7684\u4ee3\u7801\u8c03\u7528at org.logicalcobwebs.proxool.FatalSqlExceptionHelper.testException(FatalSqlExceptionHelper.java:116)\u4e5f\u5c31\u662ftestException\u8fd9\u4e2a\u65b9\u6cd5\u4e00\u76f4\u5728\u6267\u884c\uff0c\u6211\u4e0d\u6e05\u695a\u4e3a\u4ec0\u4e48\u4e3a\u4f1a\u51fa\u73b0\u5982\u6b64\u6b7b\u5faa\u73af\u3002 \u6211\u60f3\u95ee\u95ee\u5927\u5bb6\uff0c\u4ec0\u4e48\u6837\u7684\u4ee3\u7801\u4f1a\u5bfc\u81f4proxool\u7684testException\u4e00\u76f4\u8fd0\u884c\u7740\u3002 ——————————————————————————– \u4e0d\u77e5\u9053\u662f\u5206\u6570\u4e0d\u591f\uff0c\u8fd8\u662f\u4eba\u624d\u7a00\u5c11\uff0c\u600e\u4e48\u5c31\u6ca1\u4eba\u56de\u7b54\u5462\u3002\u90c1\u95f7 ——————————————————————————– \u4e3a\u4ec0\u4e48\u4f1a\u91cd\u590d\u51fa\u73b0\uff1aat com.kenfor.exutil.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:152)at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)at com.kenfor.exutil.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:152)at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)\u8c01\u80fd\u544a\u8bc9\u6211\u554a\u3002 ——————————————————————————– \u672c\u6765proxool\u662f\u5f88\u6709\u53e3\u7891\u7684\u8fde\u63a5\u6c60 \uff0c\u600e\u4e48\u4f1a\u5bfc\u81f4 at org.logicalcobwebs.proxool.FatalSqlExceptionHelper.testException(FatalSqlExceptionHelper.java:116)\u4e2dtestException\u8fd0\u884c\u6ca1\u5b8c\u6ca1\u4e86\u5462\u3002 ——————————————————————————– \u52aa\u529b\u63a5\u5206\u5347\u7ea7\u4e2d…\u5e2e\u4f60up! ——————————————————————————– … Continue reading proxool.FatalSqlExceptionHelper.testException()<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[103],"class_list":["post-488","post","type-post","status-publish","format-standard","hentry","category-java","tag-proxool"],"_links":{"self":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=488"}],"version-history":[{"count":1,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/488\/revisions"}],"predecessor-version":[{"id":881,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/488\/revisions\/881"}],"wp:attachment":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}