Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAFirebird

Firebird - Connection

Firebird - Connection

Creates a connection to a Firebird database. Two connection modes are supported: local file (a .FDB file on the file system) or remote server (through host, port and database name). The ID of this action is used as a reference by the other Firebird actions in the flow — such as Firebird: Query and Firebird: Close connection.


Options​

Connection to use​

Select the Firebird connection previously registered in the workspace's Connections tab.

Time limits​

Optional fields that limit, in seconds, how long opening the connection and running its queries may take. Because Firebird cannot cancel a running query, when a query reaches its time limit (the connection default or the one set on the query itself), the connection is closed, its open transaction is rolled back and the action fails. In that case, a new connection must be opened: further queries on that connection fail immediately and closing it with Firebird: Close connection has no effect.

Connection timeout​

Maximum time, in seconds, the action waits for the Firebird server to accept the connection. The minimum value is 1. When empty, the operating system default applies. Optional field.

Default query timeout​

Maximum time, in seconds, of every query run on this connection, except queries that set their own limit in the Query timeout field of the Firebird: Query action. A value of 0 means no limit. When empty, there is no limit. Optional field.

Returns​

This action has no direct returns. Its ID is used as a reference by the other Firebird actions.

Rules and Conditions​

  • In Version 2.0, the Connection field is required and the connection must be configured beforehand in the workspace's Connections tab.
  • In Version 1.0, the Connection type field is required.
  • In Version 1.0, in Local file mode, the Database field is required and must point to a valid .FDB file.
  • In Version 1.0, in Remote server mode, the Host, Port and Database fields are required.
  • The database file must be reachable from the machine the robot runs on.
  • The fields of the Time limits group are optional and their values are in seconds.
  • The Connection timeout field accepts values from 1.
  • In the Default query timeout field, 0 means no limit.
  • When a query reaches the time limit, the connection is closed and a new connection must be opened.