How to view added data in embedded H2 database

Question

I used the built-in H2 database for WSO2 Gov Registry 4.6.0 and added a lot of entries there. I am trying to view data in tables in a database, but somehow I do not see these tables.

I entered the embedded H2 database, but I see only system tables and tables or data that I added to the registry.

How can I access the REG_ * and UM_ * tables in the database to view the data?

I tried to see tables in the H2 db and DBVisualizer browser, but I do not see tables and data in both.

Error Log:

[2014-11-22 16: 32: 57,972] INFO {org.wso2.carbon.h2.osgi.console.ConsoleService} - launching the H2 Web server ... [2014-11-22 16: 32: 58,191] INFO { org.wso2.carbon.h2.osgi.console.ConsoleService} - Starting H2 TCP server ... org.h2.server.TcpServerThread@65fe28a7Connect [2014-11-22 16: 32: 58,193] INFO {org.wso2.carbon.h2.osgi.console.ConsoleService} - Starting the H2 PG server ... Connect Disconnect Close javax.net.ssl.SSLException: connection completed: javax.net.ssl.SSLException: received close_notify while shaking hands at com.sun.net.ssl.internal.ssl.SSLSocketImpl.checkEOF (SSLSocketImpl.java:1343) at com.sun.net.ssl.internal.ssl .SSLSocketImpl.checkWrite (SSLSocketImpl.java:1355) in com.sun.net.ssl.internal.ssl.AppOutputStream.write (AppOutputStream.java:44) in java.io.BufferedOutputStream.flushBuffer (BufferedOutputStream.java:65) in java.io.BufferedOutputStream.flush (BufferedOutputStream.java:123) in java.io.DataOutputStream.flush (DataOutputStream.java:106) in org.h2.value.Transfer.flush (Transfer.java:85) in org.h2 .server.TcpServerThread.sendError (TcpServerThread.java:197) in org.h2.server.TcpServerThread.run (TcpServerThread.java:129) in java.lang.Thread.run (Thread.java:695) Called: javax.net.ssl.SSLException: received close_notify while shaking hands at com.sun.net.ssl.internal .ssl.Alerts.getSSLException (Alerts.java:190) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal (SSLSocketImpl.java:1747) at com.sun.net.ssl.internal.ssl.SSLSocketImpl .fatal (SSLSocketImpl.java:1703) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.recvAlert (SSLSocketImpl.java:1801) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord (SSLSocketImpl. .java: 1004) in com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake (SSLSocketImpl.java:1188) in com.sun.net.ssl.internal.ssl.SSLSocketImpl.readDataRecord (SSLSocketImpl.java:81818 ) in com.sun.net.ssl.internal.ssl.AppInputStream.read (AppInputStream.java:75) in java.io.BufferedInputStream.fill (BufferedInputStream.java:218) in java.io.BufferedInputStream.read (BufferedInputStream.java:237) in java.io.DataInputStream.readInt (DataInputStream.javahaps70) at org.h2.value.Transfer.readInt (Transfer .java: 145) in org.h2.server.TcpServerThread.run (TcpServerThread.java:71) ... 1 moreorg.h2.server.TcpServerThread@65fe28a7 Disable org.h2.server.TcpServerThread@65fe28a7 Close

Answer 1

All WSO2 products come with an H2 database by default.

This can be easily achieved by including the H2DatabaseConfiguration in carbon.xml.

• Go to CARBON_HOME / repository / config
• Open the carbon.xml file.
• Insert the H2DatabaseConfiguration as follows. ( don't uncomment the H2DatabaseConfiguration that already exists , just paste the code below)

<H2DatabaseConfiguration>
        <property name="web"/>
        <property name="webPort">8082</property>
        <property name="webAllowOthers"/>        
</H2DatabaseConfiguration>

4. Start the server.
5. Point your browser to http://localhost:8082
6. Fill in the JDBC URL, username and password as follows.
   • URL JDBC: jdbc: h2:// /WSO 2CARBON_DB
   • : wso2carbon
   • : wso2carbon

, !