Linux下配置java、tomcat、mysql环境

1.到sun官网下载jdk:jdk-6u22-linux-i586-rpm.bin  http://java.sun.com http://www.oracle.com/technetwork/java/index.html

安装命令:./jdk-6u22-linux-i586-rpm.bin

#set java_environment

JAVA_HOME=jdk路径

export JAVA_HOME

CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib

export CLASSPATH

PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH:$HOME/bin

export PATH

2.下载tomcat http://tomcat.apache.org/ 解压后既可使用

3.下载mysql http://www.mysql.com/

下载client与servet即可

MySQL-client-5.1.52-1.glibc23.i386.rpm

MySQL-server-5.1.52-1.glibc23.i386.rpm

 

org.hibernate.exception.SQLGrammarException:couldnotexecutequery

引起的错误其实很简单。百度谷歌了好久没用,终于自己发现了问题…

先贴出错误:

javax.servlet.ServletException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
	org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)


root cause 

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
	org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:615)
	org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
	org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:917)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:909)
	com.dao.TbUsersDAO.login(TbUsersDAO.java:196)
	com.services.imp.UserServicesImp.login(UserServicesImp.java:20)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	$Proxy0.login(Unknown Source)
	com.actions.LoginRigAction.login(LoginRigAction.java:34)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
	org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)


root cause 

org.hibernate.exception.SQLGrammarException: could not execute query
	org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	org.hibernate.loader.Loader.doList(Loader.java:2223)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	org.hibernate.loader.Loader.list(Loader.java:2099)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:926)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
	org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:917)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:909)
	com.dao.TbUsersDAO.login(TbUsersDAO.java:196)
	com.services.imp.UserServicesImp.login(UserServicesImp.java:20)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	$Proxy0.login(Unknown Source)
	com.actions.LoginRigAction.login(LoginRigAction.java:34)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
	org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)


root cause 

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: SELECT command denied to user 'tpmob'@'183.14.161.37' for table 'tb_users'
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
	org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
	org.hibernate.loader.Loader.doQuery(Loader.java:674)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	org.hibernate.loader.Loader.doList(Loader.java:2220)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	org.hibernate.loader.Loader.list(Loader.java:2099)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:926)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
	org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:917)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:909)
	com.dao.TbUsersDAO.login(TbUsersDAO.java:196)
	com.services.imp.UserServicesImp.login(UserServicesImp.java:20)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	$Proxy0.login(Unknown Source)
	com.actions.LoginRigAction.login(LoginRigAction.java:34)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
	org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

解决方法: 项目ftp上传时候必须进行必要的修改

   其实很简单,是【没连接到数据库所以查询不到。】把你的ssh框架中的pojo的映射文件打开把 找到如:<class name=”com.pojos.TbUsers” table=”tb_users” catalog=”tpmob”>    把catalog=”改成你的服务器上的远程数据库名字”;   因为它默认的是你本地项目名称。所以上传时候会报错找不到…

 

JAVASQL事务

在与数据库操作时,如果执行多条更新的SQL语句(如:update或insert语句),在执行第一条后如果出现异常或电脑断电,

则后面的SQL语句执行不了,这时候设定我们自己提交SQL语句,不让JDBC自动提交,格式为:

conn.setAutoCommit(false);

执行多条SQL语句;

conn.commit();

//恢复自动提交模式

conn.setAutoCommit(true);

代码示例:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestTransaction {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
		PreparedStatement ps = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/mydb", "root", "root");
			System.out.println("连接数据库成功!");
			stmt = con.createStatement();
			// JAVA默认为TRUE,我们自己处理需要设置为FALSE,并且修改为手动提交,才可以调用rollback()函数
			con.setAutoCommit(false);
			stmt.addBatch("insert into people values(078,'ding','duo')");
			stmt.addBatch("insert into people values(30,'nokia','ddd')");
			stmt.executeBatch();
			// 事务提交
			con.commit();
			// 设置为自动提交,改为TRUE
			con.setAutoCommit(true);

			/*
			 * String sql = "select * from people"; rs = stmt.executeQuery(sql);
			 * while(rs.next()){ System.out.println(rs.getString("id") + " " +
			 * rs.getString("name")); }
			 */
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException se) {
			se.printStackTrace();
			try {
				// 产生的任何SQL异常都需要进行回滚,并设置为系统默认的提交方式,即为TRUE
				if (con != null) {
					con.rollback();
					con.setAutoCommit(true);
				}
			} catch (SQLException se1) {
				se.printStackTrace();
			}
		} finally {
			try {
				if (rs != null) {
					rs.close();
					rs = null;
				}
				if (stmt != null) {
					stmt.close();
					stmt = null;
				}
				if (con != null) {
					con.close();
					con = null;
				}
			} catch (SQLException se) {
				se.printStackTrace();
			}
		}
	}

}


本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/fafeiboy/archive/2008/07/29/2734889.aspx

 

Preparement方法问题

Oracle开发中进行数据插入的操作,代码是可以完全执行的,到了Mysql方法下 ,却报插入失败的操作。具体报错信息如下:

java.sql.SQLException: Unable to retrieve metadata for procedure.

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)

at com.mysql.jdbc.CallableStatement.extractProcedureName(CallableStatement.java:857)

at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:692)

at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:513)

at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4520)

at com.mysql.jdbc.Connection.prepareCall(Connection.java:4594)

at com.mysql.jdbc.Connection.prepareCall(Connection.java:4568)

at com.caucho.sql.UserConnection.prepareCall(UserConnection.java:427)

at com.whir.cms.prjs.chaoHuGov.lwzzMessage.LWMessageServiceImpl.addRecordMessage(LWMessageServiceImpl.java:90)

at _jsp._lwzt._index__jsp._jspService(_index__jsp.java:1048)

at com.caucho.jsp.JavaPage.service(JavaPage.java:61)

at com.caucho.jsp.Page.pageservice(Page.java:578)

at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:195)

at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:148)

at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)

at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)

at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:273)

at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)

at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743)

at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662)

at java.lang.Thread.run(Thread.java:595)

不能够为存储过程找到元数据!的错误信息。

开始以为调用

