Serious problem with sessions.

[KingOrmon]

Hello Farshad,

 

I have a serious problem with sessions. I am noticed that TDataSet created in mainmodule are sharing by different sessions.

 

Causing a data contamination from other user/sessions.

 

For each TDataSet on mainmodule I need a different session.

 

 

Could you tell about this ¿?

 

 

 

[Farshad Mohajeri]

A TDateSet placed on mainModule is never shared among sessions.

When you put it on MainModule for each session a new copy is created.

[Farshad Mohajeri]

Of course, same data will be shared because all of your Datasets are pointing to same database table.

[Farshad Mohajeri]

What do you mean by "data contamination"?

[KingOrmon]

Data contamination from other user tables.

 

It is a big database divided in various schemas

 

data contamination refers for example

 

using schema1.Customers retrieves data from schema2.Customers

[KingOrmon]

how can I force clean session always when page load / reload ?

[Farshad Mohajeri]

What is schema1? A database?

[ZigZig]

Dear KingOrmon,

 

IMHO, that is more a question of cursor location or lock type on your DataSet, than a "serious problem with Sessions".

[KingOrmon]

The problem could be fastreport fsGlobalUnit, it is shared ? o created new with each session ?

[Farshad Mohajeri]

What is the exact issue you are experiencing with your data tables?

[KingOrmon]

Sorry, the problem I think that is in fscript using global var fsGlobalUnit.

 

It contains a reference of all dataset in main module.

 

fsGlobalUnit is created once, I believe... then DataSets are sharing into diferent sessions.

 

  for i := 0 to ComponentCount - 1 do

      if Components.ClassNameIs('TADQuery') then

        fsGlobalUnit.AddObject(Components.Name, TADQuery(Components));

[ZigZig]

Where does this script run? I mean: in which unit is this for-loop ?

[Sherzod]

Hi KingOrmon.

Create and use the unit DataModule for DataSets ...

 

Sorry if I do not understand the question.

Best regards.

[KingOrmon]

on mainmodule.create runs

[ZigZig]

OK so if I understand your code, fsGlobalUnit is a global variable created on ServerModule and shared into each MainModule session.  Is it right?

[KingOrmon]

fsGlobalUnit is fast-report global var for scripting.

 

it is created when you use fsGlobalUnit()

[ZigZig]

if fsGlobalUnit is not a session variable, maybe you should rename this topic... There is no problem at all with sessions!

[Farshad Mohajeri]

It seems that FastReports keeps a global cache for datasets. There must be a way to disable it.

[KingOrmon]

solved without use fsGlobalUnit

[Farshad Mohajeri]

great.