Hi,

I'm using MySQL database with Java and the connector (in subject line).
I have read and searched the group prior to posting, and find no clear
answer.

I would like to lock my table for writing, so would it be like this?
I have heard the suggestion, that executeUpdate in MySQL does a table
lock automatically, is this true?

Please feel free to instruct/assist.... Thanks..

try{
 Statement stmt = connection.createStatement();
 stmt.execute("LOCK TABLES databaseName.tableName WRITE");
 int rowNumber = stmt.executeUpdate(sql);
}
catch(SQLException ex) {
 System.out.println("SQL Exception" + ex.getMessage() );
 throw new SQLException(ex.getMessage() ,ex.getSQLState() );
     }
finally{
 Statement stmt = connection.createStatement();
 stmt.executeUpdate("UNLOCK TABLES");
 stmt.close();
}