Database connectivity

Multiple connections

Connect to as many databases as you like and present information retrieved from different databases in a unified way.

For example, connect to a crm, to a products database, to an inventory system and create an application that works seamlessly across these databases. Access live data anywhere, say goodbye to data duplication. 

Supported databases

Portofino supports a good range of commercial and open source database technologies.

It automatically detects which drivers are available on the classpath: find out what is missing at a glance.

Persistence with Hibernate

Portofino uses Hibernate as its data access and persistence layer.

It extracts the metadata from the databases and automatically sets up the object-relational mappings for you.

Start using Hibernate sessions immediately in your code.

Creating new connection providers

To create a new connection provider simply provide this information: a database name (of your choice), the JDBC driver, the connection URL, the username and the password.

Detected values

If a connection is successful, some information will be displayed. Most notably: the database and driver type and version.

Connection status

At any time you can check the status of a database connection. Any problems encountered (missing driver, network error, missing privileges, etc) are highlighted.

Portofino handles transient connection errors gracefully: if a database goes down (for any reason) and comes back again, Portofino will reconnect automatically.

Liquibase

With Liquibase, changes to your database can be applied across all environments (development, testing and production) in a managed way. Liquibase is the ideal tool for incremental schema development and database refactoring.

Portofino supports and executes Liquibase scripts.