mORMot Open Source

eraldo

Member

From: Brasil

Registered: 2010-07-22

Posts: 69

Website

Problem with function TSQLDBWinHTTPConnectionProperties.Execute

Hello ab,

Excuse me but there is a limitation or new parameter to limit the amount of records returned in a Select with this function?

I updated the sources and when a Select have to return more than 100 records an error occurs. When, for example, the result is only 10 records, running normal.

Thanks
Eraldo

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,230

Website

Re: Problem with function TSQLDBWinHTTPConnectionProperties.Execute

AFAIR there is no such limitation.

eraldo

Member

From: Brasil

Registered: 2010-07-22

Posts: 69

Website

Re: Problem with function TSQLDBWinHTTPConnectionProperties.Execute

Then there is a problem. All Select's with many records returned not work.

eraldo

Member

From: Brasil

Registered: 2010-07-22

Posts: 69

Website

Re: Problem with function TSQLDBWinHTTPConnectionProperties.Execute

Hello ab

Did you mean: Acredito ter descoberto o problema. Antes em SynDB: function TSQLDBProxyConnection Protocol.HandleInput(const input: RawByteString): RawByteString; begin result := input; end; now em SynDB: function TSQLDBRemoteConnection Protocol.HandleInput(const input: RawByteString): RawByteString; begin result := Input; SymmetricEncrypt(REMOTE_MAGIC,result); result := SynLZDecompress(result); end; Se o input for com length = 6000 funciona bem Se o input for com length = 10000 ocorre um erro na função SynLZDecompress(result);
I believe I have found the problem.

Before SynDB in:
TSQLDBProxyConnectionProtocol.HandleInput function (const input: RawByteString): RawByteString;
begin
   result: = input;
end;

now in SynDB:
TSQLDBRemoteConnectionProtocol.HandleInput function (const input: RawByteString): RawByteString;
begin
   result: = Input;
   SymmetricEncrypt (REMOTE_MAGIC, result);
   result: = SynLZDecompress (result);
end;

If the input for with length = 6000 works well
If the input for with length = 10000 an error occurs in SynLZDecompress function (result);

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,230

Website

Re: Problem with function TSQLDBWinHTTPConnectionProperties.Execute

There is no known size limitation in SynLZDecompress.
We use it to compress from small amount of data, to huge log files of more than 200 MB...

The problem was I suspect in SymmetricEncrypt().
Please try http://synopse.info/fossil/info/b35f7fc29d
It should now handle bigger buffers without any problem!

Sorry for the inconvenience.