PreparementStatement的时候 参数设置的有问题。后来经过试验才发现是因为PreparementStatement方法调用的时候发生了错误。

具体方法如下:

开始调用的Connection接口的方法:

PreparedStatement pstmt = this.connection.prepareCall(sql.toString());

改正后调用接口的方法:

PreparedStatement pstmt = this.connection.prepareStatement(sql.toString());

总结1

prepareCall:创建一个 CallableStatement 对象来调用数据库存储过程

prepareStatement:创建一个 PreparedStatement 对象来将参数化的 SQL 语句发送到数据库

总结2

pstmt.setString()

可以设置所有类型的参数。不至于类型转换的时候报错。

总结3

想了下 Mysql是不带Procedure的,不支持存储过程,所以用CallableStatement就会报错了。但是OracleCallableStatement调用没有报错。

而且注意一点:CallableStatementPrepareStatement的子接口。

TomCat6.0数据库连接池配置实例(mysql数据库)

TomCat6.0数据库连接池配置有几种方式,在这里我只介绍其中的一种供大家参考: 下面我把配置过程分成三个步骤来完成: 第一步:在你安装TomCat的目录下找到context.xml配置文件。(例如:D:\Tomcat 6.0\conf\context.xml)然后打开context.xml,在标签之间加入以下内容:(为了大家容易理解,我加了较详细的注释) //这个也默认就好了 第二步:在你的项目WEB-INF目录下找到web.xml配置文件,然后打开,在标签之间加入以下内容: DB Connection jdbc/course javax.sql.DataSource Container 其中:DB Connection 是自定义的,而jdbc/course是对应上面标签中的name属性的值,还有javax.sql.DataSource就对应type属性的值,而最后Container对应的是auth属性的值。 第三步:上网下载一个叫mysql-connector-java-3.1.10-bin.jar的jar包,然后将该jar包放到TomCat安装目录下的lib文件夹里。(例如:D:\Tomcat 6.0\lib\mysql-connector-java-3.1.10-bin.jar)完成这三步就配置好了TomCat数据源了。 下面根据刚才配置好的数据源做一个简单获取数据库连接的测试,代码如下: import javax.sql.DataSource; import java.sql.Connection; import javax.naming.InitialContext; public class GetConnectionTest { public static void main(String[] args) { try { InitialContext ctx = new InitialContext(); /*在下面的字符串”java:comp/env/jdbc/course”中,*”java:comp/env/”是不变的, *而”jdbc/course”大家应该还记得自己之前起的数据源名称吧! */ DataSource ds = (DataSource) ctx.lookup(“java:comp/env/jdbc/course”); Connection conn = ds.getConnection(); } catch (Exception e) { e.printStackTrace(); } } }

 

 

 

 

 

 

2.在tomcat/conf/context.xml添加

 

<Resource name=”java:/ConnectDB” auth=”Container” type=”javax.sql.DataSource”
    maxActive=”100″ maxIdle=”30″ maxWait=”10000″ username=”root” password=”root” driverClassName=”com.mysql.jdbc.Driver”        url=”jdbc:mysql://192.168.0.192:3306/tdrms”/>

thiswebapplicationinstancehasbeenstoppedalready

信息: Illegal access: this web application instance has been stopped already.  Could not load com.mysql.jdbc.Util.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1246)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
    at com.mysql.jdbc.CommunicationsException.<init>(CommunicationsException.java:180)
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2710)
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
    at com.mysql.jdbc.MysqlIO.quit(MysqlIO.java:1338)
    at com.mysql.jdbc.Connection.realClose(Connection.java:4429)
    at com.mysql.jdbc.Connection.cleanup(Connection.java:1973)
    at com.mysql.jdbc.Connection.finalize(Connection.java:3114)
    at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
    at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
    at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
    at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)

排错:删除掉asm-2-2-3.jar包

Java在处理大数据的时候一些小技巧

众所周知,java在处理数据量比较大的时候,加载到内存必然会导致内存溢出,而在一些

数据处理中我们不得不去处理海量数据,在做数据处理中,我们常见的手段是分解,压缩,

并行,临时文件等方法;

  例如,我们要将数据库(不论是什么数据库)的数据导出到一个文件,一般是Excel或文本格式的CSV;对于Excel来讲,对于POI和JXL的接口,你很多时候没有办法去控制内存什么时候向磁盘写入,很恶心,而且这些API在内存构造的对象大小将比数据原有的大小要大很多倍数,所以你不得不去拆分Excel,还好,POI开始意识到这个问题,在 3.8.4的版本后,开始提供cache的行数,提供了SXSSFWorkbook的接口,可以设置在内存中的行数,不过可惜的是,他当你超过这个行数,每添加一行,它就将相对行数前面的一行写入磁盘(如你设置2000行的话,当你写第20001行的时候,他会将第一行写入磁盘),其实这个时候他些的临时文件,以至于不消耗内存,不过这样你会发现,刷磁盘的频率会非常高,我们的确不想这样,因为我们想让他达到一个范围一次性将数据刷如磁盘,比如一次刷1M 之类的做法,可惜现在还没有这种API,很痛苦,我自己做过测试,通过写小的Excel比使用目前提供刷磁盘的API来写大文件,效率要高一些,而且这样如果访问的人稍微多一些磁盘IO可能会扛不住,因为IO资源是非常有限的,所以还是拆文件才是上策;而当我们写CSV,也就是文本类型的文件,我们很多时候是可以自己控制的,不过你不要用CSV自己提供的API,也是不太可控的,CSV本身就是文本文件,你按照文本格式写入即可被CSV识别出来;如何写入呢 下面来说说。。。

  在处理数据层面,如从数据库中读取数据,生成本地文件,写代码为了方便,我们未必要1M怎么来处理,这个交给底层的驱动程序去拆分,对于我们的程序来讲我们认为它是连续写即可;我们比如想将一个1000W数据的数据库表,导出到文件;此时,你要么进行分页,oracle当然用三层包装即可,mysql用 limit,不过分页每次都会新的查询,而且随着翻页,会越来越慢,其实我们想拿到一个句柄,然后向下游动,编译一部分数据(如10000行)将写文件一次(写文件细节不多说了,这个是最基本的),需要注意的时候每次buffer的数据,在用outputstream写入的时候,最好flush一下,将缓冲区清空下;接下来,执行一个没有where条件的SQL,会不会将内存撑爆 是的,这个问题我们值得去思考下,通过API发现可以对SQL进行一些操作,例如,通过:

