Info@ybm.support

ybm_logo_neu_2024

OUR SUPPORT HELPS INFORM YOURSELF IN THE WIKI CREATE A TICKET

Search

Central database – Change internal database type in BarcodeShipping

Normally, each BarcodeShipping client uses its own local JAVA database. You will find this database file in the working directory (.barcodeshipping) with the name “database.mv.db”.
If you would like to use a different database or set up a shared database for several clients, we will explain how to set this up here.
Create the database.conf file in the “conf” folder in the working directory.
This already exists in newer BCS versions (from mid-2024).
The following content should be stored in this file for the respective database type, whereby the underlined terms should be replaced by your own:

PostgreSQL

driver: „org.postgresql.Driver“
url: „jdbc:postgresql://**IP-Adresse**:**Port**/Databasename
username: DBUsername
password: Password
Example URL: url: “jdbc:postgresql://127.0.0.1:5433/barcodeshipping”

To use a PostgreSQL database, you must first download and install it. This is available for various systems, including Windows, Linux and Mac.
You can download the installation here:

https://www.postgresql.org/download/

Oracle

driver: „oracle.jdbc.OracleDriver“
url: “ jdbc:oracle:thin:@localhost:1521:Databasename
username: DBUsername
password: Password

SQL Server

driver: „com.microsoft.sqlserver.jdbc.SQLServerDriver“
url: “ jdbc:sqlserver://localhost;instance=SQLEXPRESS;databaseName=Databasename
username: DBUsername
password: Password