EzyPOS Software Installation Guide

Posted on October 7, 2012 by admin


Software installation

Install Java

EzyPOS / Openbravo POS is an application developed in Java and to execute it you will need the Sun Java Runtime Environment (JRE) 1.6 or greater.

On Windows

 You can install Java from Sun’s website.

On Ubuntu

To install java in Ubuntu make sure to have the multiverse and restricted repositories activated. To do this you can add the following lines to the /etc/apt/sources.list file:

deb http://za.archive.ubuntu.com/ubuntu/ intrepid main restricted
deb http://za.archive.ubuntu.com/ubuntu/ intrepid multiverse

Where intrepid is the Ubuntu version you have installed. And after modified you have to update your repository executing:

sudo apt-get update

And to install java execute

sudo apt-get install sun-java6-jre sun-java6-fonts

You can also add the multiverse repository using the system tool Software sources, and install the java packages using the Synaptic package manager.

To verify that the correct version of java is installed the following command can be used:

java -version

If you have more than one java environment installed in your machine you need to select the Sun java runtime environment (JRE) 1.6 or greater. The following command can be used to list the available java versions:

update-java-alternatives -l

And to change from one version to another, the following command can be used:

sudo update-java-alternatives -s

Download and install EzyPOS

Download the latest version from http://www.ezypos.net.au

The download ZIP file opened with your favourite de compressor contains EzyPOS executable file, Sample MySQL database, sample.properties file, Instruction/Links for user manuals.

Run it!

The first time EzyPOS starts and there isn’t a database, it display a warning alerting that it has found an empty database. If you click OK, EzyPOS will create for you the Apache derby database structure necessary to run.

On Windows


Go to C:/EzyPOS folder for decompressed files.

On Linux


Go to /EzyPOS folder for decompressed files.

Generally extract the ZIP contents to EzyPOS folder and place it on root level.

Database installation

Once EzyPOS is installed you should decide whether you want to run EzyPOS on the built-in engine or on any of the other database engines supported. EzyPOS supports five database engines: Apache Derby,MySQLPostgreSQLOracle and HSQLDB.

EzyPOS by default Apache Derby for data storage. Apache Derby is bundled with the binary package of EzyPOS and offers the advantage that it doesn’t have to be configured, and it is reliable and robust enough for most requirements.

Apache Derby

EzyPOS is distributed with the embedded library of Apache Derby so if you plan to use Apache Derby in embedded mode you do not need to download or install anything. But if you want to use Apache Derby in client/server mode you need to download and install the full distribution of Apache Derby available from the Apache Derby web site

Derby is called javadb by Sun, and is included in Ubuntu from 7.04 onwards.

sudo apt-get install sun-java6-javadb

To test access with the Derby command line client

cd /usr/lib/jvm/java-6-sun/db/bin
export DERBY_HOME=/usr/lib/jvm/java-6-sun/db/bin
connect 'jdbc:derby:/home/myuser/openbravopos-database;create=true';
show tables;
select * from resources;

An example of a database configuration using Apache Derby as database engine in embedded mode is:

Driver library: derby.jar
Driver class: org.apache.derby.jdbc.EmbeddedDriver
URL: jdbc:derby:/home/myuser/openbravopos-database;create=true
User: yourname
Password: yourpass

And in client / server mode:

Driver library: derbyclient.jar
Driver class: org.apache.derby.jdbc.ClientDriver
URL: jdbc:derby://localhost:1527/openbravopos-database;create=true
User: yourname
Password: yourpass


On Windows

Download MySQL server (essentials package recommended) and install it.

Download MySQL Connector/J, unzip the contents and place it in the same folder where EzyPOS resides. This already available on your ZIP contents.

Alternatively you can install MySQL Administrator and MySQL Query Browser MySQL GUI Tools Downloads. Also, third party applications such as ‘XAMPP’ is also a quick and easy solution.

On Ubuntu

 Activate the universe repository and run following commands in a terminal:

sudo apt-get install mysql-server libmysql-java

You can also install MySQL Administrator and MySQL Query Browser:

sudo apt-get install mysql-admin mysql-query-browser

Connector/J is on /usr/share/java/mysql.jar. You can copy or link it to EzyPOS’ folder.


Create an user and a database.

You can check MySQL documentation.

An example of a database configuration using MySQL as database engine is:

Driver library: mysql-connector-java-3.1.6-bin.jar
Driver class: com.mysql.jdbc.Driver
URL: jdbc:mysql://localhost:3306/ezypos
User: yourname
Password: yourpass

Note: if you copy/paste these values, make sure you do not have a blank space at the end of each string, i.e. “com.mysql.jdbc.Driver “, this will cause an error when executing Openbravo.


To use EzyPOS with PostgreSQL you must have a PostgreSQL server running and the JDBC driver for PostgreSQL.

On Windows

Download the server PostgreSQL download and install it.

Download the JDBC driver PostgreSQL JDBC Driver according to your version and install it.

You can also install the PosgreSQL administration tool pgAdminIII.

On Ubuntu

Ensure you have the universe repository activated and run following commands in a terminal:

sudo apt-get install postgresql-8.2 libpg-java

You can also install the administrator tool pgAdmin3:

sudo apt-get install pgadmin3

The JDBC lib is on /usr/share/java/postgresql.jar. You can copy or link it to EzyPOS’ folder.


After the database server is installed and running you have to create an empty database for EzyPOS and a database user with privileges to connect to this database. You can check PostgreSQL documentation.

An example of a database configuration using PostgreSQL as database engine is:

Driver library: /usr/share/java/postgresql-8.0.309.jdbc3.jar
Driver class: org.postgresql.Driver
URL: jdbc:postgresql://localhost:5432/ezyopos
User youruser
Password: youpass


To configure EzyPOS go to the configuration panel. Please be aware that once you restart EzyPOS, it will tell you that your database is empty and will offer you to create tables for your new database. Click the yes button to allow EzyPOS to create the tables for you

Database configuration

Openbravo POS configuration.

EzyPOS configuration.

The properties related to the database configuration are:

Driver library
Is the file provided by the database engine vendor that contains the JDBC driver that allows Java programs to communicate with the database. It’s usually a file with extension .jar.
Driver class
Is the java class name that implements the JDBC driver. This name is also defined by the database engine vendor.
Is the connection string that uses JDBC to localize the JDBC the driver and the database.
The name of the authorized database user.
The password of the database user.


Cash register

 Openbravo POS configuration

EzyPOS configuration

The properties related to the register cash panel are:

is the name of the cashier.
provides a few themes which change the look of EzyPOS.
sets if the application should be in a fullscreen or just in window mode.
sets in which mode EzyPOS works. At the present day the following : are available:
simple, standard or restaurant.
Customer Display
sets the way how a customer should see the last ordered item.
is the main printer.
is an additional printer that could print something additional i.e. an
order in a kitchen or in a bar.
is an additional printer that could print something additional i.e. an
order in a kitchen or in a bar.
sets scales to weigh products.
sets a barcode scanner to read barcodes.
Reports Printer
is a printer that prints reports.
Receipt printer
this box must be checked if the Reports Printers is a receipt printer


Here the language of the application is defined. You can define a format of the values displayed like dates, currencies, numbers…

Openbravo POS configuration

EzyPOS configuration


You select the language and the country of the application. This selection determines also the default format for currency values and the currency symbol, the default format for dates, times and numeric values.
Integer, Double, Currency, Percent, Date, Time and Date time
Here you can overwrite the default type format for each value type defined by the selected Locale. This pattern format follows the specification of the Java platform.