Transaction is not active (datasnap)

Remoting SDK
1

Hi,
I’ve a basic datasnap server / client with Remobjects Datasnap module.
Everything seems working normal till try to update some data.
I edit data from client and post it. After that I need to applyupdates(-1); to apply updates to server but I got:
An exception was raised on the server: One of the connections in the transaction is not active.

I’m using SDAC (latest) with RO SDK (latest) as server.
I googled for the exception but can’t find any hint or solution or same problem on the internet.

Thanks for your helps.

2

It’s probably about SDAC, when I replace the components from SDAC to ADO, runs without any problems. I’m writing down situation to Devart.

Thanks

3

Hello,

I can’t reproduce your error with SDAC components. Tested with DataSnap sample from RemObjects SDK for Delphi samples, ADO components was replaced by SDAC components on DataSnapServerDataForm.

Could you send your testcase please?

Best regards.

4

Hi elenap,
I’d send it to support[at]remobjects[dot]com

5

Hi,
Andrey from devart(SDAC) answered the question and said issue related to remobjects, please read: http://www.devart.com/forums/viewtopic.php?t=23171

Waiting for your answers…

6

From Andrey’s response it sounds like you may need to change your class factory to per-client instead of the default (which creates and destroys the module for each call).

7
From Andrey's response it sounds like you may need to change your class factory to per-client instead of the default (which creates and destroys the module for each call).

Thanks for your answer nwoolls,
can you tell how can I do this?

8

Change in initialization section of _Impl unit class for class factory:

in something like

initialization
{$IFDEF LCL}
  {$I NewService_Impl.lrs}
{$ENDIF}
  fClassFactory := TROClassFactory.Create('NewService', {$IFDEF FPC}@{$ENDIF}Create_NewService, TNewService_Invoker);

Change TROClassFactory to TROPerClientClassFactory.

9

There’s a nice write-up of the different class factories and how they work here:

http://wiki.remobjects.com/wiki/Class_Factories

10

Thanks slavad and nwoolls,
Changing:

TROClassFactory.Create(‘TestInterface’, Create_DataSnapModule, TAppServer_Invoker);

to:

TROPerClientClassFactory.Create(‘TestInterface’, Create_DataSnapModule, TAppServer_Invoker, 60);

works without any problems.

11

Hello,

In order to use standard TROClassFactory do the following changes in Unit1.pas from your testproject:
…
{$R *.DFM}

var fROClassFactory:TROClassFactory; //ADDED

procedure Create_DataSnapModule(out oInstance:IUnknown);
begin
oInstance := TRODataSnapModule1.Create(nil);
end;

initialization
…
// CHANGED
fROClassFactory:=TROClassFactory.Create(‘TestInterface’, Create_DataSnapModule, TAppServer_Invoker);

// ADDED
finalization
UnregisterClassFactory(fROClassFactory);
end.

Best regards