Page History

...

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.ReadOnlyGenericHelperDAOReadOnlyHelperDAO"
            schema-name="OFBIZ"
            field-type-name="derby">...

...