Apache OfBiz Cookbook

Apache OfBiz Cookbook

Overview of this book

Apache Open For Business (OFBiz) is an enterprise resource planning (ERP) system that provides a common data model and an extensive set of business processes. But without proper guidance on developing performance-critical applications, it is easy to make the wrong design and technology decisions. The power and promise of Apache OFBiz is comprehensively revealed in a collection of self-contained, quick, practical recipes in this Cookbook. This book covers a range of topics from initial system setup to web application and HTML page creation, Java development, and data maintenance tasks. Focusing on a series of the most commonly performed OFBiz tasks, it provides clear, cogent, and easy-to-follow instructions designed to make the most of your OFBiz experience. Let this book be your guide to enhancing your OFBiz productivity by saving you valuable time. Written specifically to give clear and straightforward answers to the most commonly asked OFBiz questions, this compendium of OFBiz recipes will show you everything you need to know to get things done in OFBiz. Whether you are new to OFBiz or an old pro, you are sure to find many useful hints and handy tips here. Topics range from getting started to configuration and system setup, security and database management through the final stages of developing and testing new OFBiz applications.

Apache OFBiz Cookbook

Credits

About the Author

About the Reviewers

Preface

Free Chapter

Getting Started

Introduction

Getting the project code

Getting code from the Subversion repository

Fixing IP port collision errors

The JAVA_HOME setting

"Class Not Found" errors

Installation verification

SSL verification

Running JUnit tests

Locating an OFBiz Component

Locating an OFBiz Application

Java Development

Introduction

Java runtime CLASSPATH

Java compile time CLASSPATH

Naming conventions

Writing OFBiz Java Events

Writing OFBiz Java Services

Debugging using the logfile

Calling OFBiz Services from a Java program

Getting and validating request parameters (Events)

Getting and validating request parameters (Services)

Managing error messages

Using Java properties files

Sending e-mail from an OFBiz Event or Service

Handling XML files

The User Interface

Introduction

Creating HTML web pages

Adding actions to Screen widgets

HTML markup in Screen widgets

CSS styling in Screen widgets

Platform-specific widgets

OFBiz Tree widgets

OFBiz Menu widgets

OFBiz Form widgets

Creating web pages using FreeMarker

Passing Screen widget parameters to FreeMarker

Calling Java methods from FreeMarker

Forcing FreeMarker to render HTML markup

Uploading files in FreeMarker forms

OFBiz Services

Introduction

Managing existing OFBiz Services

Calling a Service from an HTML form

Calling asynchronous Services from HTML forms

Calling a Service many times from an HTML form

Creating a new Service definition file

Creating a new Service definition

Implementing Services

Defining Service attributes (INPUT/OUTPUT)

Service Event Condition Actions

Service groups

Handling Service errors

Writing Groovy Services

Mail Event Condition Actions

Entity Event Condition Actions

The OFBiz Entity Engine

Introduction

Changing the default database

Connecting to a remote database

Connecting to multiple databases

Creating entity groups

Disabling automatic database checks

Mapping database data types

Creating a new entity model

Modifying an existing entity model

Building a view-entity

OFBiz Security

Introduction

Securing communications ports

Disabling demonstration user accounts

Protecting OFBiz web pages

Creating user accounts

Protecting applications using security groups

Protecting views ("Tarpitting")

Retrieving forgotten passwords

Changing your password

Adding or changing SSL certificates

OFBiz single sign-on and the external login key

WebTools

Introduction

Cache maintenance

Changing debug settings

Exporting database data to XML documents

Loading database(s) from XML documents

Managing internationalization labels

Using the SQL processor

Exploring the entity reference tool

Viewing OFBiz usage statistics

Uncovering artifact information

Working with temporal expressions

Web Services

Introduction

Requesting web services using URL parameters

Requesting web services using an HttpClient

Creating HttpClients and passing XML documents

Creating XML-RPC web service clients

Becoming an XML-RPC web service provider

OFBiz SOAP messaging clients

Generating a WSDL document

Creating SOAP-compliant web services

OFBiz Tips and Tricks

Introduction

Fixing Java memory allocation errors

Reloading OFBiz seed and demo data

Creating new seed data files

Changing the administrative user's password

Creating a new administrative user

Getting the OFBiz version number

Building an OFBiz instance

Building a single OFBiz Component

Creating a new OFBiz Component or Application

Creating a FreeMarker transform

Preparing data using Groovy

Pop-up new browser windows

Installing an OFBiz Visual Theme

Creating an OFBiz Visual Theme

Entity Engine by Example

Introduction

Putting it all together with a data model example

Reading data from an OFBiz data source

Working with large result sets (EntityListIterator)

Removing data from the database (Java)

Writing data to the database (Java)

Using the automatic sequence generator

EntityUtil

EntityOperator reference

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Connecting to multiple databases

The OFBiz Entity Engine may service an unlimited number of database connections in addition to, or as a replacement for, the default embedded Derby database.

Getting ready

The following steps should be ensured:

1. If the databases do not already exist, be sure to create them prior to editing the entityengine.xml file. Collect necessary connection information per database, including database location information (IP address and port), database name, username, and password if necessary.
2. Create one or more entity group definition(s) that assign a connection label using the delegator declaration to an Entity Engine reader. If you wish to create a new entity group definition file for the new entity model's group definitions, do so now.(Note: you can use an existing entity group definition file such as the one found in ~framework/entity/entitydef/entitygroup.xml).
3. If the entity model definitions do not exist for the target database tables, create one entity definition...

Apache OfBiz Cookbook

Apache OfBiz Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

Apache OfBiz Cookbook

Connecting to multiple databases

Getting ready