Exception caught:
com.inet.tds.at: [TDS Driver]java.net.ConnectException: Connection timed out: connect
at com.inet.tds.aq.a(Unknown Source)
at com.inet.tds.w.(Unknown Source)
at com.inet.tds.w.a(Unknown Source)
at com.inet.tds.TdsDriver.connect(Unknown Source)
at com.inet.pool.i.getPooledConnection(Unknown Source)
at com.inet.pool.g.c(Unknown Source)
at com.inet.pool.PoolManager.a(Unknown Source)
at com.inet.pool.PoolManager.getConnection(Unknown Source)
at com.inet.pool.PoolDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.catalogcity.website.cc_jdbc_factory.getConnection(cc_jdbc_factory.java:37)
at com.catalogcity.website.cc_sql_simple.get_connection(cc_sql_simple.java:47)
at com.catalogcity.website.cc_sql.get_connection(cc_sql.java:300)
at com.catalogcity.website.cc_query.open_connection(cc_query.java:1899)
at com.catalogcity.website.cc_query.old_prepare(cc_query.java:1536)
at com.catalogcity.website.cc_query.prepare(cc_query.java:555)
at com.catalogcity.website.cc_query.prepare(cc_query.java:536)
at com.catalogcity.website.cc_query.prepare(cc_query.java:525)
at com.catalogcity.website.cc_query.prepare(cc_query.java:512)
at com.catalogcity.website.categories.products.ProductHierarchy.getNodeInfo(ProductHierarchy.java:209)
at com.catalogcity.website.categories.products.ProductHierarchy.getSubstitute(ProductHierarchy.java:269)
at com.catalogcity.website.categories.AbstractHierarchy.ValidateNode(AbstractHierarchy.java:78)
at com.catalogcity.website.categories.products.ProductHierarchy.getProductHierarchyNode(ProductHierarchy.java:31)
at com.catalogcity.website.offerprods.cc_context_sprod.get_product_heirachy(cc_context_sprod.java:1292)
at com.catalogcity.website.offerprods.cc_context_sprod.init_node(cc_context_sprod.java:1265)
at com.catalogcity.website.offerprods.cc_context_sprod.init_ccmos_request(cc_context_sprod.java:804)
at com.catalogcity.website.cc_ccmos_site_request.init_site_request(cc_ccmos_site_request.java:26)
at com.catalogcity.website.cc_site_base.create_site_request(cc_site_base.java:614)
at com.catalogcity.website.cc_site_base.init_request(cc_site_base.java:653)
at com.catalogcity.website.cc_request.init_site_request(cc_request.java:833)
at com.catalogcity.website.cc_request.local_execute(cc_request.java:450)
at com.catalogcity.website.cc_request.processor_execute(cc_request.java:347)
at com.catalogcity.website.cc_request.process(cc_request.java:648)
at com.catalogcity.website.servlets.cc.ccmos_service(cc.java:37)
at com.catalogcity.website.servlets.ccmos_servlet.service(ccmos_servlet.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:861)
at com.catalogcity.amos_app_server.common.http_server.servlet_runner.execute(servlet_runner.java:79)
at com.catalogcity.amos_app_server.http_server.generic_servlet_resource_handler.execute(generic_servlet_resource_handler.java:41)
at com.catalogcity.amos_app_server.common.http_server.http_socket_runner.process_request(http_socket_runner.java:706)
at com.catalogcity.amos_app_server.common.http_server.http_socket_runner.process_command(http_socket_runner.java:562)
at com.catalogcity.amos_app_server.common.http_server.http_socket_runner.run(http_socket_runner.java:297)
at com.catalogcity.util.simple_thread_pool$thread_runner.run(simple_thread_pool.java:467)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.(Unknown Source)
at java.net.Socket.(Unknown Source)
at com.inet.tds.w.a(Unknown Source)
at com.inet.tds.w.a(Unknown Source)
at com.inet.tds.w.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Query:
SELECT top 1 NodeID, ParentID FROM fProductHierarchy LEFT JOIN ProdCategoriesExclusions ON ProdCategoriesExclusions.ProductCategoryID=fProductHierarchy.ProductCategoryID AND SyndicateHostNameID = ? WHERE fProductHierarchy.ProductCategoryID = ? AND ProdCategoriesExclusions.ProductCategoryID is NULL AND fProductHierarchy.Active=1 AND fProductHierarchy.ProductHierarchyID=? ORDER BY NodeID