Oracle SOA Suite (MOSC)

MOSC Banner

OSB Business Service DB adapter issue

edited Feb 21, 2021 8:47AM in Oracle SOA Suite (MOSC) 1 comment

Hello All,

We have deployed a business service that use DB adapter (XA datasource).

It's only selecting from DB view that have more than 100k rows.

While testing the business service, we were able to get data when the data returned is 1k rows or less however when the filter we do return data for around 30K rows it took more than 12 minutes and then through the below error.

An unexpected error occurred executing the test service: ; nested exception is:

java.io.EOFException


I believe the thread get stuck, I tried to increase the stuck thread time but still getting the same error.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center