Running advanced BRAVA

[mobreza]

There's little documentation on how to configure BRAVA to use a database.

# H2 Username, password and path
dbuser=
dbpass=
dbpath=

• Please update the config.properties.example for a HSQL or mysql database (with all properties that control the setup, including a sample connect string)
• How to initialize the database model and any initial data? Genesys uses liquibase for DB schema management. Are database model changes handled in current implementation?

[langeipk]

Hi, we use a ORACLE DB to host the BRAVA database. Below you find a example config for this databae. The difference to MYSQL or H2 are the JDBC connect string in property dbpath. Please have a lock to MYSQL documentation

Database model changes in the database is not supported. The creation of database table is performed by servlet initialization. If the expected tables does not existing, they are created in Class DataSourceManager. We use ormlite as object relational mapping and tested it for H2 and ORACLE. But MySQL should work as well.

-------- example config for ORACLE backend DB ----- dbuser= dbpass= advancedMode=true dbpath=jdbc:oracle:thin:@ipkoraclehost.ipk-gatersleben.de:1521/ipkoracleservice http.proxyHost=proxy_xyz.ipk-gatersleben.de http.proxyPort=3128 https.proxyHost=proxy_xyz.ipk-gatersleben.de https.proxyPort=3128 adminkey=xxx mailSmtpHost=imapserver.ipk-gatersleben.de fromEmailAddress=noreply@ipk-gatersleben.de fromPersonalName=noreply@ipk-gatersleben.de senderName=Martin Basterrechea - BrAVa developer at IPK-Gatersleben contactEmail=basterrechea@ipk-gatersleben.de baseDomain=http://webapps.ipk-gatersleben.de/brapivalidator resourceJsonUrl=https://raw.githubusercontent.com/plantbreeding/API/master/brapi-resources.json testedVersion=v1.2

[langeipk]

solved in commit 5487d3abbde3e7ff9189bdb284c7c261010a5d9f