How to connect to the running DB?

[gioele]

I use JBoss 3.2.5, with the default "defaul" server conf

I have a servlet that creates some entity EJB objects.
The objects are created and stored in the DB (I can retrieve them after a jboss shutdown/restart cycle), and so are the Tables (02:12:20,958 INFO [Article] Table 'ARTICLE' already exists).
Somehow the localDB file jboss-3.2.5/server/default/data/hypersonic/localDB.data is empty, while the localDB.script file contains all the needed data.
I tried to connect via org.hsqldb.util.DatabaseManagerSwing to jdbc:hsqldb:localhost (u:"sa" p:"") and it shows an empty DB.

So,

• how can I connect and inspect the default DB?
  
• where is the DB stored when jboss is stopped?
  
  

[gioele]

"gioele" wrote:
how can I connect and inspect the default DB?

I found that I should use the "standalone" driver and connect to the name of the DB on the filesystem without .data (jboss-3.2.5/server/default/data/hypersonic/localDB).