1.2k questions

1.4k answers

361 comments

339 users

Categories

Sidebar
+1 vote
2.2K views
by gary-t-8719 (15.1k points)
What are the steps that need to be taken in migrating from a H2 Database to MariaDB?

1 Answer

+2 votes

NOTE: Be sure that all messages are processed and errors have been resolved in QIE.

1) Stop QIE in the Service Manager.

2) Install MariaDB Server
   
3) Configure the QIE Service Manager to connect to MariaDB
   Add the following Java Options in the Arguments on the Startup tab of the QIE Service Manager:
   -Dconnection.driver=org.mariadb.jdbc.Driver
   -Dconnection.url=jdbc:mariadb://{server}:{port, default=3306}/{database, default=qie}
   -Dhibernate.dialect=com.qvera.qie.persistence.MySQLUnicodeDialect
   -Dconnection.username=???
   -Dconnection.password=???
 
   Note: For more information about the above options refer to Configuring QIE with an Alternate Database Management System section in the QIE install guide.
by gary-t-8719 (15.1k points)
edited by michael-h-5027
by jon-t-6024 (560 points)
If you're doing this on Linux, you'll need to add backslashes ( \ ) to the end of each "-Dconnection" line.  For example:

        -Dconnection.driver=org.mariadb.jdbc.Driver \
        -Dconnection.url=jdbc:mariadb://{server}:{port, default=3306}/{database, default=qie} \
        -Dhibernate.dialect=com.qvera.qie.persistence.MySQLUnicodeDialect \
        -Dconnection.username=??? \
        -Dconnection.password=???
...