PreparedStatement statement = connection.prepareStatement(sql),这是默认得到的预编译,还可以通过设置:

  PreparedStatement statement = connection.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);

  来设置游标的方式,以至于游标不是将数据直接cache到本地内存,然后通过设置statement.setFetchSize(200);设置游标每次遍历的大小;OK,这个其实我用过,oracle用了和没用没区别,因为oracle的jdbc API默认就是不会将数据cache到java的内存中的,而mysql里头设置根本无效,我上面说了一堆废话,呵呵,我只是想说,java提供的标准 API也未必有效,很多时候要看厂商的实现机制,还有这个设置是很多网上说有效的,但是这纯属抄袭;对于oracle上面说了不用关心,他本身就不是 cache到内存,所以java内存不会导致什么问题,如果是mysql,首先必须使用5以上的版本,然后在连接参数上加上 useCursorFetch=true这个参数,至于游标大小可以通过连接参数上加上:defaultFetchSize=1000来设置,例如:

  jdbc:mysql://xxx.xxx.xxx.xxx:3306 /abc zeroDateTimeconvertToNull&useCursorFetch=true& defaultFetchSize=1000< /span>

  上次被这个问题纠结了很久(mysql的数据老导致程序内存膨胀,并行2个直接系统就宕了),还去看了很多源码才发现奇迹竟然在这里,最后经过 mysql文档的确认,然后进行测试,并行多个,而且数据量都是500W以上的,都不会导致内存膨胀,GC一切正常,这个问题终于完结了。

  我们再聊聊其他的,数据拆分和合并,当数据文件多的时候我们想合并,当文件太大想要拆分,合并和拆分的过程也会遇到类似的问题,还好,这个在我们可控制的范围内,如果文件中的数据最终是可以组织的,那么在拆分和合并的时候,此时就不要按照数据逻辑行数来做了,因为行数最终你需要解释数据本身来判定,但是只是做拆分是没有必要的,你需要的是做二进制处理,在这个二进制处理过程,你要注意了,和平时read文件不要使用一样的方式,平时大多对一个文件读取只是用一次read操作,如果对于大文件内存肯定直接挂掉了,不用多说,你此时因该每次读取一个可控范围的数据,read方法提供了重载的 offset和length的范围,这个在循环过程中自己可以计算出来,写入大文件和上面一样,不要读取到一定程序就要通过写入流flush到磁盘;其实对于小数据量的处理在现代的NIO技术的中也有用到,例如多个终端同时请求一个大文件下载,例如视频下载吧,在常规的情况下,如果用java的容器来处理,一般会发生两种情况:

  其一为内存溢出,因为每个请求都要加载一个文件大小的内存甚至于更多,因为java包装的时候会产生很多其他的内存开销,如果使用二进制会产生得少一些,而且在经过输入输出流的过程中还会经历几次内存拷贝,当然如果有你类似nginx之类的中间件,那么你可以通过send_file模式发送出去,但是如果你要用程序来处理的时候,内存除非你足够大,但是java内存再大也会有GC的时候,如果你内存真的很大,GC的时候死定了,当然这个地方也可以考虑自己通过直接内存的调用和释放来实现,不过要求剩余的物理内存也足够大才行,那么足够大是多大呢 这个不好说,要看文件本身的大小和访问的频率;

  其二为假如内存足够大,无限制大,那么此时的限制就是线程,传统的IO模型是线程是一个请求一个线程,这个线程从主线程从线程池中分配后,就开始工作,经过你的Context包装、Filter、拦截器、业务代码各个层次和业务逻辑、访问数据库、访问文件、渲染结果等等,其实整个过程线程都是被挂住的,所以这部分资源非常有限,而且如果是大文件操作是属于IO密集型的操作,大量的CPU时间是空余的,方法最直接当然是增加线程数来控制,当然内存足够大也有足够的空间来申请线程池,不过一般来讲一个进程的线程池一般会受到限制也不建议太多的,而在有限的系统资源下,要提高性能,我们开始有了new IO技术,也就是NIO技术,新版的里面又有了AIO技术,NIO只能算是异步IO,但是在中间读写过程仍然是阻塞的(也就是在真正的读写过程,但是不会去关心中途的响应),还未做到真正的异步IO,在监听connect的时候他是不需要很多线程参与的,有单独的线程去处理,连接也又传统的socket变成了selector,对于不需要进行数据处理的是无需分配线程处理的;而AIO通过了一种所谓的回调注册来完成,当然还需要OS的支持,当会掉的时候会去分配线程,目前还不是很成熟,性能最多和NIO吃平,不过随着技术发展,AIO必然会超越NIO,目前谷歌V8虚拟机引擎所驱动的node.js就是类似的模式,有关这种技术不是本文的说明重点;

  将上面两者结合起来就是要解决大文件,还要并行度,最土的方法是将文件每次请求的大小降低到一定程度,如8K(这个大小是经过测试后网络传输较为适宜的大小,本地读取文件并不需要这么小),如果再做深入一些,可以做一定程度的cache,将多个请求的一样的文件,cache在内存或分布式缓存中,你不用将整个文件cache在内存中,将近期使用的cache几秒左右即可,或你可以采用一些热点的算法来配合;类似迅雷下载的断点传送中(不过迅雷的网络协议不太一样),它在处理下载数据的时候未必是连续的,只要最终能合并即可,在服务器端可以反过来,谁正好需要这块的数据,就给它就可以;才用NIO后,可以支持很大的连接和并发,本地通过NIO做socket连接测试,100个终端同时请求一个线程的服务器,正常的WEB应用是第一个文件没有发送完成,第二个请求要么等待,要么超时,要么直接拒绝得不到连接,改成NIO后此时100个请求都能连接上服务器端,服务端只需要1个线程来处理数据就可以,将很多数据传递给这些连接请求资源,每次读取一部分数据传递出去,不过可以计算的是,在总体长连接传输过程中总体效率并不会提升,只是相对相应和所开销的内存得到量化控制,这就是技术的魅力,也许不要太多的算法,不过你得懂他。

  类似的数据处理还有很多,有些时候还会将就效率问题,比如在HBase的文件拆分和合并过程中,要不影响线上业务是比较难的事情,很多问题值得我们去研究场景,因为不同的场景有不同的方法去解决,但是大同小异,明白思想和方法,明白内存和体系架构,明白你所面临的是沈阳的场景,只是细节上改变可以带来惊人的效果。

