Thread: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying

08 Jun 2011 03:20:00,022 DefaultQuartzScheduler_Worker-8 ERROR HRPreparedStatement:135 - error occurred while executing executeQuery()
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutp utStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStre am.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedO utputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputS tream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2637)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 54)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1266)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeQuery(NewProxyPreparedStatement.java:76)
at com.scraper.sql.HRPreparedStatement.executeQuery(H RPreparedStatement.java:133)
at com.scraper.ScrapeRequestHandler.getScrapeRequestD ata(ScrapeRequestHandler.java:1076)
at com.scraper.AgentInteraction.getScrapeRequestData( AgentInteraction.java:4092)
at com.scraper.DirectUpdateScheduledAction.getScrapeR equest(DirectUpdateScheduledAction.java:104)
at com.scraper.DirectUpdateScheduledAction.run(Direct UpdateScheduledAction.java:127)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unkno wn Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.util.MethodInvoker.invoke(Meth odInvoker.java:270)
at org.springframework.scheduling.quartz.MethodInvoki ngJobDetailFactoryBean$MethodInvokingJob.executeIn ternal(MethodInvokingJobDetailFactoryBean.java:224 )
at org.springframework.scheduling.quartz.QuartzJobBea n.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:2 02)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run (SimpleThreadPool.java:529)


** END NESTED EXCEPTION **



Last packet sent to the server was 1 ms ago.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2652)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 54)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1266)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeQuery(NewProxyPreparedStatement.java:76)
at com.scraper.sql.HRPreparedStatement.executeQuery(H RPreparedStatement.java:133)
at com.scraper.ScrapeRequestHandler.getScrapeRequestD ata(ScrapeRequestHandler.java:1076)
at com.scraper.AgentInteraction.getScrapeRequestData( AgentInteraction.java:4092)
at com.scraper.DirectUpdateScheduledAction.getScrapeR equest(DirectUpdateScheduledAction.java:104)
at com.scraper.DirectUpdateScheduledAction.run(Direct UpdateScheduledAction.java:127)
at sun.reflect.GeneratedMethodAccessor45.invoke(Unkno wn Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.util.MethodInvoker.invoke(Meth odInvoker.java:270)
at org.springframework.scheduling.quartz.MethodInvoki ngJobDetailFactoryBean$MethodInvokingJob.executeIn ternal(MethodInvokingJobDetailFactoryBean.java:224 )
at org.springframework.scheduling.quartz.QuartzJobBea n.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:2 02)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run (SimpleThreadPool.java:529)
08 Jun 2011 03:20:00,023 DefaultQuartzScheduler_Worker-8 ERROR ScrapeRequestHandler:1148 - Login info not found
08 Jun 2011 04:40:00,035 DefaultQuartzScheduler_Worker-1 ERROR HRPreparedStatement:135 - error occurred while executing executeQuery()
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe


Hi can somebody please help me in solving out the above problem
I am getting this exception not knowing how to handle this exception
I should be able to handle the exception and the process should continue


Thanks n Regards
Raaj

java.net.SocketException: Broken pipe generally occurs when you attempt to write into the connection, which has already been closed on the other end. Check your implementation by tracing the exception occurrence line numbers.