The following sections describe how to set up a remote H2 database to replace the default H2 databases with Remote H2database in your WSO2 product:
| Table of Contents | ||||
|---|---|---|---|---|
|
| Excerptwarning | ||||||
|---|---|---|---|---|---|---|
| ||||||
NOTES TO WRITERS: Include this intro sentence and TOC at the beginning of your hosting page: The following sections describe how to replace the default H2 databases with Remote H2: | ||||||
| ||||||
The embedded H2 database is NOT recommended in enterprise testing and production environments. It has lower performance, clustering limitations, and can cause file corruption failures. Please use an industry-standard RDBMS such as Oracle, PostgreSQL, MySQL, or MS SQL instead. However, you can use the embedded H2 database as the local registry in a registry mount even in enterprise testing and production environments. |
Setting up the remote H2 database
Follow the steps below to set up a Remote H2 : databasedatabase.
Download and install the H2 database engine on your computer as follows. :
Info For instructions on installing, see the H2 installation guide.
- Go to the <
H2_HOME>/bin/directory directory and run the H2 network server starting script as follows, where <H2_HOME>is the H2 installation directory:
- Run the H2 database server with the following commands:
- For Linux:
$ ./h2.sh
- For Windows:
$ h2.bat
Info The script starts the database engine and opens a pop-up window.
- For Linux:
Click Start Browser to open a web browser containing a client application, which you use to connect to a database. If a database does not already exist by the name you provided in the JDBC URL text box, H2 will automatically create a database.
...
- Delete the following H2 database-related JAR file, which is shipped with WSO2 products:
<PRODUCT_HOME>/repository/components/plugins/h2-database-engine_1.2.140.wso2v3.jar Find the JAR file of the new H2 database driver (
<H2_HOME>/bin/h2-*.jar, where<H2_HOME>is the H2 installation directory) and copy it to your WSO2 product's<PRODUCT_HOME>/repository/components/lib/directory directory.
What's next
Next, you need to configure your product with Embedded H2 database. For more information, see Changing to Remote H2.