RVcamRecorder drops connection to SQL server

RVMedia support and discussion (components for displaying and controlling IP cameras, webcams, video conferencing, video chats, recording audio and video files)
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: 14729
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