Error on Batch Update using Oracle

[Tushar Ravi]

Hi there,

I am facing an error while executing the below code.

public void batchUpdate() throws Exception {
		Connection conn = null;
		PreparedStatement statement = null;
		StringBuilder sql = new StringBuilder();
		try {
			conn = getOracleConnection(); // Using JDBC commands

			sql.append("INSERT INTO EMPLOYEE (ID,NAME) VALUES (1,'JOHN')");
			sql.append("INSERT INTO EMPLOYEE (ID,NAME) VALUES (1,'JIM')");
			statement = conn.prepareStatement(sql.toString());
			statement.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			statement.close();
			conn.close();
		}
	}

The exception thrown is

java.sql.SQLException: ORA-00933: SQL command not properly ended

If i give semicolon at the end of the sqls i get
java.sql.SQLException: ORA-00911: invalid character

Any suggestions appreciated.

Thanks in advance

Tushar.

[Rupesh Mhatre]

PreparedStatement statement = conn.prepareStatement("INSERT INTO EMPLOYEE (ID,NAME) VALUES (?,?)");
			
statement.setInt(1,1);
statement.setString(2,"JOHN");
statement.addBatch();

statement.setInt(2,1);
statement.setString(2,"JIM");
statement.addBatch();

statement.executeBatch();	

I think this should help