Creating the database

To avoid problems at a later stage, make sure you set your database to use a character encoding that is suitable for your language. The examples here will use utf-8. Please notice that 8-bit ASCII encoding is generally a poor choice and should be avoided. 
 

Oracle

You can use the graphical DBCA (Database Configuration Assistant) to create a database called 'portofinodb' or you can run the SQL commands manually as follows.

% sqlplus
CREATE USER username IDENTIFIED BY password;
CREATE DATABASE portofinodb NATIONAL CHARACTER SET utf8;
GRANT ALL PRIVILEGES TO username;

Microsoft SQL Server

You can use the graphical SQL Server Enterprise Manager to create a new database called 'portofinodb'.

IBM DB2

You can use the graphical DB2 Control Center (db2cc) to create a new database called 'portofinodb' or you can run the command line instructions as follows.

% db2
CREATE DATABASE portofinodb USING CODESET UTF-8 TERRITORY US PAGESIZE 32 k
UPDATE DB CFG FOR portofinodb USING APP_CTL_HEAP_SIZE 4000

PostgreSQL

You can use the graphical pgadmin tool to create a new database called 'portofinodb' or you can run the command line instructions as follows.

% psql
CREATE USER username WITH PASSWORD 'password';
CREATE DATABASE portofinodb WITH OWNER=username ENCODING='UTF8';

MySQL

You can use a graphical tool like MySQL Administrator, MySQL Query Browser or phpmyadmin to create two databases called 'model' and 'meta'. Or you can follow these command line instructions:

% mysql -uroot -p
SET CHARACTER SET 'UTF8';
SET sql_mode = 'ANSI';
CREATE DATABASE model CHARACTER SET "UTF8";
CREATE DATABASE meta CHARACTER SET "UTF8";

Create the application's user and grant it all privileges on the two databases:

grant all on model.* to username@localhost identified by 'password';
grant all on meta.* to username@localhost;
grant all on model.* to username@'%' identified by 'password';
grant all on meta.* to username@'%';

Apache Derby

With Derby there is no need to create the database upfront. If will be created automatically during the first connection if you specify the 'create=true' parameter. See basic configuration for more details.
 

---

Previous: Downloading Portofino 

Next: Installing the JDBC driver