Relational (SQL) database connections
Martini comes with the ability to connect to almost any Java Database Connectivity (JDBC) relational (SQL) database and execute SQL operations against it (provided the appropriate drivers are installed).
Database connections in Martini are also pooled, and can be configured to use XA transactions. Pools are easily configured in Martini using a simple and intuitive user interface, meaning you don't have to configure them by hand by editing files.
SQL operations performed against a database can be executed from Groovy, using the
Sql function class, or from Gloop, by using
Gloop SQL services.
Martini also includes a a dedicated Database perspective that can be used to inspect and maintain schemas, tables, and columns, as well as perform ad-hoc queries and see their results.
The sections below provide more information about relational database connections.