[Oryx-users] Failed to create DB in PostgreSQL 7.4.x

[Chia C. <Chi...@Su...>]

I posted a bug at Oryx's web site earlier; however, the bug page seems 
to lack of activity. Therefore, I sent this email to communicate with 
you all. If there was any duplication, please forgive me.


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.

There are three files in the example directories I found that have the 
"DOUBLE" defined:

1. oryx/src/com/jbdietrich/oryx/examples/crm/CRMExample.java
2. 
oryx/src/com/jbdietrich/oryx/examples/portfolio_risk/PortfolioRiskExample.java
3. oryx/src/org/mandarax/examples/db/CreateDB.java

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