Which files to modify/add for independence?

2006-03-07
2013-05-02
  • Gerald Leung
    Gerald Leung
    2006-03-07

    Hi,

    I'm looking to add to Compiere support for Derby/Cloudscape. I would like some advice as to what files to modify/add for this to work.

    I believe I'm supposed to modify/add the files below. I am probably missing many files from this list. Please tell me which ones.

    (q1) Is there any documentation on how the "database independence" works? It appears Convert and ConvertMap are using regular expressions to convert Oracle SQL to the target DBMS. Is this done dynamically or during build time?

    (q2) When the conversion cannot be done with Convert, what is done?

    Thanks,
    Gerald

    ----------list of files-------------------
    /compiere-all/dbPort/src/org/compiere/db/
    (new) DB_Derby.java
    (modify) Database.java

    /compiere-all/dbPort/src/org/compiere/dbPort/
    (modify) Convert.java
    (modify) ConvertMap.java

    (new) /compiere-all/db/database/Startup/derby/
    (new) AfterImport.sql
    (new) BackupCold.sql
    (new) BeforeExport.sql
    (new) CheckDB.sql
    (new) CreateUser.sql
    (new) Daily.sql
    (new) Start.sql
    (new) Stop.sql
    (new) Test.sql

    (modify) /compiere-all/tools/build.xml

    (new) /compiere-all/utils/derby/
    (new) DBExport.bat
    (new) DBExport.sh
    (new) DBExportFull.bat
    (new) DBExportFull.sh
    (new) DBRestore.bat
    (new) DBRestore.sh
    (new) ImportCompiere.bat
    (new) ImportCompiere.sh
    (new) ImportReference.bat
    (new) ImportReference.sh
    (new) Start.bat
    (new) Start.sh
    (new) Stop.bat
    (new) Stop.sh