You cannot just edit hsqldb-persistence-service.xml. Instead, look in docs/example/jms and grab the oracle-persistence-service.xml file and use that instead (don't forget to delete hsqldb-persistence-service-xml!). The *-persistence-srvice.xml file contains SQL statements specific to their respective databases.