Session Pooling

[jedaworks]

Am using session pooling = spInternal on a isapi dll.

The oracleConnection is set Connected := true in the "before dispatch" and := false in the "after dispatch" methods.

Occassionally, the database connection is dropped (the database server is rebooted and then comes back online. The isapi dll errors out after that (no database connection when trying to query). Is there some way to get the session pool connections to reconnect?

I've tried SessionPool.Compress if the query errors, but this does not help.

 

[jedaworks]

My mistake, the WebModuleAfterDispatch method was never being called, therefor the OracleConnection was never being disconnected.

Problem was fixed when I diconnected the connection in the Action.onAction event.