powered by Jive Software

HSQLDB and Perl's DBD::JDBC

Anyone know whether it’s possible to connect to the embedded HSQLDB from outside of openfire?

I tried the following in Perl:

my $dbh = DBI->connect(“dbi:JDBC:hostname=localhost;port=9001;url=/opt/openfire/embedded- db”,‘sa’,’’);[/b]

with no luck. Then I ran nmap -sS and couldn’t see an open port anyway, so I didn’t hold up much hope?

I’ve started browsing the module documentation but I’m not sure where the jar files need to go for the openfire implementation.

Has anybody managed to do this? Or can someone more experienced with the HSQLDB give me some pointers?

I’m going to keep playing with it, but if anyone has any useful input on this I’d appreciate it.

Hi,

the HSQLDB has no open port if it’s run in embedded mode and this is the case within Openfire. So you can’t access it from an external application.

LG