The following tutorial provides step-by-step instructions for setting up a sample database table, configuring the Database Adapter, and then designing, deploying, and using it in a business application.
Before you begin designing the sample application, you will need to know the following information about the database your Business Process Server installation uses.
Database type .
Username and password.
Driver class.
Database URL.
To access this information, go to db.properties file under the OEBPS_HOME\adapters\db\conf directory.
You need to copy the OEBPS_HOME\adapters\db\conf\db.properties file (if existing) from the Business Process Server installation machine to the conf directory. If the Database Adapter has been already used in Business Process Server, this file will contain a list of the defined databases for the Business Process Server installation.
Note: A frequent slip in the Database Adapter configuration is to forget updating the list of output parameters when you update your SQL statements. For example, if you initially had a statement returning two variables V1 and V2 and later changed the statement to return only V1, you may notice that the V2 output still appearing in the map configurator window. In this case, you most probably forgot to remove the V2 output variable from the DBAdapter's variable list. Click the Variables button in the Database Adapter configurator window and remove all the variables that are not used.
Database type .
