15 5. Server configuration and management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5.1. User management . . . . . . . . . . . . . . . 29 6.1. Connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 6.1.1. Local connection strings . 29 6.1.2. TCP/IP connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 6.1.3. XNET connection strings. . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 7.7.2. Management Statements in PSQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 536 11.1. CURRENT_CONNECTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 577 13.2. SQL Statements for User Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

...... 14 Server configuration and management ................................................................................................... 15 User management: gsec ............................. ........................................................................................... 20 Connection strings ...................................................................................... Firebird 2.0 and 2.1 Quick Start 4 The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is per- mitted. The use of Firebird is governed

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 6. Limbo Transaction Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . database utility. • Shadow file handling. • Cache and buffer handling. • Transaction management. • Cache management. • Starting and stopping a database. • And much, much more … Chapter 1. Introduction Superserver versions of Firebird. In a Classic and SuperClassic Server installation, by default, each connection to the database gets its own relatively small cache of 256 pages (was 75 before Firebird 3.0)

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 371 9.1. CURRENT_CONNECTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 402 11.1.4. SQL Statements for User Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 402 11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 502 Using MON$ATTACHMENTS to Kill a Connection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 503

use if the number of connections is low. Single server process with a separate thread for each connection. Shared cache space. More efficient if the number of simultaneous connections grows. Permits fast of malfunctioning (by hack or otherwise). No Services Manager. Tasks like backup/ restore, user management, stats etc. have to be performed locally using the client tools (small separate executables) that Firebird. Features a Services Manager enabling you to perform certain tasks (backup/restore, user management, stats, etc.) programmatically. You can connect to the Services Manager over the network and thus

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 492 11.1. CURRENT_CONNECTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . die von Entwicklern für die Kommunikation ihrer Anwendungen mit dem Firebird Relation Database Management System benötigt werden. 1.1. Thema Das Kernthema dieses Dokuments ist die vollständige Implementierung Möglichkeiten zum Erstellen von Datenbanken. Jaybird stellt zum Beispiel die Klasse org.firebirdsql.management.FBManager bereit, um programmgesteuert eine Datenbank zu erstellen. Bei Bedarf können Sie jederzeit

........................................................... 366 Особенности пула подключений (Connection pooling) ............................... 367 Особенности пула транзакций (Transaction pooling) .................................................................................. 389 CURRENT_CONNECTION ............................................................................................ 389 password Пароль. Может быть строкой или переменной. role Роль. Может быть строкой или переменной. connection_string Строка соединения. Может быть строкой или переменной. filepath Путь к первичному файлу

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 8.1. Connection Strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 8.1.2. Legacy Connection Strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . bail on) -c(ache) number of cache buffers -ch(arset) connection charset (set names) -d(atabase) database name to put in script creation

управления пользователями CREATE USER ALTER USER DROP USER 11. Контекстные переменные CURRENT_CONNECTION 6 Руководство по языку SQL CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSACTION Зарезервированные слова, добавленные в Firebird: BIGINT BIT_LENGTH BOTH CASE CLOSE CONNECT CROSS CURRENT_CONNECTION CURRENT_ROLE CURRENT_TRANSACTION CURRENT_USER DISCONNECT FETCH GLOBAL INSENSITIVE LEADING LOWER MON$SERVER_PID, M_A.MON$REMOTE_PID FROM MON$ATTACHMENTS M_A WHERE M_A.MON$ATTACHMENT_ID = CURRENT_CONNECTION INTO :REMOTE_PROTOCOL, :APP_NAME, :SERVER_PID, :PC_PID; INSERT INTO USER_CONNECTED ( USER_LOGIN