Getting-Start-Profile-SQL.md

#Editing Getting Start Profile SQL

We will discuss the way of monitoring SQL with installing the HSQL DB and executing some sample applications. It is premised that you done with the Getting Started.

Installing HSQL

Downloading files

http://hsqldb.org/

After unzip, run HSQL DB as a server mode

C:\hsqldb\bin\runServer.bat --database.0 file:mydb --dbname.0 xdb

Installing the HSQL jdbc driver on tomcat and Setting up the datasource

http://hsqldb.org/doc/guide/ Copy the ${HSQL_HOME}/lib/hsql.jar to ${TOMCAT_HOME}/lib/ Setting up the datasource on ${TOMCAT_HOME}/conf/web.xml

Execute

1. create.jsp
2. sql.jsp
3. lock.jsp

After executing the sql.jsp, you can see the result on Scouter like: