When using the Database Adapter, special care must be taken to ensure that the adapter is configured properly, and that it operates correctly when your business process is published.
Upon installation, Progress Developer Studio for OpenEdge (or Business Process Modeler) is not automatically configured for use with a particular database. The Database Adapter needs a database connection in order to be configured properly.
When using the Database Adapter configurator for the first time, you will note that the default Business Process Server database - "oebps" - is not configured. One way to fix this is to define the database connection properties using the Database Adapter configurator as described in
DefiningDatabase connection. Another approach is to copy the db.properties file from the Business Process Server installation you are designing the process for. Copy the
db.properties file from
OEBPS_HOME\adapters\db\conf directory of the Business Process Server installation to
OEBPS_HOME\workspace\.com.savvion.studio\adapters\DBAdapters.
If you are using the Database Adapter Configurator to add new database connections, you must ensure that the db.properties files contain the same data in Progress Dveloper Studio for OpenEdge (or Business Process Modeler) and the Business Process Server. You can copy the db.properties file from Progress Dveloper Studio for OpenEdge (or Business Process Modeler) to the Business Process Servers directory; just be careful not to overwrite some database connection that is present and used on the Business Process Server, but is missing in Progress Dveloper Studio for OpenEdge (or Business Process Modeler).