原文:http://www.thebigdata.cn/QiTa/8605.html[/size]

jboss和mysql的中文乱码????处理,已经过验证

1、jboss中修改/bin/run.bat

添加set JAVA_OPTS=%JAVA_OPTS% -Xms512m -Xmx1024m -XX:MaxPermSize=256m -Ddefault.client.encoding=GBK -Dfile.encoding=GBK -Duser.language=Zh  -server

2、mysql中修改/bin/my.ini中

在[mysqld]下面添加

character-set-server = utf8

collation-server = utf8_general_ci

3、经过测试 页面都可以正常显示中文。

Java读取properties文件【转】

使用J2SE API读取Properties文件的六种方法

1。使用java.util.Properties类的load()方法
示例: InputStream in = lnew BufferedInputStream(new FileInputStream(name));
Properties p = new Properties();
p.load(in);

2。使用java.util.ResourceBundle类的getBundle()方法
示例: ResourceBundle rb = ResourceBundle.getBundle(name, Locale.getDefault());

3。使用java.util.PropertyResourceBundle类的构造函数
示例: InputStream in = new BufferedInputStream(new FileInputStream(name));
ResourceBundle rb = new PropertyResourceBundle(in);

4。使用class变量的getResourceAsStream()方法
示例: InputStream in = JProperties.class.getResourceAsStream(name);
Properties p = new Properties();
p.load(in);

5。使用class.getClassLoader()所得到的java.lang.ClassLoader的getResourceAsStream()方法
示例: InputStream in = JProperties.class.getClassLoader().getResourceAsStream(name);
Properties p = new Properties();
p.load(in);

6。使用java.lang.ClassLoader类的getSystemResourceAsStream()静态方法
示例: InputStream in = ClassLoader.getSystemResourceAsStream(name);
Properties p = new Properties();
p.load(in);

补充

Servlet中可以使用javax.servlet.ServletContext的getResourceAsStream()方法
示例:InputStream in = context.getResourceAsStream(path);
Properties p = new Properties();
p.load(in);

完整的示例,可以参考附件文件
如何上传文件,谁知道请告诉以下。 只好把source都贴上来了
JProperties.java文件

package com.kindani;

//import javax.servlet.ServletContext;
import java.util.*;
import java.io.InputStream;
import java.io.IOException;
import java.io.BufferedInputStream;
import java.io.FileInputStream;

public class JProperties {

public final static int BY_PROPERTIES = 1;
public final static int BY_RESOURCEBUNDLE = 2;
public final static int BY_PROPERTYRESOURCEBUNDLE = 3;
public final static int BY_CLASS = 4;
public final static int BY_CLASSLOADER = 5;
public final static int BY_SYSTEM_CLASSLOADER = 6;

public final static Properties loadProperties(final String name, final int type) throws IOException {
Properties p = new Properties();
InputStream in = null;
if (type == BY_PROPERTIES) {
in = new BufferedInputStream(new FileInputStream(name));
assert (in != null);
p.load(in);
} else if (type == BY_RESOURCEBUNDLE) {
ResourceBundle rb = ResourceBundle.getBundle(name, Locale.getDefault());
assert (rb != null);
p = new ResourceBundleAdapter(rb);
} else if (type == BY_PROPERTYRESOURCEBUNDLE) {
in = new BufferedInputStream(new FileInputStream(name));
assert (in != null);
ResourceBundle rb = new PropertyResourceBundle(in);
p = new ResourceBundleAdapter(rb);
} else if (type == BY_CLASS) {
assert (JProperties.class.equals(new JProperties().getClass()));
in = JProperties.class.getResourceAsStream(name);
assert (in != null);
p.load(in);
// return new JProperties().getClass().getResourceAsStream(name);
} else if (type == BY_CLASSLOADER) {
assert (JProperties.class.getClassLoader().equals(new JProperties().getClass().getClassLoader()));
in = JProperties.class.getClassLoader().getResourceAsStream(name);
assert (in != null);
p.load(in);
// return new JProperties().getClass().getClassLoader().getResourceAsStream(name);
} else if (type == BY_SYSTEM_CLASSLOADER) {
in = ClassLoader.getSystemResourceAsStream(name);
assert (in != null);
p.load(in);
}

if (in != null) {
in.close();
}
return p;

}

// ———————————————- servlet used

// ———————————————- support class

public static class ResourceBundleAdapter extends Properties {
public ResourceBundleAdapter(ResourceBundle rb) {
assert (rb instanceof java.util.PropertyResourceBundle);
this.rb = rb;
java.util.Enumeration e = rb.getKeys();
while (e.hasMoreElements()) {
Object o = e.nextElement();
this.put(o, rb.getObject((String) o));
}
}

private ResourceBundle rb = null;

public ResourceBundle getBundle(String baseName) {
return ResourceBundle.getBundle(baseName);
}

public ResourceBundle getBundle(String baseName, Locale locale) {
return ResourceBundle.getBundle(baseName, locale);
}

public ResourceBundle getBundle(String baseName, Locale locale, ClassLoader loader) {
return ResourceBundle.getBundle(baseName, locale, loader);
}

public Enumeration getKeys() {
return rb.getKeys();
}

public Locale getLocale() {
return rb.getLocale();
}

public Object getObject(String key) {
return rb.getObject(key);
}

public String getString(String key) {
return rb.getString(key);
}

public String[] getStringArray(String key) {
return rb.getStringArray(key);
}

protected Object handleGetObject(String key) {
return ((PropertyResourceBundle) rb).handleGetObject(key);
}

}

}

JPropertiesTest.java文件

package com.kindani.test;

import junit.framework.*;
import com.kindani.JProperties;

//import javax.servlet.ServletContext;
import java.util.Properties;

