Installing and configuring uniCenta oPOS to use MySQL

January 17th, 2012 | Posted by ChrisG in uniCenta oPOS

uniCenta oPOS is an open source Point of Sale (POS) application aimed as small retail businesses and restaurants. It is written in Java and can run on Windows, Mac or Linux. The default installation uses Apache Derby DB but it can be configured to use other databases such as MySQL, PostgreSQL and Oracle. This short post describes how to set uniCenta oPOS to use MySQL.

For setting up on Windows

  1. Download uniCenta oPOS from SourceForge. I used version 2.80 as it includes the mysql.jar.
  2. Before installing you’ll need to create a mySQL database and user for unicenta.
  3. Run the installation .exe for uniCenta
  4. Run uniCenta oPOS configuration and enter the following for the database information:
    - Driver Library: mysql.jar (You should find this in the uniCenta library directory)
    - Driver Class: com.mysql.jdbc.Driver
    - URL: com.mysql.jdbc.Driver
    - User: [user created in Step 2]
    - Password: [password used in Step 2]
  5. Run uniCenta oPOS. The first time you run the program it will create the default database
  6. Check that the mySQL database tables have been created.

If you need to get hold of the Java source code for uniCenta oPOS go to the uniCenta oPOS FAQ page and click the “Want the source code” link. You need to send them an email request.

You can follow any responses to this entry through the RSS 2.0 You can skip to the end and leave a response. Pinging is currently not allowed.

4 Responses

  • olivier says:

    hi i am tryung to do that but please could you do a step by step including the creation of that database?
    that would be great

  • ChrisG says:

    All you need to do is create an empty database and a database user that can access the database. If you’re new to mysql I’d suggest using phpmyadmin which is run as a web page from your web server. If you have cpanel for your website you will probably already have access to phpmyadmin or something similar. You can also use MySQL Workbench which runs from your computer as an application. Both of these are free.

    Once you have created an empty database and a user to access it (with full privileges), follow the instructions above – UniCenta will create the tables.

    There are heaps of websites that you can find through Google to describe how to create mysql DBs and DB users.

  • abubin says:

    your URL section doesn’t work with com.mysql.jdbc.Driver.

    I had to change it to jdbc:mysql://hostname:port/dbname for it to work.

  • CmH says:

    That’s great, thanks for the guide and thanks to abubin for the additional info!

Leave a Reply