RVcamRecorder drops connection to SQL server

New product: VCL components for displaying and controlling IP cameras, webcams, video conferencing, video chats
Post Reply
lucas
Posts: 3
Joined: Tue Sep 18, 2018 1:04 pm

RVcamRecorder drops connection to SQL server

Post by lucas » Tue Sep 18, 2018 1:17 pm

Hello

I'm testing the RVCamRecorder component and detected a problem that appears to be a bug.

In all tests performed, after completing the recording of a video (Rvcamrecorder.Active: = true), the component disconnects the connection to the SQL server.

This was detected even in the VideoRecorder example, where a simple query was inserted into a database on the Start button.

Has anyone ever come across this kind of problem?

Delphi Tokyo
SQL Server 2012
TRVmedia 5.3

Sergey Tkachenko
Site Admin
Posts: 14163
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: RVcamRecorder drops connection to SQL server

Post by Sergey Tkachenko » Tue Sep 18, 2018 3:50 pm

Sorry, I do not understand how video recording may affect a database connection.
Maybe you can create a simple project that reproduces the problem?

lucas
Posts: 3
Joined: Tue Sep 18, 2018 1:04 pm

Re: RVcamRecorder drops connection to SQL server

Post by lucas » Tue Sep 18, 2018 6:14 pm

Hi,

Use the VideoRecorder demo and insert into the OnClick of the "Start Recording" button a simple query to any SQL server database (using ADO).

example:
   Query.Close;
   Query.CommandText: = 'select * from test';
   Query.open;


On the first run you will succeed, the next (ie after running RVCamrecorder.active true / false), will give a connection error.

att,

lucas
Posts: 3
Joined: Tue Sep 18, 2018 1:04 pm

Re: RVcamRecorder drops connection to SQL server

Post by lucas » Tue Sep 18, 2018 7:08 pm

Executable RVcamRecorder with the insertion of a simple query on the Start Recording button.

  try
      ADOConnection.Connected: = false;
      ADOConnection.Connected: = true;
      Query.Close;
      Query.CommandText: = 'select * from group';
      Query.open;
      Showmessage ('First run. The connection is ok and the query runs normally.');
   except on E: exception
     begin
        Showmessage ('after RVcamrecorder.active true / false, the connection fails and the query is not performed. Error returned =' + e.message);
        exit;
     end;


   end;

a) Click on start recorder
b) After a few seconds click on stop
c) click start again.

I was unable to attach the demo application. Although small (1.1mb), the page informs that the file exceeds the allowed size.

Post Reply