RE: JDBC dirver for MSSQL Server

[Roman Prigozhin <Roman.Prigozhin@xxxxxxxxxxxxxxx>]

Charles,
  Please look again at the original message. There are 3 different methods.
Fist one and second one are exactly what you are talking about. They are
bulk inserts. Property you are talking about ""use block insert=true"" is
specific to the DB2 JDBC driver. Microsoft Type4 JDBC driver doesn't have
that property.

Roman

-----Original Message-----
From: CWilt@xxxxxxxxxxxx [mailto:CWilt@xxxxxxxxxxxx]
Sent: Thursday, April 15, 2004 8:08 AM
To: java400-l@xxxxxxxxxxxx
Subject: RE: JDBC dirver for MSSQL Server


What you are doing wrong is attempting to insert one row at a time.

If you've got 1000 rows ready to insert, insert them in one statement.

See if you can do a "blocked insert" into SQL Server using the JBDC driver.


Here's an example of a blocked insert into DB2:

//Create a database connection
Connection c = DriverManager.getConnection("jdbc:db2:*local;use block
insert=true");
BigDecimal bd = new BigDecimal("123456");

// Create a PreparedStatement to insert into a table with 4 columns
PreparedStatement ps =
  c.prepareStatement("insert into cujosql.xxx values(?, ?, ?, ?)");

// Start timing...
for (int i = 1; i <= 10000; i++) {
  ps.setInt(1, i);                       // Set all the parameters for a row
  ps.setBigDecimal(2, bd);
  ps.setBigDecimal(3, bd);
  ps.setBigDecimal(4, bd);
  ps.addBatch();                         //Add the parameters to the batch
}

// Process the batch
int[] counts = ps.executeBatch();

// End timing...




Notice the "use block insert=true" in the getConnection call.  Also the call
to ps.executeBatch().


HTH,
Charles


_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.