Declaring transaction object(s)

When the tutorial PowerBuilder application is deployed to the Web, Appeon Server handles the database connection using data sources rather than transaction objects defined in the PowerBuilder application. You must associate the transaction objects used by the Appeon tutorial PowerBuilder application with proper data sources.

Figure 41. Transaction object mappings

Transaction object mappings

The Appeon tutorial application uses the SQLCA transaction object which connects to the appeontutor database. To associate the SQLCA transaction object with the proper data source:

Step 1: Click Add. The Add Transaction Object dialog box is displayed.

Figure 42. Add transaction object mappings

Add transaction object mappings

Step 2: Select SAP ASA | UltraLite from the Database Type dropdown listbox.

Step 3: Select Appeon Server Tutor from the Appeon Server list. The existing data sources in Appeon Server will be displayed.

Note: the data source tool is available for Microsoft .NET Framework, and not available for EAServer, WebLogic, WebSphere, JBoss, or JEUS. You should go to the corresponding application server administration console to configure the data source for EAServer, WebLogic, WebSphere, JBoss, or JEUS. For detailed instructions, refer to Database Connection Setup in Appeon Server Configuration Guide for J2EE.

Figure 43. Data sources in the Appeon Server

Data sources in the Appeon Server

The following steps show you how to create a data source that links to the appeontutor ODBC data source using the ODBC driver.

Step 4: Click Add to create a data source. The Add dialog box is displayed.

Figure 44. Add a data source

Add a data source

The following table provides instructions for how to specify the data source settings.

Table 20. Instructions to specify data source settings




Input "appeontutor" as the name of the data source.


Select "ODBC Driver" as the driver type for the data source .

ODBC Data Source

Select "appeontutor" as the data source name.

This will connect to the appeontutor ODBC data source that was created in the section called “Configuring ODBC data source”.

If the database type is SAP ASA/SQL Anywhere and the database file resides in an NTFS folder, please grant the "NETWORK SERVICE" or "Everyone" user with full controls over that folder.

User Name

Type "dba".


Type "sql".

Step 5: Click Test to verify the connection to the appeontutor data source.

Step 6: Click OK to close the Add dialog box.

The appeontutor data source has been added.

Step 7: Select the Selected button of the appeontutor data source.

Figure 45. appeontutor is added

appeontutor is added

Step 8: Click OK to close the Add Transaction Object dialog box.

The "sqlca" transaction object is added.

Figure 46. sqlca is added

sqlca is added

Step 9: Click Next through the rest of settings, until you get to the Summary page.

Figure 47. Summary


Step 10: Click Finish on the Summary page to close the wizard.

The Appeon tutorial application is successfully configured.

The Appeon Deployment Wizard will be launched, if you keep the "Deploy the application now" option on the Summary page as selected. Refer to the section called “Deploying the Tutorial PowerBuilder Application” for how to use it.