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.
MORE INFORMATION ON THIS TOPIC
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.
Dig deeper on Web Development
Related Q&A from Jim Mason
Java to Excel with the AS400 may be attractive, but if you have complex VBA macros in Excel, the JDBCODBC bridge will not work well for you. A better...continue reading
There are a couple of options for accessing AS/400 data, from the old way using Client Access ODBC drivers, to Java, to a new application from Groovy.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.