[mapguide][MG407][Modified] Connection pooling causes joins to fail

[Ronnie Louie]

You can view the artifact detail at the following URL:

    https://mapguide.osgeo.org/servlets/Scarab/id/MG407

Type:
Defect

Artifact ID:
MG407 (Connection pooling causes joins to fail)

Modified by:
Ronnie Louie
ronnielouie (ronnie.louie at autodesk.com)

The following modifications were made to this artifact:
---------------------------------------------------------------------

-- Build set to new value:
178.56
-- External ID changed:
Old value:
832470 
New value:
832470, 832724
-- Resolution Description set to new value:
When connection pooling is enabled, the join code was attempting to obtain the connection from the pool and pass it to the join engine.  When finished, the join code closed the connection, but it still remained in the pool.  When obtaining the connection again, it is able to grab it, but since it is closed, it results in the connection error.  The solution is to prevent the join code from closing the connection since it should be managed by the pool instead.  Also, as a failover the FdoConnectionManager is modified to check for an open connection before retrieving it from the pool.

This submission also fixes a related defect where server would crash when previewing layers consisting of a join.  Problem was that DescribeSchema was not returning a correct schema for the feature source, when lead to a null pointer when interrogating the class definition for the extension.



---------------------------------------------------------------------
This message was automatically generated by Project Tracker.