Question about threadpool

[waleed.k.omran]

Hi

I'm developing a program that read from text file line by line and for each line it create a new thread for it and insert the record into database

ThreadPoolExecutor executer = (ThreadPoolExecutor) Executors.newFixedThreadPool(threadPoolSize);

My question is how i can control the insertion of the records?? since I have two types of records insert or update and in the text file i want it to move in sequance not randomly.

so,how i can control the threadpool???

[Steve11235]

Unless you have some really exotic reason to use threads here, *don't*. Read a line from the text file, write it to the database, loop.

If you *must* use threads, you should have only two, one to read the text file, and one to update the database. You will need to use a synchronized object like Vector to hold the lines read in one thread until the other thread writes them to the database.

If you have more than one database thread, you will have to either synchronize use of one connection, or you will have to create a connection for each thread. Either way makes no sense.