The commons tool SQL does not work on Oracle. The SQL is hardcoded into the persistence class and contains table aliases using AS. This is not allowed in FROM clauses in Oracle.
The AS keyword should be able to be omitted for all databases. Ideally the persistence layer would not use hardcoded SQL though.