Page History

...

• Miscellaneous
  • OFBiz's Data File Tools Some tips from Jacopo
  • How to use EntityWhereString A tip from GrimTim
  • How to troubleshoot SQL errors A tip from Chris Lombardi
  •  How to measure SQL queries durations
  • How to use OFBiz on read only database
    
  • Tips for View Entities A tip from SkipDever
  • How to connect to an External Database A tip from Adrian Crum
  • How to save customised data for import as demo data A tip from Raj Saini
  • Is it possible to delete products, categories, catalogs, etc., that are no longer needed?
  • About lastUpdatedStamp, lastUpdatedTxStamp (transaction), createdStamp, and createdTxStamp
  • Why primary keys are VAR_CHAR type in OFBiz ? A tip from David E. Jones

...

If you receive an SQL error in ofbiz, it doesn't show the error from the database itself. Instead, it shows a general error which isn't neccessarily clear. Run the SQL directly on the database get a more helpful error message.

How to connect to a Database on read only

If you need to connect OFBiz to a database without write access or you want just are sure that your users have a read acces, you can change on the entityengine.xml the helper to the class ReadOnlyHelperDAO on your data-source  like that

    <datasource name="localderby"
            helper-class="org.apache.ofbiz.entity.datasource.ReadOnlyGenericHelperDAO"
            schema-name="OFBIZ"
            field-type-name="derby">...

...