What is Openbravo POS?
Openbravo POS is the leading open source Point-of-Sale (POS) application for SMEs in the retail industry. It has been designed specifically for touch screens in a range of retail-based businesses, from restaurants, to grocery stores and specialized retailers to department stores. Openbravo POS can be configured to work in any Point-of-Sale environment, creating a feature-rich solution. Openbravo POS and Openbravo ERP can work separately or together depending on user needs.
Feature:
- Assist customers better by using intuitive forms to manage sales quickly and efficiently
- Get closer to day-to-day business with up to date information for product sales, transactions, stock levels and more, all at your fingertips
- Streamline customer sales and returns with rapid access to accurate product and purchase information in every terminal
- Minimize the cost of a complex, full featured Point-of-Sale network by using an open source solution which is very easy to customize, runs on multiple computer platforms, and supports a large collection of POS hardware
- Share the peace of mind of companies worldwide that have already deployed Openbravo POS and are benefiting from these powerful features
- Because it was built with touch screens in mind, Openbravo POS is designed with particular focus on ease of use. This helps reducing the learning curve for operators while increasing their productivity, allowing staff to spend less time operating the Point-of-Sale and more time attending to customers.
- Openbravo POS offers all the rich functionality demanded by leading retailers. Highly flexible features and a wide range of configuration possibilities allow businesses of every shape and size to adopt Openbravo POS easily.
Openbravo POS supports a wide list of POS hardware including:
- Touch screens
- Bar code scanners
- Scales
- Receipt printers (Epson TM88iV, Star, Ithaca…)
- Customer displays (Epson LD110, L200…)
- Cash drawers
- Magnetic card readers
Open source
Openbravo POS is released under an open source license, with no hidden costs or ties to a particular vendor. This license ensures public access to source code and permissions to freely modify the source code with no usage fees.
Multi-platform
Fully developed in Java, Openbravo POS is 100% platform independent and runs in Windows, Linux, or Mac OS X.
If you want to know more about Openbravo POS please click here.
Integration with MySql:
Requirements:
- Openbravo POS
- JDK
- MySQL Connector/J JDBC driver for MySQL.
- MySql Server
Installation:
- First installed JDK and MySql Server
- Installed Openbravo POS
Configuration:
- Open Openbravo POS
- Enter with Administrator
- Click configuration from left menu
- Now configure Database
- Driver Library: Browse MySql connector i.e. E:\mysql-connector-java-5.0.8\mysql-connector-java-5.0.8-bin.jar
- Driver class i.e. com.mysql.jdbc.Driver
- URL: jdbc:mysql://localhost:3306/dbname
- User: MySql User
- Password: MySql Password (If empty leave blank)
- Click Save button and restart Openbravo POS system. Automatically MySql database will be created.
If any query don’t hesitate to inform me. I will try my best.
Is that all? Where is the terminal(say Magnetic card readers) attached? How the card from a super shop data will sent to Openbravo POS? Or Is Openbravo run in single matchine(no network support).
Where is the connectivity tools and what are the connecting media?
However, Seems to me straight forward configuration like Joomla what surely not. So let me know which part you found most tricky one?
Hello Aminul Islam
Thanks for your beautiful comments. Until i don’t try terminal but it will be same as other terminal integration system. Yes Openbravo POS run in single machine. But you may use same database from different machine. http://dev.mysql.com/downloads/connector/j/5.1.html here you can download MySQL Connector/J JDBC driver for MySQL, http://sourceforge.net/project/showfiles.php?group_id=127939 this links for Openbravo POS download and http://java.sun.com/ here you found JDK.
Hie Guys
Am getting stuck a bit on the Mysl DB, am getting an error:
Danger: Cannot Connect to database. Database not available.
(And clicking Information reveals :
Unknown database openbravopos-db)
The URL jdbc:mysql://localhost:3306/openbravopos-db must point to an existing database called openbravopos-db on mysql server. Now, the slight problem i had is i had used the default hbsql in memory database setup which is setup by default the very first time you use the application. I know the solution somehow has to do with exporting my database from hbsql and recreating it and importing data to mysql
Got a bit stuck here, could you help please
GOT It guys, never mind
Whats happening here is:
When you run OpenBravoPos the first time you download the software without touching anything, it uses the HSqlDB in memory database, so on the first run DON’t fight it !!!!, it will alert you “There is No database etc, one will be created etc”. Simply select Yes for it to use the HSqlDB, DON’t worry at this stage, we just want it to run so that we will later click on the Configuration button and reconfigure it to use MYSQL database as pointed out by author above. After it has run, click the Conguration button, this will take you to a screen were you now redirect your application to use a MySQL database.
Follow the configuration screen instructions as above author, The only trick is that the dbname you use MUST be an already existing database, so just create a New database in MySQL (on the mysql command line enter: create database openbravopos;) which will be simply empty, thats okay, because there are inbuilt scripts in the openbravopos\src-pos\com\openbravo\pos\scripts directory to create all the tables for you. ALso make sure the user you use in the configuration screen, is also an already existing user with rights to create database tables, i simply use root user here to avoid headaches.
Click Save and Close down the WHOLE application and restart it. Please be aware that once you restart Openbravo POS, 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 Openbravo POS to create the tables for you and VOILA !!!!
Hope it helps
Thank you so much to this website and most particulary, the last comment posted. You’ve sorted out my headache that I have had with this software for the last 7 days!!! thank you so much!!!
Ngoni Munyikwa
what did you place in the driver class?
i get stuck with the same warning
thanks
Ngoni Munyikwa
No need… was able to pass through
many thanks!
hello, i have a little problem with ubuntu and openbravo pos. i got stuck when i tried to set up the mysql database with the mysql-administrator! could u please explain me how to do it???
thanx ralf
Hello!
I’m getting the error with text: ‘near ‘CASCADE FROM TAXES ORDER BY NAME’ at line 1′, I think this is because the field name CASCADE is recognized as a reserved word for mysql, if somebody can help me I will send you a Corona beer from Mexico jeje.
Ok, I had found the error. In the line 135 of the file DataLogicSales.java there is a sql query: SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, CASCADE FROM TAXES ORDER BY NAME
but it must be: SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, TAXES.CASCADE FROM TAXES ORDER BY NAME
with the TAXES.CASCADE to instruct mySql to recognize CASCADE as the name of the field and no as a reserved word.
Thanks anyway.
If Openbravo POS can be only run on an single machine, but the database could be use in different machine. The Problem is can you change product price, add product in every computer that is connect to that database or just the main computer where the database is in.
Hello Jay
We may connect one openbravo database from different machine. We need just support remote database support. And also we can change product price and other data from different computer that are connected a single db. We don’t think where is my database, even it have no problem if database machine have no openbravopos installed.
রানা
i use openbravoPOS on windows xp and it always alert cannot connect to database.
com.openbravo.basic.BasicException:
Cannot connect to database. Database not available.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
Incorrect database name ‘openbravopos ‘
jdbc installed and configured
mysql database openbravopos created
please help
Have you create database name ‘openbravopos ‘ before install Openbravo? Make sure your mysql server is ok. I think you something missing. I can give you remote support if you want. Please mail me at ‘rana_0036@yahoo.com’ and subject like ‘Openbravo remote support’. I will try my best for your solution.
Thanks and Regards
Rana
it’s error ‘com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too long; max key length is 1024 bytes’ now.
here is detail
warning: creation script not runnedsuccesfully
com.openbravo.basic.BasicException:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too long; max key length is 1024 bytes
com.openbravo.basic.BasicException:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too long; max key length is 1024 bytes
my sql version is 5.0.15
Hi, pls could you help us with this:
we need to verify that it can not be possible to sell more products that there are in warehouse, for example: if there are 100 units of product a, and someone want to buy 110 units, the software must be send a message to the user showing that the transaction is out of existences.
thanks for your help,
Maria
Hi Maria
Currently i am not developing openvravo pos. If you feel interest to develop openvravo pos i will help you.
Until this feature dosent provide Openbravo company although its a basic requirement. Its a open source java software. So you may modify it. If you success please don’t forget to inform me.
Thanks and Regards
Rana
Hello, I create and publish ER diagram for Openbravo POS 2.20
See and use.
Link http://forge.openbravo.com/plugins/espforum/view.php?group_id=101&forumid=434920&topicid=6994625
Hi
I need small help.
How to change default warehouse
Thanks in advance
please can you help to conect xp as client to openbravopos on debian server ?
Hi, Can anyone suggest me how to go about and what are the java files to change, if I have my own db (with tables created)to work on Mysql for Openbravo POS?