Set HSQLDB data type in hibernate configuration files?

I am trying to create an in-memory DB using HSQLDB 2.2.5. We are also using Hibernate. The problem is that our Domain Objects are annotated for Oracle. We generate the HBM files from the POJOs. Hence I am getting "type not found or user lack privileges: NUMBER" errors when I attempt to run against HSQLDB. HSQL 2.2.5 doesn't support NUMBER, only NUMERIC.

Is there any way in the 开发者_如何学JAVAhibernate configuration file or hibernate.properties to tell HSQL to treat NUMBER as NUMERIC?

Well, this version of HSQLDB supports the Oracle syntax compatibility and accepts MUMBER in this mode, plust many other Oracle-specific features. See the Guide for details.

http://hsqldb.org/doc/2.0/guide/deployment-chapt.html#N14266