How to populate the SQL import* scripts?

[grettke_spdr]

Hi folks,

I am using Seam 1.2.1 with HSQLDB. I would like to use the import* scripts to populate the database. I need to figure out what those SQL statements look like, though, as my inserts are not getting displayed in the log.

Is there a way to connect to the in memory database and dump it to SQL?

[tony.herstell1]

To connect to in-memory database (assuming you haven't fiddled with defaults):

go to your jboss JMX console.

click on the hypersonic link

launch the database manager.

click connect when it runs up... and click ok.

there are your tables.

Mine has stopped working for now, but I think thats cus I am using IceFaces :(