We are in the process of writting an application to record student grades from our web course management system to our Registrars student information system. The CMS connects to the Registrars SIS using JDBC across a fairly fast network, and submits the grades for each student by making a call to a stored procedure. The stored procedure will perform some sanity checks on the data before inserting it to the database. We are responsible for developing the stored procedure and also developing the java program on the CMS.

I'm looking for the options for sending the data from the CMS to the stored procedure. I can make individual calls to the stored procedure for each grade needing writing. Are there other options for sending a batch of students to the stored procedure? What are the performance characteristics of those other methods?

Thanks, Glen