Too many other similiar projects already (see fyracle, daffodil). See homepage for much more info. The homepage has been rebranded as an open source erp/crm discussion/blog page.
Compiere's db independence relies on sql translation. In order to reliably translate sql you will need to understand the sql you are translating. So no easy way around it you have to write a pre parser.
Theres already a good one out there its called antlr. Stay tuned for more news.
The knowledgesuccess site is down temporarily and will be restored within the next few days.
We have written a substituter for update table1 set (column1, column2)=(select column1, column2 from table 2 .... ) etc and as a result the sales order will now 'COMPLETE'.
The dependancy on the patches in PO.java have been removed thanks mainly to a rewritten sqlj function - to_date. CVS head has the latest code.
We have given up on our homegrown jdbc code and use a tried and tested (modified version) of Schema Spy to discover the oracle database structure when replicating tables into Hsqldb.
Here is a rough cut of the version which runs on 2.5.3b. We tried two other databases that claim to be compatible with Oracle - one$db (daffodil) and enterpriseDb. Both had compatibility issues. So we forge ahead with patching hsqldb which seems like one of the strongest java databases out there.
Many problems occur - compatibility with SQL - when trying to run Compiere against HSQL. We are addressing them one at a time.
The gui now starts up running only on Hsqldb.
However there are still many problems so don't expect too much for now.
This functionality is only available on CVS head at the moment, until we have uploaded a new version.
This is the initial release of the Compiere Framework and is based on 252d of Compiere.
The purpose of the project is to promote Test Driven development in Compiere. The project replicates oracle data into an Hsql database which provides a platform for testing.
The fixture data is quickly refreshed allowing for clean data to be used for each test. An added benefit is that development can be done offline from the major Compiere database (oracle or sybase).... read more