Error Executing Database Query.
|
Data source rejected establishment of connection, message from server: "Too many connections"
|
|
The error occurred in C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 45
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 2
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 1
Called from C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm: line 11
|
43 : <cfelse>
44 : <CFQUERY NAME="GetHomes" DATASOURCE="IDX">
45 : SELECT mls,address,streetnumber,StreetDirection,StreetName,StreetSuffix,City,PostOffice,State,ZIP,County,AgentName,AgentPhone,AgentEmail,AgentID,OfficeName,OfficeID,LastUpdate,Price,Status,SchoolDistrict,Subdivision,Acres,LotDimensions,LakeName,YearBuilt,PropertyType,Style,Basement,Garage,SqFeet,Bedrooms,Bathrooms,FullBaths,HalfBaths,Fireplaces,Bedroom1Dim,Bedroom2Dim,Bedroom3Dim,Bedroom4Dim,DiningRoomDim,LivingRoomDim,FamilyRoomDim,KitchenDimensions,EstWinterTaxes,EstSummerTaxes,PublicRemarks,Vtour,Latitude,Longitude,Appliances,Cooling,Exterior,Heating,ListDate,GovtOwnership,DisplayAddress,BasementDesc,GarageDesc,FireplacesDesc,PhotoCount,Waterfront,WaterDesc,Fuel,Waste,PoleBldgs,ExteriorMisc,Electronics,WaterSource,HomeWarranty,OuterBldgs,PavedRoad,Construction,TaxID,LegalDesc,Lease_Sale,GreatRoomDim,Foundation,OriginalPrice,Directions,HOA_Fee,HOA_FeePeriod,OriginatingMLS,OriginalMLSNum,If(#MLS_FieldName# LIKE '#MLS_Office_Identifier#%',1,99) AS Broker_Order FROM #mls_id#homes WHERE MLS = '#MLS#'
46 : </CFQUERY>
47 : <cfinclude template="/includes/statlistingviews.cfm">
|
|
SQL |
SELECT mls,address,streetnumber,StreetDirection,StreetName,StreetSuffix,City,PostOffice,State,ZIP,County,AgentName,AgentPhone,AgentEmail,AgentID,OfficeName,OfficeID,LastUpdate,Price,Status,SchoolDistrict,Subdivision,Acres,LotDimensions,LakeName,YearBuilt,PropertyType,Style,Basement,Garage,SqFeet,Bedrooms,Bathrooms,FullBaths,HalfBaths,Fireplaces,Bedroom1Dim,Bedroom2Dim,Bedroom3Dim,Bedroom4Dim,DiningRoomDim,LivingRoomDim,FamilyRoomDim,KitchenDimensions,EstWinterTaxes,EstSummerTaxes,PublicRemarks,Vtour,Latitude,Longitude,Appliances,Cooling,Exterior,Heating,ListDate,GovtOwnership,DisplayAddress,BasementDesc,GarageDesc,FireplacesDesc,PhotoCount,Waterfront,WaterDesc,Fuel,Waste,PoleBldgs,ExteriorMisc,Electronics,WaterSource,HomeWarranty,OuterBldgs,PavedRoad,Construction,TaxID,LegalDesc,Lease_Sale,GreatRoomDim,Foundation,OriginalPrice,Directions,HOA_Fee,HOA_FeePeriod,OriginatingMLS,OriginalMLSNum,If(officeID LIKE '399499,399501,373446,349839%',1,99) AS Broker_Order FROM ecarhomes WHERE MLS = 'rcomi60326267'
|
DATASOURCE |
IDX |
VENDORERRORCODE |
1040 |
SQLSTATE |
08004 |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.225.95.245 |
Referrer |
|
Date/Time |
27-Sep-24 05:34 PM |
|
Stack Trace
|
at cfview2ecfm530345731._factor5(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:45) at cfview2ecfm530345731._factor33(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:2) at cfview2ecfm530345731.runPage(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:1) at cfquery_redirect2ecfm887604138.runPage(C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm:11)
java.sql.SQLException: Data source rejected establishment of connection, message from server: "Too many connections"
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1018)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2568)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.lang.Thread.run(Thread.java:534)
|
|