Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Entity fields are named in accordance with the Java naming conventions for fields (e.g. exampleField). They have the same length constraint than above : 30 characters max (including "_" separators) TODO: pk/fk names (including maximum length)

Foreign Keys names have a length constraint of 18 characters (including "_" separators). It's better to set them by hand, to avoid indesirable effects. These constraints do not come from OFBiz but from some DB. To be able to use any DB those constraints should be respected to allow DB portability.  

For fields parts of Primary Keys it depends on the DB you use. For instance the maximum length of a column name for Derby is 30 chars, but OOTB for an id you will get a truncation error from Derby jdbc drivers which limits them to the fieldype defined. And you will get a message like "A truncation error was encountered trying to shrink VARCHAR ... to length 20". Of course you can increase this value up to 30. This constraint does not exist with Postgres for example...

TODO: view-entity names and conventions conventions

Service Definitions

Best Practices

...