public class JPropertiesTest extends TestCase {
JProperties jProperties;
String key = “helloworld.title”;
String value = “Hello World!”;

public void testLoadProperties() throws Exception {
String name = null;
Properties p = new Properties();

name = “C:\\IDEAP\\Properties4Methods\\src\\com\\kindani\\test\\LocalStrings.properties”;
p = JProperties.loadProperties(name, JProperties.BY_PROPERTIES);
assertEquals(value, p.getProperty(key));

name = “com.kindani.test.LocalStrings”;
p = JProperties.loadProperties(name,JProperties.BY_RESOURCEBUNDLE);
assertEquals(value, p.getProperty(key));
assertEquals(value,((JProperties.ResourceBundleAdapter)p).getString(key));

name = “C:\\IDEAP\\Properties4Methods\\src\\com\\kindani\\test\\LocalStrings.properties”;
p = JProperties.loadProperties(name, JProperties.BY_PROPERTYRESOURCEBUNDLE);
assertEquals(value, p.getProperty(key));
assertEquals(value,((JProperties.ResourceBundleAdapter)p).getString(key));

name = “\\com\\kindani\\test\\LocalStrings.properties”;
p = JProperties.loadProperties(name, JProperties.BY_SYSTEM_CLASSLOADER);
assertEquals(value, p.getProperty(key));

name = “\\com\\kindani\\test\\LocalStrings.properties”;
p = JProperties.loadProperties(name, JProperties.BY_CLASSLOADER);
assertEquals(value, p.getProperty(key));

name = “test\\LocalStrings.properties”;
p = JProperties.loadProperties(name, JProperties.BY_CLASS);
assertEquals(value, p.getProperty(key));
}

}

properties文件与JPropertiesTest.java文件相同的目录下
LocalStrings.properties文件
# $Id: LocalStrings.properties,v 1.1 2000/08/17 00:57:52 horwat Exp $

# Default localized resources for example servlets
# This locale is en_US

helloworld.title=Hello World!

requestinfo.title=Request Information Example
requestinfo.label.method=Method:
requestinfo.label.requesturi=Request URI:
requestinfo.label.protocol=Protocol:
requestinfo.label.pathinfo=Path Info:
requestinfo.label.remoteaddr=Remote Address:

requestheader.title=Request Header Example

requestparams.title=Request Parameters Example
requestparams.params-in-req=Parameters in this request:
requestparams.no-params=No Parameters, Please enter some
requestparams.firstname=First Name:
requestparams.lastname=Last Name:

cookies.title=Cookies Example
cookies.cookies=Your browser is sending the following cookies:
cookies.no-cookies=Your browser isn’t sending any cookies
cookies.make-cookie=Create a cookie to send to your browser
cookies.name=Name:
cookies.value=Value:
cookies.set=You just sent the following cookie to your browser:

sessions.title=Sessions Example
sessions.id=Session ID:
sessions.created=Created:
sessions.lastaccessed=Last Accessed:
sessions.data=The following data is in your session:
sessions.adddata=Add data to your session
sessions.dataname=Name of Session Attribute:
sessions.datavalue=Value of Session Attribute:

——————————————————————————————————————————————————————

Java对properties配置文件的操作

package com.yorsun;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Properties;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServlet;

public class PropertiesUnit {
private String filename;

private Properties p;

private FileInputStream in;

private FileOutputStream out;

public PropertiesUnit(String filename) {
this.filename = filename;
File file = new File(filename);
try {
in = new FileInputStream(file);
p = new Properties();
p.load(in);
in.close();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
System.err.println(“配置文件config.properties找不到!”);
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
System.err.println(“读取配置文件config.properties错误!”);
e.printStackTrace();
}
}

public static String getConfigFile(HttpServlet hs) {
return getConfigFile(hs, “config.properties”);
}

private static String getConfigFile(HttpServlet hs, String configFileName) {
String configFile = “”;
ServletContext sc = hs.getServletContext();
configFile = sc.getRealPath(“/” + configFileName);
if (configFile == null || configFile.equals(“”)) {
configFile = “/” + configFileName;
}
// TODO Auto-generated method stub
return configFile;
}

public void list() {
p.list(System.out);
}

public String getValue(String itemName) {
return p.getProperty(itemName);
}

public String getValue(String itemName, String defaultValue) {
return p.getProperty(itemName, defaultValue);
}

public void setValue(String itemName, String value) {
p.setProperty(itemName, value);
}

public void saveFile(String filename, String description) throws Exception {
try {
File f = new File(filename);
out = new FileOutputStream(f);
p.store(out, description);
out.close();
} catch (IOException ex) {
throw new Exception(“无法保存指定的配置文件:” + filename);
}
}

public void saveFile(String filename) throws Exception{
saveFile(filename,””);
}

public void saveFile() throws Exception{
if(filename.length()==0)
throw new Exception(“需指定保存的配置文件名”);
saveFile(filename);
}

public void deleteValue(String value){
p.remove(value);
}

public static void main(String args[]){
String file=”/eclipse/workspace/NewsTest/WEB-INF/config.properties”;
// String file=”D:\\eclipse\\workspace\\NewsTest\\WEB-INF\\config.properties”;
PropertiesUnit pu=new PropertiesUnit(file);
pu.list();
}

}

——————————————————————————————————————————————————————–

package com.test.TestClass;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;

public class ReadPropertiesFile …{

public void readPropertiesFile(String fileName) throws FileNotFoundException …{
String str = “”;
Properties prop = new Properties();

InputStream stream = null;

//读取这个类在同一包中的properties文件
//stream = getClass().getClassLoader().getResourceAsStream(fileName);
System.out.println(“path:” + getClass().getResource(fileName));

//读取SRC下的的properties文件
String path = getClass().getResource(“/”).getPath();
stream = new BufferedInputStream(new FileInputStream(new File(path+fileName)));

try …{
prop.load(stream);
str = prop.getProperty(“localname”);
System.out.println(“localname:” + str);
System.out.println(“properties:” + prop);
stream.close();

} catch (IOException e) …{
// TODO Auto-generated catch block
e.printStackTrace();
}
}

public static void main(String[] args) throws FileNotFoundException …{
// TODO Auto-generated method stub
new ReadPropertiesFile().readPropertiesFile(“config.properties”);

}

}

