Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is the best way, in terms of performance, to do
multiple insert/update statements, a PreparedStatement or
Batch Updates?

Answers were Sorted based on User's Feedback



what is the best way, in terms of performance, to do multiple insert/update statements, a PreparedS..

Answer / ravi

It depends on the context. If you have many records that
need to be updated and you are not bothered about having
interactive session, I would choose batch. But that raises
the question, where do you store all the transactions that
need to be persisted/updated until the batch runs. Do you
want to store to a temporaray storage before updated. It
depends on the design on the system.

Is This Answer Correct ?    2 Yes 0 No

what is the best way, in terms of performance, to do multiple insert/update statements, a PreparedS..

Answer / nirmal

The easiest way is to use RMI to start the app and check to
see if it's already running.

The basic structure is this:

The main method of your app checks the RMI registry to see
if the app is started. If so, exit.
Otherwise, the main creates an instance of the app (which
is a remote object) and registers it in the RMI registry.
The class' constructor creates the GUI and displays it.
Alternatively, you could create a "start" method that you
call via RMI to start the app.

Is This Answer Correct ?    2 Yes 9 No

Post New Answer

More JDBC Interview Questions

how to prevent finally block from execution

4 Answers   Bosch,


Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.

0 Answers  


What is a PreparedStatement?

3 Answers   Infosys,


What is the difference between setmaxrows(int) and setfetchsize(int)?

0 Answers  


How MS-Access DB can be accessed over a network, using JDBC API?

0 Answers  


How can you use preparedstatement in jdbc?

0 Answers  


How can you tune SQL statements?

2 Answers   Wipro,


How can I manage special characters when I execute an insert query?

0 Answers  


How do I load a database driver with JDBC 4.0 / Java 6?

0 Answers  


What is connection data?

0 Answers  


i am user who logined the application..after that another valid user will also logind..so that is it neccessary to create jdbc connection for each and every user...plz explain it with proper answer...plz help me

5 Answers   IBM,


Which is best database for java?

0 Answers  


Categories