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_swaroop@stripped> 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
