You are using the default portal datasource which is Hypersonic(HSQL), which is an in-memory database. Follow the instructions for setting up datasource in the Jboss portal Reference Guide. There is a setup folder which has pre-configured datasource xml files where you have to specify the driver and database connection details.

Hope this helps ...