Error Occurred While Processing Request
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver]Connection reset
 
The error occurred in /usr/local/www/www.nypl.org/branch/central/location_data.cfm: line 5
 
3 : 	SELECT loc.location_id, loc.location_name, loc.location_phone, loc.location_address, loc.location_zip, loc.location_handicapped_access, loc.location_email, loc.location_xstreet, loc.location_tty
4 : 	FROM locations loc
5 : 	WHERE loc.location_branch_flag = 1 AND loc.location_id = #loc_id#;
6 : 	</cfquery>
7 : 	<cfoutput query="location_data">
SQL    SELECT loc.location_id, loc.location_name, loc.location_phone, loc.location_address, loc.location_zip, loc.location_handicapped_access, loc.location_email, loc.location_xstreet, loc.location_tty FROM locations loc WHERE loc.location_branch_flag = 1 AND loc.location_id = 121;
DATASOURCE   locations
SQLSTATE   08S01
Please try the following:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.103.63.61
Referrer  
Date/Time   28-Aug-08 03:15 AM
Stack Trace
at cflocation_data2ecfm2103237840.runPage(/usr/local/www/www.nypl.org/branch/central/location_data.cfm:5) at cflocation_data2ecfm2103237840.runPage(/usr/local/www/www.nypl.org/branch/central/location_data.cfm:5) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Connection reset
	at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSExecuteRequest.submitRequest(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.execute(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
	at coldfusion.sql.Executive.executeQuery(Executive.java:974)
	at coldfusion.sql.Executive.executeQuery(Executive.java:886)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:233)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
	at cflocation_data2ecfm2103237840.runPage(/usr/local/www/www.nypl.org/branch/central/location_data.cfm:5)
	at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:105)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Hours:

Mon Tue Wed Thu Fri Sat Sun
9-9
 9-9
 9-9
 10-6
 10-6
 10-6
 1-5
NOTE: Beginning June 1! Mid-Manhattan Library will open on Sundays from 1 p.m. to 5 p.m. (The Picture Collection will be closed on Sundays. All other collections will be open for service.)
The NYPL will be closed
Saturday, 8/30 — Monday, 9/1 for Labor Day

Subway

AC to 42nd Street and Eighth Avenue. Take the 40th Street exit and walk four blocks east to Fifth Avenue. Cross Fifth Avenue to get to the southeast corner.

BDFV to 42nd Street and Sixth Avenue. Take the 40th Street exit and walk one block east to Fifth Avenue. Cross Fifth Avenue to get to the southeast corner.

NRW to Times Square. Take the 40th Street exit and walk three blocks east to Fifth Avenue. Cross Fifth Avenue to get to the southeast corner.

123to 42nd Street and Broadway. Take the 40th Street exit and walk four blocks east to Fifth Avenue. Cross Fifth Avenue to get to the southeast corner.

456to Grand Central Station. Walk two blocks west to Fifth Avenue and two blocks south to 40th Street. Cross 40th Street to get to the southeast corner.

7 to Fifth Avenue. Walk two blocks south to get to 40th Street. Cross 40th Street and Fifth Avenue to get to the southeast corner.

The closest stops are the 7 at Fifth Avenue and the B,D,F,V at 42nd Street and 6th Avenue.

Of the nearby subway stops, only Grand Central is wheelchair accessible.

Bus