Hello, I'm designing a web service (using Axis2) which makes a database (Stored procedure) call through Hibernate. The stored procedure in turn does a series of business logic and makes a call to Subsystem B and waits for x time till the response comes back. If there is a timeout then throws an error. If not, gets the return data and passes it onto the web service, which then creates the SOAP response and sends it out.
My question and concern is regarding the "timeout" logic. How can the "timeout" be set in the web service layer (Skeleton). Coz if I dont tell the Skeleton to wait for that period of time, the connection might time out. Or to put it in another way, how do I override the default DB connection/response timeout with the expected timeout delay. Should this be done in the web service layer or in the hibernate layer (since we are using Hibernate to connect to the database) or should it be done in both? Your help is highly appreciated! Thanks, wsnewbie