An application that is working with Delphi 5 and DOA Ver. 3.4.6.1 doesn't work with Ver. 4.05 thus the following:
I have a RemoteDataModule with a TSession.MaxStringFieldSize set to 0 in order to manage all string fiels as string rather than Memo. If you define persistent fields (on the server...
I changed TOracleSession.ThreadSafe := true and seems to be working fine, but under certain circumstances, when the RemoteDataModule is not loaded and several users connect at the same time it hangs.
------------------
Francisco Zapata C.
I don't know what you mean for a "thread safe manner".
basically we migrated an application working with TDataBase and TQuery to TOracleSession and TOracleDataSet, working with the same database.
------------------
Francisco Zapata C.
I have a 3 tier application, on the server side I have a TDataModule where I placed the TOracleSession; on the TRemoteDataModule I have TOracleDataSets and TOracleQuery, when several users generates some transactions simultaneouly the TOracleSession disconects and generates an "ORA-03113...
FYI
I am working with TOracleDataSet containing a LeftJoin sentence. In order to make a TClientDataSet Update the table, you have to include ROWID in your SELECT clause and change the TProvider.ResolveToDataSet property to true.
It is also important to make your updating table the first one...