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!

Can I change the query timeout for Dynamic SQL via jdbc on ALBPM 5.7.3?

657759Apr 30 2009 — edited Apr 30 2009

I have some queries (actually stored procs) that occasionally run over the time-limit for executeQuery calls and result in this:
fuego.components.SQLException: [TDS Driver]Read timed out
at fuegoblock.sql.DynamicSQL.executeQuery(DynamicSQL.java:345)

I cannot find where I can change the timeout for such calls to a safer limit, either locally for this execution or globally. Does such a setting exist?

I have optimized the queries as much as possible for now so need to use brute force to let them run to completion.

Thanks,
Todd

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2009

Added on Apr 30 2009

#business-process-management-suite, #soa-process-management

4 comments

1,993 views