package AdaBase is
   subtype Posix_Port is Natural range 0 .. 65535;
end AdaBase;

AdaBase.Driver.Base.[DB].basic_connect (database, username : String := "", password : String := "", hostname : String := ""; port : PosixPort)

This procedure initiates a persistent connection to the database server. The connection can be explicitly closed using the disconnect procedure, and it will be automatically closed if the driver object is destroyed. Attempting to open a connecton when one is already open will be ignored and the attempt logged. All connection failures will also be logged, followed by an exception which cannot be ignored. The first of these two overloaded procedures connects with a TCP/IP port and a hostname

AdaBase.Driver.Base.[DB].basic_connect (database, username : String := "", password : String := "", socket : String := "")

The second version supports connecting over a UNIX socket, but this setting is optional. The only required entry is the database name (which is a file location for SQLite), although setting all the entries are normally required for drivers that interact with true servers.

--  Used for all testcases for MySQL driver
--  DR is a variable of type AdaBase.Driver.Base.MySQL.MySQL_Driver

package body Connect is

   procedure connect_database is
      DR.basic_connect (database => "adabase_examples",
                        username => "root",
                        password => "",
                        hostname => "localhost",
                        port     => 3306);
   end connect_database;

end Connect;

See execute (driver) for a usage example coupled with code above.

[DB] is "MySQL.MySQL_Driver", "PostgreSQL.PostgreSQL_Driver", or "SQLite.SQLite_Driver"

See Also