David Gress
Member
I inherited a web app (delphi 7 DLL) that uses DOA to communicate with Oracle 8i and now 10g. I upgrade to DOA 4.0.7.
In looking at the code I've noticed that two of the exposed web service methods create a data module and within the module open an Oracle session then log on to the database.
My question is does this data module and the OracleSession have to be explicitly released(i.e. DataModule.OracleSession.Free then Datamodule.free)? Because neither is freed.
What are the implications of leaving this code as is? Will memory eventually fill with these objects. One of the issues with the app is that the server has to be rebooted periodically.
In looking at the code I've noticed that two of the exposed web service methods create a data module and within the module open an Oracle session then log on to the database.
My question is does this data module and the OracleSession have to be explicitly released(i.e. DataModule.OracleSession.Free then Datamodule.free)? Because neither is freed.
What are the implications of leaving this code as is? Will memory eventually fill with these objects. One of the issues with the app is that the server has to be rebooted periodically.
