Explore Webcenter Sites DB(HSQLDB) tables through Eclipse

Step 1: Start JSK(You can find JSK installation steps here) and Eclipse.
Step 2: Open Eclipse Help-->Eclipse Marketplace

Step 3: Install Eclipse Data Tools Platform and restart Eclipse for installation to take effect.
Step 4: Click on Window --> Open Perspective --> Other and Select Database Development
Step 5: Right click on Database Connections and select New

Step 6: Choose HSQLDB and click Next

Step 7: If HSQLDB driver is not listed, select "New Driver Definition"
Step 8: Select HSQLDB and click on "JAR List" tab

Step 9: Add HSQLDB JAR(you can locate jar under <Installation_directory>/apache-tomcat-7.0.42/Sites/lib/hsqldb.jar)
Step 10: Below Window will appear.

Step 11: Leave default values except for "Database Location".

Step 12: Click on browse and choose csDB(default location - <Installation_directory>/ tomcat/Sites/default/data/hypersonic/csDB). csDB should not have any extension. If you are not able to locate above path; Check Resource node in your server.xml file (<Installation_directory>/ tomcat/Sites/conf/server.xml)

Step 13: Click on test connection and it should be successful. Now you can examine the sql db as any normal DB.

Additional Steps to run queries

1. Click on File-->New--> SQL File. The workspace should have a project.

2. Select Connection Profile name as New HSQLDB; Upon selection, Database Server Type should be populated.

3. Select Database name as Public. Click Finish.

4. Now you will be to execute any queries against WCS DB.