uniCenta oPOS DB Diagrams

January 19th, 2012 | Posted by ChrisG in uniCenta oPOS - (0 Comments)

Database Diagrams for the open source POS software uniCenta oPOS
View diagram here

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.