aspose file tools*
The moose likes JDBC and the fly likes Any one point a good reading material about the combination in JDBC, Transactions in Multithreadded Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Any one point a good reading material about the combination in JDBC, Transactions in Multithreadded " Watch "Any one point a good reading material about the combination in JDBC, Transactions in Multithreadded " New topic
Author

Any one point a good reading material about the combination in JDBC, Transactions in Multithreadded

Swaroop Kunduru
Ranch Hand

Joined: May 22, 2006
Posts: 33
I wanted to read the material which discusses about multi-threaded JDBC writes with billion records at a time.

Thanks in advance.

Regards,

Swaroop Kunduru.


Regards,
Swaroop Kunduru
nate nick
Greenhorn

Joined: Jan 12, 2012
Posts: 1
You can leverage J2EE application server`s thread pool mechanism to handle batch processing of 1000 threads with 1 million records using cache mechanism, prepared statements and disable transaction logs. Avoid long- runnung transactions in the batch process. Also use database monitoring tool to track shared cache. Cpu memory can be monitored using task manager or using jconsole. An article on the same lines is here :
http://java.sys-con.com/node/415321?page=0,0

Happy Coding
 
Consider Paul's rocket mass heater.
 
subject: Any one point a good reading material about the combination in JDBC, Transactions in Multithreadded