id summary reporter owner description type status priority milestone component version severity resolution keywords cc external_id 825 Pooled RDBMS connection fails if RDBMS drops connection brucedechant brucedechant "Create a connection to any RDBMS: I used MySQL for example by previewing a Map to MySQL data. After seeing the data in the map, stop the RDBMS server, pause the VM or disconnect it in some way (ex: pulling network cable). Attempt to pan or zoom in the map and nothing happens. There may be an FDO timeout waiting to occur. Restart the RDBMS and refresh the map. An FDO error is generated indicating the connection to the RDBMS is invalid. For MySQL the error was as follows after pausing the VM: <2008-10-28T16:31:35> wilsond Error: Failed to stylize layer: calmysql5 montana ab30 An exception occurred in FDO component. RDBMS: MySQL server has gone away StackTrace: - MgMappingUtil.StylizeLayers line 776 file d:\buildforgeprojects\carrera_nightly\build_32.2\ent\os\server\src\services\mapping\MappingUtil.cpp Failed to stylize layer: calmysql5 montana ab30 An exception occurred in FDO component. RDBMS: MySQL server has gone away It appears that once the RDBMS has dropped the connection the server fails to drop the connection from the pool as it should realize the connection is invalid. The above also happens for Oracle and SQL Server. " defect closed medium 2.1 Feature Service 2.0.2 major fixed 1147707.01