The Statement object executes static SQL statements. You execute SQL statements such as INSERT, UPDATE, and DELETE, which do not return result sets, using the executeUpdate method of the Statement object. Statements, such as CREATE TABLE and other data definition statements, can also be executed using executeUpdate.

When using the iAnywhere JDBC driver to perform batched inserts, it is recommended that you use a small column size. Using batched inserts to insert large binary or character data into long binary or long varchar columns is not recommended and may cause a degradation of performance. This is because the iAnywhere JDBC driver must allocate large amounts of memory to hold each of the batched insert rows. In all other cases, using batched inserts should provide better performance than using individual inserts.

If you do not want your application to use batched inserts to insert large data into a long binary or long varchar column, the default maximum field size of any batched insert column is 256K. If your application needs to batch inserts with more than 256K of column data, then a larger maximum field size must be specified in the Statement.setMaxFieldSize() method before the batch insert performed.

The following code fragment illustrates how to execute an INSERT statement. It uses a Statement object that has been passed to the InsertStatic method as an argument.

public static void InsertStatic( Statement stmt )
{
  try
  {
    int iRows = stmt.executeUpdate(
      "INSERT INTO Departments (DepartmentID, DepartmentName)"
      + " VALUES (201, 'Eastern Sales')" );
    // Print the number of rows inserted
    System.out.println(iRows + " rows inserted");
  }
  catch (SQLException sqe)
  {
    System.out.println("Unexpected exception : " +
              sqe.toString() + ", sqlstate = " +
              sqe.getSQLState());
  }
  catch (Exception e)
  {
    e.printStackTrace();
  }
}

Notes

To run the JDBC Insert example

1. Using Interactive SQL, connect to the sample database as the DBA.

2. Ensure the JDBCExample class has been installed.

   For more information about installing the Java examples classes, see Preparing for the examples.

3. Define a stored procedure named JDBCExample that acts as a wrapper for the JDBCExample.main method in the class:

   CREATE PROCEDURE JDBCExample( IN arg CHAR(50) ) EXTERNAL NAME 'JDBCExample.main([Ljava/lang/String;)V' LANGUAGE JAVA;

4. Call the JDBCExample.main method as follows:

   CALL JDBCExample( 'insert' );

   The argument string 'insert' causes the InsertStatic method to be invoked.

5. Confirm that a row has been added to the Departments table.

   SELECT * FROM Departments;

   The example program displays the updated contents of the Departments table in the database server messages window.

6. There is a similar method in the example class called DeleteStatic that shows how to delete the row that has just been added. Call the JDBCExample.main method as follows:

   CALL JDBCExample( 'delete' );

   The argument string 'delete' causes the DeleteStatic method to be invoked.

7. Confirm that the row has been deleted from the Departments table.

   SELECT * FROM Departments;

   The example program displays the updated contents of the Departments table in the database server messages window.