• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Swaroop Kunduru
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
nate nick
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic