#5 Failed to create DB in PostgreSQL 7.4.x

[Anonymous]

Tried to use the ORYX's CRM and Portfolio examples but
it failed to create DB in PostgreSQL 7.4.x. The error
message was:

SQL FAILED: CREATE TABLE CUSTOMER_TRANSACTIONS (ID INT
NOT NULL,CUSTOMER VARCHAR(20),AMOUNT
DOUBLE,TRANSACTION_DATE DATE,PRIMARY KEY (ID))

The problem is the "DOUBLE" data type defined for AMOUNT.

According to PostgreSQL's doc, it accepts the "DOUBLE
PRECISION" data type and not "DOUBLE". I also checked
the specs of SQL 92 and 98 and they seem to use "DOUBLE
PRECISION". After modified CRMExample.java and
PortFolioRiskExample.java in oryx to use "DOUBLE
PRECISION" and rebuilt oryx-3.5.4-application, I ran
them successfully against PostgreSQL and MySQL. I
didn't have the rest of databases on the list therefore
I didn't try them. However, if they follow the SQL
specs, I believe that it should work also. Maybe
someone else has the other databases could give it a try.

Thanks,
Chia