mysql insert values not updating after some hours?

by

To solve this problem we need see to issue timeout period of mysql and closing jdbc connections correctly which was opened in programs like ajax pages ..

1)
" put these lines in /etc/mysql/my.conf
under
[mysqld]
#waiting time increase to 24 hour------------
interactive_timeout=86400
wait_timeout=86400 "

This way increase your inactive time to 24*60*60 seconds=1 day

2)

In the ajax pages the data continuously updates to the page by opening the database connection ,we should close this connection after use otherwise it will become leak and total heap will occupy finally blocks you to run the java application

To analyse the leaks use any heap analyser tools example eclipse workbench memory analyser(mat)

download from this link http://www.eclipse.org/mat/downloads.php

and analyse the heap fix the leaks

This steps solved by problem

More Related Contents:

  1. Getting data from mysql [closed]
  2. Connect Java to a MySQL database
  3. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  4. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  5. Using “like” wildcard in prepared statement
  6. Can we connect remote MySQL database in Android using JDBC? [closed]
  7. Android JDBC not working: ClassNotFoundException on driver
  8. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  9. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  10. JDBC MySql connection pooling practices to avoid exhausted connection pool
  11. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  12. Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  13. How to store Java Date to Mysql datetime with JPA
  14. Unable to get spring boot to automatically create database schema
  15. Hibernate: Automatically creating/updating the db tables based on entity classes
  16. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  17. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  18. Convert BufferedInputStream into image [duplicate]
  19. Passing parameters to a JDBC PreparedStatement
  20. how to get list of Databases “Schema” names of MySql using java JDBC
  21. Access denied for user ‘root’@’localhost’
  22. Invalid syntax error “type= MyISAM” in DDL generated by Hibernate
  23. Is there a way to retrieve the autoincrement ID from a prepared statement
  24. Why can Java not connect to MySQL 5.7 after the latest JDK update and how should it be fixed? (ssl.SSLHandshakeException: No appropriate protocol)
  25. Easiest way to convert a Blob into a byte array
  26. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  27. com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source
  28. How to use prepared statement for select query in Java?
  29. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  30. A persistent connection with JDBC to MySQL

Leave a Comment