Event recovery

The adapter supports event recovery for ALE inbound processing in case of abrupt termination. During event processing, the adapter persists the event state in an event recovery table that resides on the data source.You must set up the database before you can create the event recovery table. Consult your database administrator for details about creating the database.

Database support

The adapter supports the following databases for event recovery:
  • IBM®(R) Informix® Dynamic Server, Version 9.40.x
  • Cloudscape™ 5.1
  • SQL Server Enterprise 2000
  • DB2®(R) Enterprise Server Edition 8.2
  • Oracle9i Enterprise Edition Release 2
To connect to the various supported databases, do the following:
  • Configure adapter properties as described in the following table, “Database connection information.” The properties not listed in this table can be added to the EDTExtendedProperties.properties file as name-value pairs.
    Database connection information
    Supported database Configuration property information Additional information
    • IBM(R) Informix Dynamic Server, Version 9.40.x
    • EDTDriverName = com.informix.jdbcx. IfxXADataSourc
    • EDTServerName = [The name of the Informix instance on the server]
    • EDTPortNumber =[port number]
    • EDTDatabaseName = [The name of the database]
    In the EDTExtendedProperties. properties file, set ifxIFXHOST=[The physical name of the database server]
    • Cloudscape 5.1
    • EDTDriverName = com.ibm.db2j.jdbc. DB2jXADataSource
    • EDTDatabaseName = [any name. Database need not exist]
     
    • SQL Server Enterprise 2000
    • EDTDriverName = com.microsoft. jdbcx.sqlserver. SQLServerDataSource
    • EDTServerName = [name of server hosting SQLServer]
    • EDTDatabaseName = [name of the existing database]
    • EDTPortNumber = [port]
    In the EDTExtendedProperties. properties file, set selectMethod=Cursor
    • DB2(R) Enterprise Server Edition 8.2
    • EDTDriverName = COM.ibm.db2.jdbc. DB2XADataSource
    • EDTDatabaseName = [an existing database]
     
    • Oracle9i Enterprise Edition Release 2
    • EDTDriverName = oracle.jdbc.xa.client. OracleXADatasource
    • EDTURL = [The URL for the DB]. For example: jdbc:oracle:thin: @myServer:1521: myDatabase
     
  • Copy the file EDTExtendedProperties.properties to the following directory on WebSphere® Process Server: <WPS_INSTALL>\profiles\<your-profile>\installedApps\<host-name>Node01Cell\<your-application-name>App.ear\CWYAP_SAPAdapter.rar\

Event recovery table

The event recovery table contains the following fields:

Event recovery table fields
Table field name Type Length Description
TID VARCHAR 30 Transaction ID for tRFC (Transactional Remote Function Call) protocol.
Status VARCHAR 10 Event processing status. Possible values are CREATED, EXECUTED, PARTIAL, and ROLLBACK.
NumIDocs INT   Total number of IDocs in the packet.
NumIDocsProcessed INT   Total number of IDocs from the packet that are successfully processed.
CurrIDoc INT   Sequence number of the IDoc in the packet that the adapter is currently processing
Note: The AutoCreateEDT configuration property in the J2C activation specification properties determines whether the event recovery table is created automatically or not. The default value of this property is True (create the table automatically). For manual creation, use the information provided in the “Event recovery table fields table.”
Related concepts
ALE inbound sample application
Adapter environment

Terms of use |

Last updated: Sun Mar 12 11:15:17 2006

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)