Java EE (Java Enterprise Edition) General Discussion

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Intermittemt java.net.SocketTimeoutException: Read timed out

843833Apr 22 2010

Hi

I get this exception intermittently when my application tries to call a web service: Intermittemt java.net.SocketTimeoutException: Read timed out
Is this a network related issue?
Can someone please explain why I am getting this exception and how to prevent it in the future?
Please see the logs below:

AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.net.SocketTimeoutException: Read timed out
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
at org.apache.axis.transport.http.HTTPSender.readHeadersFromSocket(HTTPSender.java:583)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:143)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.vsnl.corp_pos.services.NmsClassStub.storeNumberRangeDetails(NmsClassStub.java:221)
at com.nms.GNPManagement.sendPOSNotification(GNPManagement.java:558)
at com.nms.GNPManagement.GNPUpdate(GNPManagement.java:929)
at com.nms.GNPManagement.updateGNPStatus(GNPManagement.java:164)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.mule.transport.soap.axis.AxisServiceComponent.doPost(AxisServiceComponent.java:580)
at org.mule.transport.soap.axis.AxisServiceComponent.onCall(AxisServiceComponent.java:131)
at org.mule.model.resolvers.CallableEntryPointResolver.invoke(CallableEntryPointResolver.java:52)
at org.mule.model.resolvers.DefaultEntryPointResolverSet.invoke(DefaultEntryPointResolverSet.java:50)
at org.mule.component.DefaultLifecycleAdapter.invoke(DefaultLifecycleAdapter.java:197)
at org.mule.component.AbstractJavaComponent.invokeComponentInstance(AbstractJavaComponent.java:83)
at org.mule.component.AbstractJavaComponent.doInvoke(AbstractJavaComponent.java:74)
at org.mule.component.AbstractComponent.invokeInternal(AbstractComponent.java:125)
at org.mule.component.AbstractComponent.invoke(AbstractComponent.java:153)
at org.mule.service.AbstractService.invokeComponent(AbstractService.java:933)
at org.mule.model.seda.SedaService.doSend(SedaService.java:234)
at org.mule.service.AbstractService.sendEvent(AbstractService.java:506)
at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:354)
at org.mule.routing.inbound.DefaultInboundRouterCollection.send(DefaultInboundRouterCollection.java:220)
at org.mule.routing.inbound.DefaultInboundRouterCollection.route(DefaultInboundRouterCollection.java:180)
at org.mule.transport.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:365)
at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:253)
at org.mule.transport.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:194)
at org.mule.transport.http.HttpMessageReceiver$HttpWorker.doRequest(HttpMessageReceiver.java:272)
at org.mule.transport.http.HttpMessageReceiver$HttpWorker.processRequest(HttpMessageReceiver.java:230)
at org.mule.transport.http.HttpMessageReceiver$HttpWorker.run(HttpMessageReceiver.java:190)
at org.mule.work.WorkerContext.run(WorkerContext.java:310)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
at java.lang.Thread.run(Thread.java:619)

{http://xml.apache.org/axis/}hostname:ppcrmn1

java.net.SocketTimeoutException: Read timed out
at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:154)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.vsnl.corp_pos.services.NmsClassStub.storeNumberRangeDetails(NmsClassStub.java:221)
at com.nms.GNPManagement.sendPOSNotification(GNPManagement.java:558)
at com.nms.GNPManagement.GNPUpdate(GNPManagement.java:929)
at com.nms.GNPManagement.updateGNPStatus(GNPManagement.java:164)
.
.
.

Thanks

Jerome Raghunandan

Frank Kulash

Hi, Anu,

You can try this:

MERGE INTO ORDERS	tgt
USING
( 
        SELECT  C.short_name, C.customer_id
	FROM 	customers C
) 			src 
ON (	tgt.customer_id = src.customer_id
   AND	tgt.order_date	> SYSDATE - 3
   )
WHEN MATCHED THEN
     UPDATE  SET     tgt.short_name = src.short_name;

It's surprising that the error message mentioned a semi-join, because you weren't doing a semi-join. An example of a semi-join is:

MERGE INTO ORDERS	tgt
USING
( 
        SELECT DISTINCT
	          C.short_name, C.customer_id
	FROM 	  customers C
	JOIN	  orders    o	ON  c.customer_id  = o.customer_id
	WHERE	  o.order_date	> SYSDATE - 3
) 			src 
ON (tgt.customer_id = src.customer_id)
WHEN MATCHED THEN
     UPDATE  SET     tgt.short_name = src.short_name;

but perhaps the optimizer re-wrote your IN sub-query as a semi-join.

An EXISTS sub-query is another way to get the results you want, unless it causes ORA-02070, also. Natrually, I can't test anythihng, since you didn't post any sample data.

Edited by: Frank Kulash on Apr 5, 2011 11:34 AM

798986

The explain plan for the select query does indicate a nested loop semi-join.

The query you suggested will not work as the inner query is actually (SELECT distinct customer id FROM orders O WHERE O.order_date > SYSDATE - 3 and short_name IS NULL) and Oracle does not allow columns referenced in the ON clause to be updated.

ORA-38104: Columns referenced in the ON Clause cannot be updated:

Frank Kulash

Hi,

user12201452 wrote:
The explain plan for the select query does indicate a nested loop semi-join.

The query you suggested will not work as the inner query is actually (SELECT distinct customer id FROM orders O WHERE O.order_date > SYSDATE - 3 and short_name IS NULL) and Oracle does not allow columns referenced in the ON clause to be updated.

So put that condition in a WHERE clause, instead:

MERGE INTO ORDERS	tgt
USING
( 
        SELECT  C.short_name, C.customer_id
	FROM 	customers C
) 			src 
ON (tgt.customer_id = src.customer_id)
WHEN MATCHED THEN
     UPDATE  SET     tgt.short_name = src.short_name
     WHERE   tgt.order_date	> SYSDATE - 3
     AND     tgt.short_name	IS NULL

The condition "tgt.order_date > SYSDATE - 3" can go either in the USING clause or the WHERE clause.

Edited by: Frank Kulash on Apr 5, 2011 4:10 PM

Better yet, forget about MERGE. Use UPDATE, as Kendenny suggested below.

kendenny

Another way to do it:

update orders o
   set o.short_name = (select short_name from customers c
                        where c.customer_id = o.customer_id)
 where o.order_date > sysdate - 3
   and o.short_name is null;

Peter Gjelstrup

How about,

alter table orders drop column short_name;

Getting rid of the redundancy eliminates the need for this update, hence the error is gone. Voila!

(Also frees the mind of having to think about why orders.short_name is a customer's short_name)

Regards
Peter

1 - 5

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2010

Added on Apr 22 2010

#java-technologies-for-web-services

0 comments

699 views

Java EE (Java Enterprise Edition) General Discussion

Intermittemt java.net.SocketTimeoutException: Read timed out

Comments

Post Details