OSB SAP Adapter iwafjca.rar Initial Connection

| February 16, 2014 | 0 Comments

If you are using Oracle Service Bus and integrate it by using SAP adapter, you can face the error below. When I try to update weblogic-ra.xml and change the value for from 0 to 5 it always give deployment update error and the application could not shift to active state. When I rollback to 0 again, it works properly.

The problem is application could not get initial connection and it gives nullpointer exception. This problem is not a bug. I have experienced that “initial connection” must be “0″. So, it doesn’t make sense try to increase it. You have to roll back and set initial connection to “0″ (zero). You can give initial connection by using “OSB Application Explorer for SAP Adapter” throug your SAP connection definition.

IWAE Path: $OSB_HOME/3rdparty/ApplicationAdapters/tools/iwae/bin/iwae.sh

OSB and SAP Adapter Version: 11.1.1.7
Error Code: BEA-149265
Error Log:

Below settings are recommended by Oracle Documentation for JCA Adapters:

 

 

The value of initial-capacity must be 0
The value of connection-creation-retry-frequency-seconds must be 10
The value of test-frequency-seconds must be 300.
The value of test-connections-on-reserve must be TRUE.
The value of test-table-name must be SQL SELECT 1 FROM DUAL
The value of seconds-to-trust-an-idle-pool-connection must be 0
The value of global-transactions-protocol must be TwoPhaseCommit .
The value of keep-xa-conn-till-tx-complete must be TRUE.
The value of xa-retry-duration-seconds must be 300.
The value of xa-retry-interval-seconds must be 60.

 

LinkedInTwitterGoogle+FacebooktumblrEmail
    Share admineer resources...

Tags:

Category: Middleware, OSB

M.Fevzi Korkutata

About the Author ()

M.Fevzi Korkutata: Deep level technical consultant... Oracle ACE in Middleware & SOA expertise. His specialty is large scale and mission critical live production systems and like to work as DevOps. He knows all kind of application servers and its environments. Software product development, operation management, design, implementation, integration... etc. Korkutata working as "Application and Infrastructure Architect"... Likes to work and communicate internationally, stay connected :)

Leave a Reply

Your email address will not be published. Required fields are marked *