This content has been marked as final. Show 6 replies
i have added an timer to the invocation to my db adapter, for 5 sec. still the error triggered to bpel catch all was after 15 seconds :(
i just confifured DBAdpater to select a query from DB.
im fine with the error. but want that error tobe caught by my bpel in the next fraction of second.
Thanks in advance
Thanks for reply vlad.
i have bpel with sequence of db adapters.
it starts with polling data, next one function call then comes data reading from sql server(select query based on some where clause)
and my probelm is in reading from sql server.
yeah the composite works for every 10 seconds.
As a side note, I'd like to add that even though I understand it's a valid test you trying to perform, I don't think to raise an exception straight away without any retry is a desirable situation in a prod environment...
Getting back to your quest, I'm not sure where the 15sec delay is, but I don't think it's in the composite as it seems you already tweaked pretty much everything.
I'd go for two other suspects, the DbAdapter and the data source...
Firstly, on Weblogic Console go to Deployments > DbAdapter > Configuration > Outbound Connection Pools... then choose your connection from the list and go to Connection pool... There are connection retry parameters, timeout and test connection parameters there to check...
Then, have a look into Services > Data Sources > your-data-source > Connection Pool > Advanced... I would leave Test Connections On Reserve checked and again there's many timeout and connection retry parameters there to be checked...
Please let me know how you go...