Pooled RDBMS connection fails if RDBMS drops connection

[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.