Now that we got the data, let's use an RDBMS called h2 database. So you can go to h2 database calm, and then look for its download options. The current version is one dot four dot one double nine, which somehow seem to have some issues. So let's not download this one. But let's go to all downloads. And then you can see it says the last stable version happens to be one dot four dot 197.

Now if you're on Windows, you can download the Windows Installer, which simply installs a folder on your computer. Ultimately, you can download platform independent zip file, which I have already downloaded and unzipped in my home directory. So if you happen to see here, under my home directory, I have a folder here called h2. And the H two has a bin directory hits two dash one dot four dot one minute to seven dot jar, there's a.sh file that you can use in Mac or Linux. You also have hedge to dot bat for Windows. Now on Windows, you can simply double click this file, and you should see that the server will be started.

As well as a client application will open in a browser. On Mac or Linux, you can just copy the path of the file by going to services copy port, and then open a terminal and then paste this press enter. You can see that the server started and on the menu bar, you can see that as an icon. On Windows, you will see the similar icon on the notification area at the bottom right. The browser that came up is basically a client application that allows us to connect to this particular server. In case if you happen to close this, you can always get this back from this icon.

Then click on h2 console. Now if you are running this for the first time, you may see Something called generic h2 embedded. And the options would be a little bit different over here. So make sure that you selected generic h2 server. Here, you can give some custom name and click on the Save button, and this name will appear in the drop down. The driver class happens to be our dot h two dot driver.

No change over there. The JDBC URL has the server and client protocol, the server location and then you have the name of the DB which is called test by default, I can change this to a new DB called spring boat. Dash that training and then click the Test Connection to see if everything is okay. You may notice that the username is a and password a blank password is default. If you want you can change that and then click the connect button and then you will be taken into the database. Now here you can type in commands such as create alter, drop Select etc.

But since we already have got the data in an SQL file, we have to type the command run stripped from, in single quotes give the path to that particular file. In my case, I downloaded that and kept in my workspace directory. So I'll go to the workspace location, and this is a file once again, I will copy the path of the file, and then come back over here, paste that quotes complete. If I click on the run button here, now it's going to execute the command. And if there is no problem, it will give you some kind of update count. You can click the Clear button and then look at the customers here.

I have all the fields clicking on the customers will bring me a select star from customers. click the Run button and I should be able to see all the customers that I have added through mokoro.com