Getting Socket Exception ,No buffer space ,maximum connection reached

[pooja rathi]

package Simple;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Time;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.text.*;

public class CurrentProg {
	//connecting to the database
	
  private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
  private static final String DB_CONNECTION ="jdbc:mysql://localhost:3306/db?autoReconnect=true"; 
  private static final String DB_USER = "root";
  private static final String DB_PASSWORD = "root";
  static Connection dbConnection = null;
  static Statement statement = null;

  static int total=1;
  
  //Searching between startdate and enddate
  
  public static java.util.LinkedList searchBetweenDates(java.util.Date startDate, java.util.Date endDate) {
      
	  	java.util.Date begin = new Date(startDate.getTime());
	  	java.util.LinkedList list = new java.util.LinkedList();
	  	list.add(new Date(begin.getTime()));
	  	java.util.Date end = new Date(endDate.getTime());
	  	endDate.setTime(endDate.getTime() + 24*3600*1000);
  	    Calendar cal = Calendar.getInstance();
  	    cal.setTime(begin);

	  	while(begin.compareTo(endDate)<0){
	  	begin = new Date(begin.getTime() + 86400000);
        list.add(new Date(begin.getTime()));        
      	Timestamp timestamp = new Timestamp(new Date().getTime());
  	    
      	//For a single day calculation: 24hours*60mins=1440 /2 (2 mins time difference as per the requirement) = 720 
      	
      			for (int j = 0; j < 720; j++) {
  	  	    	cal.add(Calendar.MINUTE, 2);	        
  	  	        timestamp = new Timestamp(cal.getTime().getTime());
  		        String S = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(timestamp); 	 	        
  	  	        String[] parts = S.split(" ");
  	  	        String date=parts[0];
  	  	        String time=parts[1];
  	  	        cal.getTime().toString();
  	  	    
  	  	   // To create data loop into a List
 	  	    List<String> records = new ArrayList<String>();
  	  	    StringBuffer record = new StringBuffer();
  	        for (int i = 1; i <= total; i++) {
  	        records = new ArrayList<String>(total);     	

  		    int a2 = 220 + j % 31; // 230 - 244 by 1
  		    String wString = Integer.toString(a2);
  		    String a = String.valueOf(a2);   
  		    double b2 = 0.00 + j % 3.7  ; // 1.3 - 3.9 by 0.1 
  		    String aString = Double.toString(b2);
  		    String b = String.valueOf(b2);
  		    b = b.substring(0, Math.min(b.length(), 5));
  		 
  		    
  	      record.delete(0, record.length());
  		  record.append(a + "," + b  +  ",'"+  date + "', '"+  time + "'");
  		  record.append("\t\t");	  
  		  record.append("\n");
  		  records.add(record.toString()); 
  		  
  		  //Insert Query
  		  String insertTableSQL = "INSERT INTO cmd1"
		          + "(a, b, date, time) " + "VALUES"
		          + "("+record.toString()+")";
		          System.out.println("insertTableSQL - " + insertTableSQL);	            //  Statement.executeUpdate(insertTableSQL);

		  try {

			      dbConnection = getDBConnection();
			      statement = dbConnection.createStatement();
			      statement.executeUpdate(insertTableSQL);
			      System.out.println("Record is inserted into Db table!");
		  		  } catch (SQLException e) {
		  		  System.out.println(e.getMessage());
		  		  } 
		  	finally {
		  	//	httpPost.releaseConnection()
		  			 try{
		  		         if(statement!=null)
		  		            dbConnection.close();
		  		      }catch(SQLException se){
		  		      }
		  		      try{
		  		         if(dbConnection!=null)
		  		        	dbConnection.close();
		  		      }catch(SQLException se){
		  		         se.printStackTrace();
		  		      }
		  		   
		  		  } 		               
  	     }
	  	}
  	    }
		return list;
	  	}
	   
  @SuppressWarnings("unused")
public static void main(String[] args) throws Exception {
	 
	  //To enter startDate and enddate
	//  EntityManagerFactory.getCache().evictAll;


	SimpleDateFormat  startDate=new java.text.SimpleDateFormat("yyyy-MM-dd");
	SimpleDateFormat  endDate=new java.text.SimpleDateFormat("yyyy-MM-dd");
	
	  			java.util.LinkedList hitList = searchBetweenDates(
	            startDate.parse("2016-01-01"),
	            endDate.parse("2016-03-01"));
	  			String[] combo = new String[hitList.size()];
	  			for(int i=0; i<hitList.size(); i++)
	            combo[i] = new java.text.SimpleDateFormat("yyyy-MM-dd").format(((java.util.Date)hitList.get(i)));
	            
  }

private static void insertRecordIntodb() {
    //
  }
  private static Connection getDBConnection() {
    Connection dbConnection = null;
    try {
      Class.forName(DB_DRIVER);
    } catch (ClassNotFoundException e) {
      System.out.println(e.getMessage());
    }
    try {
      dbConnection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);
      return dbConnection;
    } catch (SQLException e) {
      System.out.println(e.getMessage());
    }
    return dbConnection;
  }
  
} 

Here I am trying to connect java program with database but when i am trying to insert large data say for 1 month so its only fetching 16000 records not more than that i want the data should be inserted as per the given date range what should i do to get that . In stacktrace its showing an exception as no buffer space available maximum connection reached. Thanks In advance

[Les Morgan]

If I follow the flow of your code correctly, you get a connection and new statement every time through your for loop, this is not the way to do it.

Get your connection outside the loop, and build a parameterized query for your insert.

Then update you parameters in the loop and then execute. That way you don't get 16,000 distinct connections and statements and causing your program to run out of resources.

1 connection and 1 parameterized query is all you need.

[pooja rathi]

can you explore more a little bit by giving an example