File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes database batch updates Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "database batch updates" Watch "database batch updates" New topic

database batch updates

Alana Sparx
Ranch Hand

Joined: Feb 14, 2006
Posts: 121

Ok, strictly speaking not JDBC (again!)

I have a Sqlserver database that has a half-hourly batch feed from a mainframe. This mainframe is inserting data into a few database fields that require concurrent access to them by a web-based client. Currently, when the feed is happening, performance is severely degraded.

My question: does this feed from the mainframe (there is no push of data from the db --> mainframe) lock access to the table, so do users need to be patient and wait for the batch to end? I'm re-writing the whole application (db schema included), so if there's things I can do to stop this, please advise!

I agree. Here's the link:
subject: database batch updates
It's not a secret anymore!