Perl DBD::H2 support

279 views
Skip to first unread message

dualboot

unread,
Aug 13, 2009, 2:25:46 PM8/13/09
to H2 Database
I thought there might be already someway to access H2 database from
Perl using one of those DBD modules. To my dismay I couldn't able to
find one. I have been using a few Perl scripts to parse reports and
update SQL database. I am too busy (lazy) to redo it in Java cause
this is one time event. Currently I can output these to a SQL file for
statements INSERT INTO xTable VALUES(); and then copy and paste these
SQL Commands in to a H2 console. This is cumbersome and difficult to
capture error. Is there any easier way of doing this... Like run the
SQL file directly? If then how? Can anyone explain this process?

TIA

Sergi Vladykin

unread,
Aug 13, 2009, 3:05:38 PM8/13/09
to H2 Database
H2 supports Postgresql network protocol, so you can try to do this
using
postgres's driver in perl (I belive perl has one). Read more details
in docs.

--
regards,
S.Vladykin
Reply all
Reply to author
Forward
0 new messages