SET H2DRIVERS= -pg -tool SET CLASSPATH=-cp "D:\Program Files (x86)\H2\bin\h2-1.3.175.jar SET CLASSPATH=%CLASSPATH%;D:\some_path\postgresql-9.3-1102.jdbc4.jar" SET H2FLAGS= -webAllowOthers -tcpAllowOthers -url jdbc:h2:file:AvCloudLiteDB -driver org.postgresql.Driver java %CLASSPATH% org.h2.tools.Console %H2DRIVERS% %H2FLAGS% #### use strict; use warnings; use DBI; my $dbh = DBI->connect("dbi:Pg:dbname=AvCloudLiteDB;host=127.0.0.1;port=60077;", ,, #$username, $password, {AutoCommit => 0, RaiseError => 1, PrintError => 1} ) or die "Cannot - db:$DBI::errstr"; print "Connected..\n"; my $sth = $dbh->prepare("SELECT * from GRIDS"); while (my $h = $sth->fetchrow_hashref){ print "$_=$h->{$_}; " for keys %$h; print "\n"; } close $dbh;