Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database connection reset problem in ESB

660195Jul 2 2009 — edited Jul 2 2009

Hi,

I am using a database adapter to pull data from 8 different tables(using joins and where conditions) and insert it into a single table. I am using an custom SQL in the database adapter configuration.
When trying to run this ESB service, it gives the following error:

failed. Caused by java.sql.SQLException: Io exception: Connection reset. The Pure SQL option is for border use cases only and provides simple yet minimal functionality.

I am not sure why the connection is resetting.
Is there a place where we can increase the session timeout value? I am not sure if that will solve the problem. Jus what to give a try.

Please advice.

Thanks,
RV

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2009

Added on Jul 2 2009

#soa-process-management, #soa-suite-discusssions

1 comment

703 views