WiseMapping supports a wide variety of databases. However, we run intensively tests over HSQL and MySQL database.
HyperSQL: It's automatically configure when you compile WiseMapping and it's used primarily for testing. Additionally, the binary distribution already has an instance configured to provide a single click installtion.
cd <WISEMAPPING-DIR>/config/database/mysql # Default MySQL installation creates a "root" user with empty password. You can connect to the database with this user if you are # logged in same machine where the database is installed and must be executed logged as "root" # # If you have changed the default database "root" password , you need to specify an additional -p parameter and provide the # new password. mysql -uroot < create-database.sql # Create tables and default tests user mysql -uwisemapping -Dwisemapping -ppassword < create-schemas.sql mysql -uwisemapping -Dwisemapping -ppassword < apopulate-schemas.sql |
Great, you have configured you database !. Let's configure WiseMapping now.
Next step, you must edit the file <WISEMAPING_DIR>/webapps/wisemapping/WEB-INF/app.properties and uncomment the MySQL configuration parameters and comment all HSQL configuration properties.
Done, you have configured WiseMapping to use MySQL!.
If you want to start WiseMapping right now, open a command line terminal within wisemapping-<version>
directory and execute
~:> java -Dorg.apache.jasper.compiler.disablejsr199=true -jar start.jar |
The application will be started on: http://localhost:8080/wisemapping/ . The database is automatically populated with a test user test@wisemapping.organd password test. |