————————————————————————————————————————————–

//=================sprin配置文件================================
<bean
id=”userService”
class=”com.thtf.ezone.ezesb.jmx.admin.service.impl.UserServiceImpl”>
<property
name=”filePath”
value=”config/userInfo.properties” />
</bean>

//=================java文件================================

package com.thtf.ezone.ezesb.jmx.admin.service.impl;

import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;

public class UserServiceImpl implements UserService {

String filePath = null;

public void setFilePath(String filePath) {
this.filePath = filePath;
}

public static void main(String dd[])throws Exception{

Properties p = new Properties();
FileInputStream ferr=new FileInputStream((getClass().getClassLoader()
.getResource(“”) + filePath).toString().substring(6));// 用subString(6)去掉:file:/try{
p.load(ferr);
ferr.close();
Set s = p.keySet();
Iterator it = s.iterator();
while(it.hasNext()){
String id = (String)it.next();
String value = p.getProperty(id);
System.out.println(id+”:=”+value);
}
}catch(Exception e){
e.printStackTrace();
}
}
}

//==============databaseconfing.properties 文件=====================

#———————————-
# sql server 2000数据厍连接信息
#———————————-
dp.sd.DataBaseTyp=mssql
DataBaseHost=127.0.0.1:1433
DataBase=formpro
UserName=sa
PassWord=01
#———————————-
# mysql 数据厍连接信息
#———————————-
#DataBaseHost=127.0.0.1:3306
#DataBaseTyp=mysql
#DataBase=snow
#UserName=root
#PassWord=01
//==========================运行结果=======================

PassWord:=01
DataBaseHost:=127.0.0.1:1433
DataBase:=formpro
dp.sd.DataBaseTyp:=mssql
UserName:=sa

为了您的安全,请只打开来源可靠的网址

打开网站    取消

来自: http://hi.baidu.com/hgd0324/blog/item/11f3933f19f4eafd828b1391.html

45条线程没错误.

31728 james     18   0 1518m 287m 9092 S  251  7.3  23:00.57 java     

                                            

stack -l 23460

23460: No such process

[james@www GetInfo]$ ps -ef|grep groovy

james    31728 23234 99 11:42 pts/2    00:27:04 /usr/java/latest/bin/java -classpath /etc/groovy/groovy-1.6.1/lib/groovy-1.6.1.jar -Dscript.name=/etc/groovy/groovy-1.6.1/bin/groovy -Dprogram.name=groovy -Dgroovy.starter.conf=/etc/groovy/groovy-1.6.1/conf/groovy-starter.conf -Dgroovy.home=/etc/groovy/groovy-1.6.1 -Dtools.jar=/usr/java/latest/lib/tools.jar org.codehaus.groovy.tools.GroovyStarter –main groovy.ui.GroovyMain –conf /etc/groovy/groovy-1.6.1/conf/groovy-starter.conf –classpath .:/usr/java/latest/lib/dt.jar:/usr/java/latest/lib/tools.jar:/usr/java/latest/lib/mysql-connector-java-5.1.6-bin.jar:. PriceThread-v2.groovy

james    32317 23251  0 11:50 pts/3    00:00:00 grep groovy

[james@www GetInfo]$ jstack -l 31728

2009-04-30 11:50:42

Full thread dump Java HotSpot(TM) 64-Bit Server VM (11.2-b01 mixed mode):

“Attach Listener” daemon prio=10 tid=0x000000005a848000 nid=0x7e67 runnable [0x0000000000000000..0x0000000000000000]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

        – None

“Keep-Alive-Timer” daemon prio=10 tid=0x0000000059fc5c00 nid=0x7e3f waiting on condition [0x0000000044337000..0x0000000044337a90]

   java.lang.Thread.State: TIMED_WAITING (sleeping)

        at java.lang.Thread.sleep(Native Method)

        at sun.net.www.http.KeepAliveCache.run(KeepAliveCache.java:149)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – None

“MySQL Statement Cancellation Timer” daemon prio=10 tid=0x000000005a4d1400 nid=0x7c36 in Object.wait() [0x0000000040971000..0x0000000040971d10]

   java.lang.Thread.State: WAITING (on object monitor)

        at java.lang.Object.wait(Native Method)

        – waiting on <0x00002aaab498db30> (a java.util.TaskQueue)

        at java.lang.Object.wait(Object.java:485)

        at java.util.TimerThread.mainLoop(Timer.java:483)

        – locked <0x00002aaab498db30> (a java.util.TaskQueue)

        at java.util.TimerThread.run(Timer.java:462)

   Locked ownable synchronizers:

        – None

“DestroyJavaVM” prio=10 tid=0x00002aaaf82ab400 nid=0x7bfc waiting on condition [0x0000000000000000..0x0000000040870d00]

   java.lang.Thread.State: RUNNABLE

   Locked ownable synchronizers:

        – None

