Ask the Expert

RPG stored procedure hangs

When I try to call an RPG stored procedure from my Java program it hangs. In debug, when I step from the execute statement, it appears that control leaves my program and never returns.

JDBC runs in process or out of process. The default is out of process so your call was sent to a JDBC thread that hasn't returned a result (example, if there is an object lock etc, on the iSeries). You can run the request in a Java thread easily and let your application continue while the background thread waits for the result. You can set a timeout that says the request failed and have the foreground thread invoke error handling, issue and error message, etc. if the background thread hasn't returned the result after X seconds.


Ask your Web development questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: tips, tutorials and more.

This was first published in August 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: