From: Gavin Towey
Date: May 12 2011 6:38pm
Subject: RE: problem
List-Archive: http://lists.mysql.com/mysql/224992
Message-Id: <21A67E2153E64D48ACBD190732CB85911989808D@site1-mailbox1.pmgi.local>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

The server will disconnect idle connections after a while.  The wait_timeou=
t variable controls how many seconds it will wait.  You can set it for your=
 connection when you connect by issuing a query like:

SET SESSION wait_timeout=3DNNN;

Just give it a large enough value.

But also, since your program is going to be running continuously, there are=
 many other reasons it could lose the connection.  Your program should dete=
ct the error, and attempt to re-connect.

Regards,
Gavin Towey

-----Original Message-----
From: swaroop jois [mailto:jois_swaroop@stripped]
Sent: Monday, May 02, 2011 12:35 AM
To: mysql@stripped
Subject: problem

Hello friends, I have  MySQL server version  " 5.0.51a-Ubuntu"  installed o=
n Ubuntu 8.04 machine . I would describe briefly what we are doing .
Basically we have built a server that listen to Gprs connection from client=
  and accepts data in form packets and inserts that data into MySQL databas=
e.I run three commands .1.listening to Gprs connection and displaying all t=
he received packets on the terminal.2.Number of packets read will showed in=
 Java serial forwarder (Tinyos for reference )which listens on another port=
 3.command that invokes Java files  for inserting data into database table =
.
Initially when i run the command  everything works fine and when he  receiv=
e packets he is  able to insert data into table in MySQL database .

 He will still be listening on the port  (i.e he is running 24*7)Assume i r=
eceive data after 12 hrs .i am experiencing the problem of .It may not nece=
ssarily be 12 hrs .
 If i have to insert data again i have to  recompile the code again and run=
 all the commands .
The error that is troubling is Result for query failed.  SQLState =3D 08003=
i googled the error and found that this Sqlstate indicates connection does =
not exist .
I dont have any clues.Can any one help me please ?
Regards,Swaroop

IMPORTANT: This email message is intended only for the use of the individua=
l to whom, or entity to which, it is addressed and may contain information =
that is privileged, confidential and exempt from disclosure under applicabl=
e law. If you are NOT the intended recipient, you are hereby notified that =
any use, dissemination, distribution or copying of this communication is st=
rictly prohibited.  If you have received this communication in error, pleas=
e reply to the sender immediately and permanently delete this email. Thank =
you.