#6 [NEW] Failed to create DB in PostgreSQL 7.4.x

[Chia Chang]

sourceforge.org was down intermittenly while I was
creating the bug. The other bug wasn't completed.

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