How to open Guidewire H2 database file
As you know H2 is the default database used by Guidewire InsuranceSuite products for local development environment. If you see this tag in your PolicyCenter database-config.xml, for example < database name= "PolicyCenterDatabase" dbtype= "h2" > < dbcp-connection-pool jdbc-url= "jdbc:h2:file:/tmp/guidewire/pc;CACHE_SIZE=32000" /> </ database > then you use H2 as well. It's quick and easy to start, but at some point you'll want to take a look at your data tables. How to do this properly? Fortunately, there are great tools for this purpose. You can use DBeaver or DBVisualizer. As an example let's consider DBeaver. To create a new connection try File -> New -> Database Connection, Connection Type = H2 Embedded. Now is the most interesting part. On Generic JDBC Connection Settings in Database/Schema specify the folder where you H2 database files are stored. For example, c:/tmp/guidewire/pc. Warning! Don...