Thread: preparedStatement.executeBatch failed

Hello,
I'm having problem with this function and I think I'm doing something basically wrong.

I want to insert some records(200+) to DB in bulk. I don't get any errors or exception in the process
and yet no record actually inserted to DB.

I don't think it's problem in security or commit, since when I do similar process not in batch, it's working
and the records inserted into DB.

Appreciate any help.

The code:

/*
* should create the league in DB at the start of the season
* 
* UNDER DEVELOPMENT
*/
public void createLeagus() 
{
     String sqlSelect=	"SELECT team_num, place  " +
				"FROM clubs_information " +
				"WHERE current_league = 1 " +
				"ORDER BY place";
 
     String sqlInsert=	"INSERT INTO seasons_tables " +
				"(year, team_num, round, w_group, wins, losts, draw, positive, negative, points) VALUES " +
				"("+Season.getYear()+", ?, 1, ?, 0, 0, 0, 0, 0, 0)";
 
     System.out.println(sqlInsert);
     try
     {
	resultSet=statement.executeQuery(sqlSelect);
 
        PreparedStatement preparedStatement=connection.prepareStatement(sqlInsert);
 
       while(resultSet.next())
	{
		int place=resultSet.getInt("place");
		int group=0;
		int teamNum=resultSet.getInt("team_num");
 
               if(place%10 == 1 || place%10 == 0)
		    group=1;
		if(place%10 == 2 || place%10 == 9)
		    group=2;
		if(place%10 == 3 || place%10 == 8)
		    group=3;
		if(place%10 == 4 || place%10 == 7)
		    group=4;
		if(place%10 == 5 || place%10 == 6)
		    group=5;
 
                preparedStatement.setInt(1, teamNum);
		preparedStatement.setInt(2, group);
		preparedStatement.addBatch();
 
                System.out.println("INSERT NUM: " + teamNum + "TO GROUP : " + group );
	}
 
        preparedStatement.executeBatch();
 
    }
    catch(SQLException e)
    {
	System.out.println(e.getMessage());
    }
}

Hmm, just a thought off the top of my head.. setAutoCommit(false);?

Hi,
thanks for reply indeed this was the problem.

but why do have to set auto commit false in order to work with bulk?

Disabling autocommit allows an application to decide whether or not to commit the transaction in the event that an error occurs and some of the commands in a batch cannot be processed successfully.

That explains it.

OK. thanks.