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