Please report this error to your system administrator or appropriate technical support personnel. Thank you for your cooperation.
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in META-INF/flightsUS.xml. --- The error occurred while executing query. --- Check the select t1.from_city_code,t1.to_city_code,u.airline_code,u.airline_name, (select name from usin_city where code=t1.from_city_code) as from_city_name ,(select name from usin_city where code=t1.to_city_code) as to_city_name, t1.total_fare,t1.basic_fare,t1.taxes from (select from_city_code,to_city_code,min(total_fare) as total_fare,taxes,0+min(total_fare)-taxes as basic_fare, airline_code from usin_fare_info where from_city_code in (select code from usin_city where country_code=?) AND to_city_code=? AND airline_code=? group by to_city_code,airline_code order by rand())t1,usin_airline u where t1.airline_code=u.airline_code order by t1.total_fare limit 10; . --- Check the SQL Statement (preparation failed). --- Cause: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool exhausted; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in META-INF/flightsUS.xml. --- The error occurred while executing query. --- Check the select t1.from_city_code,t1.to_city_code,u.airline_code,u.airline_name, (select name from usin_city where code=t1.from_city_code) as from_city_name ,(select name from usin_city where code=t1.to_city_code) as to_city_name, t1.total_fare,t1.basic_fare,t1.taxes from (select from_city_code,to_city_code,min(total_fare) as total_fare,taxes,0+min(total_fare)-taxes as basic_fare, airline_code from usin_fare_info where from_city_code in (select code from usin_city where country_code=?) AND to_city_code=? AND airline_code=? group by to_city_code,airline_code order by rand())t1,usin_airline u where t1.airline_code=u.airline_code order by t1.total_fare limit 10; . --- Check the SQL Statement (preparation failed). --- Cause: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in META-INF/flightsUS.xml. --- The error occurred while executing query. --- Check the select t1.from_city_code,t1.to_city_code,u.airline_code,u.airline_name, (select name from usin_city where code=t1.from_city_code) as from_city_name ,(select name from usin_city where code=t1.to_city_code) as to_city_name, t1.total_fare,t1.basic_fare,t1.taxes from (select from_city_code,to_city_code,min(total_fare) as total_fare,taxes,0+min(total_fare)-taxes as basic_fare, airline_code from usin_fare_info where from_city_code in (select code from usin_city where country_code=?) AND to_city_code=? AND airline_code=? group by to_city_code,airline_code order by rand())t1,usin_airline u where t1.airline_code=u.airline_code order by t1.total_fare limit 10; . --- Check the SQL Statement (preparation failed). --- Cause: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool exhausted; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in META-INF/flightsUS.xml. --- The error occurred while executing query. --- Check the select t1.from_city_code,t1.to_city_code,u.airline_code,u.airline_name, (select name from usin_city where code=t1.from_city_code) as from_city_name ,(select name from usin_city where code=t1.to_city_code) as to_city_name, t1.total_fare,t1.basic_fare,t1.taxes from (select from_city_code,to_city_code,min(total_fare) as total_fare,taxes,0+min(total_fare)-taxes as basic_fare, airline_code from usin_fare_info where from_city_code in (select code from usin_city where country_code=?) AND to_city_code=? AND airline_code=? group by to_city_code,airline_code order by rand())t1,usin_airline u where t1.airline_code=u.airline_code order by t1.total_fare limit 10; . --- Check the SQL Statement (preparation failed). --- Cause: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212) at com.mmt.core.search.service.NamedQuerySearchService.executeQuery(NamedQuerySearchService.java:60) at com.mmt.core.search.service.NamedQuerySearchService.search(NamedQuerySearchService.java:55) at com.mmt.seo.flights.CompositeMemcacheSearchService.getSubcomponentResponse(CompositeMemcacheSearchService.java:115) at com.mmt.seo.flights.CompositeMemcacheSearchService.search(CompositeMemcacheSearchService.java:73) at com.mmt.core.web.action.SearchResultAction.execute(SearchResultAction.java:143) at sun.reflect.GeneratedMethodAccessor965.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Method.java:597) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242) at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:163) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:249) at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.mmt.core.web.interceptor.MethodInvokerInterceptor.intercept(MethodInvokerInterceptor.java:49) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:93) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:148) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:128) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:102) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:425) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:452) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285) at java.lang.Thread.run(Thread.java:619) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in META-INF/flightsUS.xml. --- The error occurred while executing query. --- Check the select t1.from_city_code,t1.to_city_code,u.airline_code,u.airline_name, (select name from usin_city where code=t1.from_city_code) as from_city_name ,(select name from usin_city where code=t1.to_city_code) as to_city_name, t1.total_fare,t1.basic_fare,t1.taxes from (select from_city_code,to_city_code,min(total_fare) as total_fare,taxes,0+min(total_fare)-taxes as basic_fare, airline_code from usin_fare_info where from_city_code in (select code from usin_city where country_code=?) AND to_city_code=? AND airline_code=? group by to_city_code,airline_code order by rand())t1,usin_airline u where t1.airline_code=u.airline_code order by t1.total_fare limit 10; . --- Check the SQL Statement (preparation failed). --- Cause: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) at com.mmt.core.search.service.NamedQuerySearchService$1.doInSqlMapClient(NamedQuerySearchService.java:64) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209) ... 75 more Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210) at $Proxy129.prepareStatement(Unknown Source) at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) ... 81 more Caused by: java.util.NoSuchElementException: Timeout waiting for idle object at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:756) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) ... 89 more