Swaroop:
How are you handling the connections to db ? only one, with a pool,
something adhoc ?.
It looks like the connection is only one and expires after a time out
and you get the error that there is no connection.
Carlos
On 5/2/2011 3:15 PM, Andrés Tello wrote:
Seems more a java issue than a mysql issue... check for your parameters for
any keepalive or persostent option...
I think you wouldn't need to recompile just re-run or at leat, reboot the
server..
On Mon, May 2, 2011 at 2:34 AM, swaroop jois<jois_swar...@yahoo.com> wrote:
Hello friends, I have MySQL server version " 5.0.51a-Ubuntu"
installed on 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 database.I run three commands .1.listening to Gprs connection
and displaying all the 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
receive 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
receive data after 12 hrs .i am experiencing the problem of .It may not
necessarily 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 = 08003i
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
