H2 is a database written in Java. We can easily embed this database to our software by means of using JDBC. We will run this on many different structures or any model of Java Runtime environment. However, before installing the database, there have to be Java set up in the system.
If JDK is installed in the system, try the following command to verify the Java version.
If JDk is successfully installed in the system, then we will get the following output.
If JDK is not installed in the system, then visit the following link to Install JDK.
We can run this database on many different platforms. In this chapter, we will learn about H2 Database installation on Windows.
Following are the steps to install H2 Database on Windows operating system.
Download the latest version of H2 Database from the given link. on this hyperlink, you'll get the latest model of H2 database in two kinds. One is home windows Installer type (that is .exe document) and 2nd is Platform-independent zip file for other working systems.
Click the windows installer for downloading the home windows supportable H2 database after downloading the .exe file. In this case, we are the use of H2 Database with the version 1.four.192.
After downloading we get the H2 home windows installer file (i.e. h2-setup-yyyy-mm-dd.exe) inside the Downloads directory. To begin the installation procedure of H2 Database, double click at the installer document.
the following display is step one inside the set up process. Offer a path where we need to put in the H2 database server as shown inside the following screenshot.
As seen in the above screenshot, by default it will take C:\ProgramFiles (x86)\H2 as the destination folder. Click next to proceed to the next step. The following screen pops up.
In the above screenshot, click the Install button to start the installation process. After installation, we get the following screenshot.
Click Finish to complete the installation process.
After installation, let us verify the database installation in the system. Click Windows → type H2 Console → Click H2 console icon. Connect to the URL http://localhost:8082. At the time of connecting, the H2 database will ask for database registration as shown in the following screenshot.
Fill all of the info inside the above conversation box such as saved Settings, Settings name, driver class, JDBC URL, user name, and Password. in the JDBC URL, specify the database is located and the database name. user name and Password are the fields for user name and password of the database. click connect.
The Database welcome page pops up as shown in the following screenshot.
H2 Database Related Interview Questions
|RDBMS Interview Questions||Adv Java Interview Questions|
|Core Java Interview Questions||SQL DBA Interview Questions|
|SQL Interview Questions||EJB(Enterprise JavaBeans) Interview Questions|
|Java-Google Web Toolkit (GWT) Interview Questions||SQLite Interview Questions|
|Java collections framework Interview Questions||Java 8 Interview Questions|
|RESTful JAVA Web Services Interview Questions||Advanced C# Interview Questions|
|Internet Technologies Interview Questions|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.