“pool-1-thread-38” prio=10 tid=0x00002aaaf8164000 nid=0x7c2e runnable [0x0000000043e31000..0x0000000043e32d10]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

        – locked <0x00002aaae34c5850> (a com.mysql.jdbc.util.ReadAheadInputStream)

        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)

        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)

        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)

        – locked <0x00002aaae34c0cc8> (a java.lang.Object)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

        at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

        at java.sql.DriverManager.getConnection(DriverManager.java:582)

        at java.sql.DriverManager.getConnection(DriverManager.java:185)

        at java_sql_DriverManager$getConnection.call(Unknown Source)

        at CategoryThread.insertPrice(PriceThread-v2.groovy:453)

        – locked <0x00002aaae178efb0> (a CategoryThread)

        at CategoryThread$insertPrice.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:253)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab498e1b8> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-37” prio=10 tid=0x00002aaaf8162800 nid=0x7c2d runnable [0x0000000043d30000..0x0000000043d31d90]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

        – locked <0x00002aaae3ad24c0> (a com.mysql.jdbc.util.ReadAheadInputStream)

        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)

        – locked <0x00002aaae3acd938> (a java.lang.Object)

        at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1751)

        at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3425)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2045)

        – locked <0x00002aaae3acd938> (a java.lang.Object)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

        at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

        at java.sql.DriverManager.getConnection(DriverManager.java:582)

        at java.sql.DriverManager.getConnection(DriverManager.java:185)

        at java_sql_DriverManager$getConnection.call(Unknown Source)

        at CategoryThread.insertPrice(PriceThread-v2.groovy:453)

        – locked <0x00002aaae171fcb0> (a CategoryThread)

        at CategoryThread$insertPrice.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:253)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49ad470> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-36” prio=10 tid=0x00002aaaf8d25c00 nid=0x7c2c runnable [0x0000000043c2f000..0x0000000043c30a10]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)

        – locked <0x00002aaae3410a00> (a java.io.BufferedInputStream)

        at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:687)

        at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)

        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1049)

        – locked <0x00002aaae3409680> (a sun.net.www.protocol.http.HttpURLConnection)

        at java.net.URL.openStream(URL.java:1009)

        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.getContent(PriceThread-v2.groovy:581)

        – locked <0x00002aaae34091d0> (a CategoryThread)

        at CategoryThread$getContent.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:97)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49ada30> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-35” prio=10 tid=0x00002aaaf8d24000 nid=0x7c2b runnable [0x0000000043b2e000..0x0000000043b2fa90]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3770)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae2813770> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49adff0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-34” prio=10 tid=0x00002aaaf8d22800 nid=0x7c2a runnable [0x0000000043a2d000..0x0000000043a2eb10]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

        – locked <0x00002aaae3c8afb8> (a com.mysql.jdbc.util.ReadAheadInputStream)

        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)

        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)

        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)

        – locked <0x00002aaae3c86430> (a java.lang.Object)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

        at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

        at java.sql.DriverManager.getConnection(DriverManager.java:582)

        at java.sql.DriverManager.getConnection(DriverManager.java:185)

        at java_sql_DriverManager$getConnection.call(Unknown Source)

        at CategoryThread.insertPrice(PriceThread-v2.groovy:453)

        – locked <0x00002aaae1ffa980> (a CategoryThread)

        at CategoryThread$insertPrice.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:253)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49ae5b0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-33” prio=10 tid=0x00002aaaf8d21000 nid=0x7c29 runnable [0x000000004392c000..0x000000004392db90]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

        – locked <0x00002aaae4721508> (a com.mysql.jdbc.util.ReadAheadInputStream)

        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)

        at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:590)

        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1069)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)

        – locked <0x00002aaae471c980> (a java.lang.Object)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

        at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

        at java.sql.DriverManager.getConnection(DriverManager.java:582)

        at java.sql.DriverManager.getConnection(DriverManager.java:185)

        at java_sql_DriverManager$getConnection.call(Unknown Source)

        at CategoryThread.insertPrice(PriceThread-v2.groovy:453)

        – locked <0x00002aaae1fae7b8> (a CategoryThread)

        at CategoryThread$insertPrice.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:253)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49aeb70> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-32” prio=10 tid=0x00002aaaf8ba2c00 nid=0x7c28 runnable [0x000000004382b000..0x000000004382cc10]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3770)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae1f63290> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49af130> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-31” prio=10 tid=0x00002aaaf8ba1000 nid=0x7c27 runnable [0x000000004372b000..0x000000004372bc90]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae3bf9548> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49af6f0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-30” prio=10 tid=0x00002aaaf8b9f800 nid=0x7c26 runnable [0x000000004362a000..0x000000004362ad10]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)

        – locked <0x00002aaae4190440> (a java.io.BufferedInputStream)

        at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:687)

        at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)

        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1049)

        – locked <0x00002aaae418de28> (a sun.net.www.protocol.http.HttpURLConnection)

        at java.net.URL.openStream(URL.java:1009)

        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.getContent(PriceThread-v2.groovy:581)

        – locked <0x00002aaae418d978> (a CategoryThread)

        at CategoryThread$getContent.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:97)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49afcb0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-29” prio=10 tid=0x00002aaaf8cdf800 nid=0x7c25 runnable [0x0000000043529000..0x0000000043529d90]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3770)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae1da67d8> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b0270> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-28” prio=10 tid=0x00002aaaf8cde000 nid=0x7c24 runnable [0x0000000043427000..0x0000000043428a10]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae111d1f0> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b0948> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-27” prio=10 tid=0x00002aaaf8cdc400 nid=0x7c23 runnable [0x0000000043326000..0x0000000043327a90]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3770)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae31bcf38> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b0f08> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-26” prio=10 tid=0x00002aaaf8b3c800 nid=0x7c22 runnable [0x0000000043225000..0x0000000043226b10]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

        – locked <0x00002aaae3b272d0> (a com.mysql.jdbc.util.ReadAheadInputStream)

        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)

        – locked <0x00002aaae3b22748> (a java.lang.Object)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)

        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)

        – locked <0x00002aaae3b22748> (a java.lang.Object)

        at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.insertPrice(PriceThread-v2.groovy:472)

        – locked <0x00002aaae1cc6de8> (a CategoryThread)

        at CategoryThread$insertPrice.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:253)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b14c8> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-25” prio=10 tid=0x00002aaaf8b3ac00 nid=0x7c21 runnable [0x0000000043124000..0x0000000043125b90]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3770)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae2420ae8> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b1ba0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-24” prio=10 tid=0x00002aaaf8b39400 nid=0x7c20 runnable [0x0000000043024000..0x0000000043024c10]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)

        – locked <0x00002aaae4bb19e8> (a java.io.BufferedInputStream)

        at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:687)

        at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)

        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1049)

        – locked <0x00002aaae4baf290> (a sun.net.www.protocol.http.HttpURLConnection)

        at java.net.URL.openStream(URL.java:1009)

        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.getContent(PriceThread-v2.groovy:581)

        – locked <0x00002aaae4392dd0> (a CategoryThread)

        at CategoryThread$getContent.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:98)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b2160> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-23” prio=10 tid=0x00002aaaf8405c00 nid=0x7c1f runnable [0x0000000042f23000..0x0000000042f23c90]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)

        – locked <0x00002aaae478a408> (a java.io.BufferedInputStream)

        at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:687)

        at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)

        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1049)

        – locked <0x00002aaae4787cb0> (a sun.net.www.protocol.http.HttpURLConnection)

        at java.net.URL.openStream(URL.java:1009)

        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.getContent(PriceThread-v2.groovy:581)

        – locked <0x00002aaae41b46d8> (a CategoryThread)

        at CategoryThread$getContent.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:98)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b2720> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-22” prio=10 tid=0x00002aaaf8404c00 nid=0x7c1e runnable [0x0000000042e22000..0x0000000042e22d10]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3770)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae3201a28> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b2ce0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-21” prio=10 tid=0x00002aaaf8216800 nid=0x7c1d runnable [0x0000000042d21000..0x0000000042d21d90]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae18213a8> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b32a0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-20” prio=10 tid=0x00002aaafc3a5000 nid=0x7c1c runnable [0x0000000042c1f000..0x0000000042c20a10]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

        – locked <0x00002aaae38fb810> (a com.mysql.jdbc.util.ReadAheadInputStream)

        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)

        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)

        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)

        – locked <0x00002aaae38f6c88> (a java.lang.Object)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

        at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

        at java.sql.DriverManager.getConnection(DriverManager.java:582)

        at java.sql.DriverManager.getConnection(DriverManager.java:185)

        at java_sql_DriverManager$getConnection.call(Unknown Source)

        at CategoryThread.insertPrice(PriceThread-v2.groovy:453)

        – locked <0x00002aaae1d55c78> (a CategoryThread)

        at CategoryThread$insertPrice.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:253)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b3860> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-19” prio=10 tid=0x00002aaafc3dd400 nid=0x7c1b runnable [0x0000000042b1e000..0x0000000042b1fa90]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)

        – locked <0x00002aaae44f7408> (a java.io.BufferedInputStream)

        at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:687)

        at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)

        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1049)

        – locked <0x00002aaae3ab88c0> (a sun.net.www.protocol.http.HttpURLConnection)

        at java.net.URL.openStream(URL.java:1009)

        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.getContent(PriceThread-v2.groovy:581)

        – locked <0x00002aaae3ab8410> (a CategoryThread)

        at CategoryThread$getContent.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:97)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b3e20> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-18” prio=10 tid=0x00002aaafc3db800 nid=0x7c1a runnable [0x0000000042a1d000..0x0000000042a1eb10]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3770)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae2133720> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b43e0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-17” prio=10 tid=0x00002aaafc3d9c00 nid=0x7c19 runnable [0x000000004291c000..0x000000004291db90]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3778)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae2ee6758> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b49a0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-16” prio=10 tid=0x00002aaafc3d8400 nid=0x7c18 runnable [0x000000004281b000..0x000000004281cc10]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae35bf330> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49b4f60> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-15” prio=10 tid=0x00002aaafc3d6800 nid=0x7c17 runnable [0x000000004271a000..0x000000004271bc90]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)

        – locked <0x00002aaae4490c58> (a java.io.BufferedInputStream)

        at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:687)

        at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)

        at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:766)

        at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)

        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1049)

        – locked <0x00002aaae4482a28> (a sun.net.www.protocol.http.HttpURLConnection)

        at java.net.URL.openStream(URL.java:1009)

        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.getContent(PriceThread-v2.groovy:581)

        – locked <0x00002aaae4482578> (a CategoryThread)

        at CategoryThread$getContent.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:97)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49cbcd0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-14” prio=10 tid=0x00002aaafc3d4c00 nid=0x7c16 runnable [0x0000000042619000..0x000000004261ad10]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)

        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

        – locked <0x00002aaae358e028> (a com.mysql.jdbc.util.ReadAheadInputStream)

        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)

        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)

        – locked <0x00002aaae35894a0> (a java.lang.Object)

        at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1751)

        at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3425)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2045)

        – locked <0x00002aaae35894a0> (a java.lang.Object)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

        at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)

        at java.sql.DriverManager.getConnection(DriverManager.java:582)

        at java.sql.DriverManager.getConnection(DriverManager.java:185)

        at java_sql_DriverManager$getConnection.call(Unknown Source)

        at CategoryThread.insertPrice(PriceThread-v2.groovy:453)

        – locked <0x00002aaae0c59430> (a CategoryThread)

        at CategoryThread$insertPrice.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:253)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49cc290> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-13” prio=10 tid=0x00002aaafc3d3000 nid=0x7c15 runnable [0x0000000042519000..0x0000000042519d90]

   java.lang.Thread.State: RUNNABLE

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)

        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)

        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)

        – locked <0x00002aaae44167c8> (a java.io.BufferedInputStream)

        at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:687)

        at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)

        at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1049)

        – locked <0x00002aaae34937e8> (a sun.net.www.protocol.http.HttpURLConnection)

        at java.net.URL.openStream(URL.java:1009)

        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.getContent(PriceThread-v2.groovy:581)

        – locked <0x00002aaae3493338> (a CategoryThread)

        at CategoryThread$getContent.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:97)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49cc9f0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-12” prio=10 tid=0x00002aaafc3d1400 nid=0x7c14 runnable [0x0000000042417000..0x0000000042418a10]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae2d8e898> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49ccfb0> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)

“pool-1-thread-11” prio=10 tid=0x00002aaafc3cfc00 nid=0x7c13 runnable [0x0000000042316000..0x0000000042317a90]

   java.lang.Thread.State: RUNNABLE

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3770)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3782)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Curly.match0(Pattern.java:3789)

        at java.util.regex.Pattern$Curly.match(Pattern.java:3744)

        at java.util.regex.Pattern$Start.match(Pattern.java:3055)

        at java.util.regex.Matcher.search(Matcher.java:1105)

        at java.util.regex.Matcher.find(Matcher.java:535)

        at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)

        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)

        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)

        at CategoryThread.filterInfo(PriceThread-v2.groovy:563)

        – locked <0x00002aaae23d6a90> (a CategoryThread)

        at CategoryThread$filterInfo.call(Unknown Source)

        at CategoryThread.run(PriceThread-v2.groovy:194)

        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

        at java.lang.Thread.run(Thread.java:619)

   Locked ownable synchronizers:

        – <0x00002aaab49cd570> (a