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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center