Can't push 5 lacs records in mysql at once.

I'm trying to push 5 lacs records in a single go as my requirement says that to me.
I'm getting hea space error.

Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Unknown Source)
at java.util.Arrays.copyOf(Unknown Source)
at java.util.ArrayList.ensureCapacity(Unknown Source)
at java.util.ArrayList.add(Unknown Source)
at com.mysql.jdbc.ConnectionImpl.closeAllOpenStatements(ConnectionImpl.java:1583)
at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4381)
at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1564)
at example.fun.DbConnection.main(DbConnection.java:64)

Is there any way to resolve this issue ?

My sample code is:-

/**
 * 
 */
package example.fun;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 * @author vk185052
 *
 */
public class DbConnection {

/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

System.out.println("******STARTED********");
				
		Connection con = null;
		PreparedStatement pstmt, pstmt2 = null;
		ResultSet rs = null;
		String str, str2 = new String();
		
		try{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			con = DriverManager.getConnection("jdbc:mysql://localhost/company", "root", "password");
			
			if(!con.isClosed()){
			
				System.out.println("Successfully connected to mysql database");
				
				for(int i=1; i<=500000 ; i++){
				
				str = "insert into employee_basic(emp_code, emp_name) values ('"+i+"', 'Vijay Kumar')";
				pstmt = con.prepareStatement(str);
				pstmt.executeUpdate();
				System.out.println("Success");
			
				}
				
				System.out.println("Successfully pushed records");
			}

}
		catch(Exception e){
			
			System.out.println("Exception "+e);
			
		}
		finally{
			
			try{
						
			    if(con != null){
			
			      	con.close();
			    }
			}
			
			catch(Exception e ){
				
				System.out.println("Exception thrown while closing connection "+e);
			}
		}
	}

}

Moving to our JDBC forum.

Why are you using a PreparedStatement if you then proceed to feed it a concatenated string? You should be using pstmt.setString(..., ...) instead.

Ulf Dittmer wrote:Why are you using a PreparedStatement if you then proceed to feed it a concatenated string? You should be using pstmt.setString(..., ...) instead.

wats the big deal in that ?
Any specific reason?

The fact that you're creating lots of unnecessary string objects in what is obviously a low-memory situation should be reason enough.

But you're also throwing away all the benefits of prepared statements. The way you're using it, you might as well use a regular Statement.

Pseudocode