Use auto reconnect in your connect string. Cheers Daniel Jayapaul.E
-----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]] On Behalf Of Laxmikanth M.S. Sent: Friday, February 07, 2003 11:20 AM To: [EMAIL PROTECTED] Subject: COMMUNICATION LINK FAILURE Hi all, well and wish the same... I am getting a peculiar error ...... I am using MySQL3.23.43 with tomcat4.1.12..... I have written a bean which talks with DB and updates a table...this is running in a loop and so I have used PreparedStatement.... after 33 rows are Inserted it shows the below error "java.sql.SQLException: Communication link failure: java.io.IOException at org.gjt.mm.mysql.MysqlIO.clearAllReceive(Unknown Source) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.PreparedStatement.executeQuery(Unknown Source) at hkbeans.fundProfileToDB.updateprice(fundProfileToDB.java:2058) at hkbeans.fundProfileToDB.csvToDB(fundProfileToDB.java:70) at hkbeans.fundProfileToDB.main(fundProfileToDB.java:34)" what could be the problem.... thanks in advance for the help regards Laxmikanth ********************************************************************* Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. ********************************************************************* ======================================================================== === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com