Posts

Showing posts from June, 2018

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&#

Hello World!

Here goes the very first post. In this blog I'm going to highlight Guidewire development questions  and problems that every Guidewire developer may stumble upon. The answers and solutions I suggest come from my practical experience and they may not be the best. If at some point you find a better solution, please don't hesitate to write in comments. Looking forward to hear from you!