GeekInterview.com
Series: Subject: Topic:
Question: 2 of 148

JDBC - update many table on single submit

How to achieve a single value from web page to be updated/stored in many tables ?
Asked by: rjk1203 | Member Since Aug-2008 | Asked on: Oct 31st, 2011

View all questions by rjk1203   View all answers by rjk1203

Showing Answers 1 - 2 of 2 Answers
G S

Answered On : Nov 3rd, 2011

By using Transactions.

Every JDBC Driver will be able to perform Transactions. But its not recommended.

If we want to use out own Transactions we will set

con.setAutoCommit(false); and after executing the transactions we will execute con.commit();

  
Login to rate this answer.
sekhar

Answered On : Mar 15th, 2012

To update data in multiple table using single click ,we can go with triggers in database.we have different types of triggers like after insert,after update,after delete.Better using triggers.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Core Java

EJB

Hibernate

Java

Java Patterns

JDBC

JMS

JSP

OOPS

Ruby

Servlets

Spring

Struts

Websphere

Interview Coaching

Have you experienced being given too many tasks?

How do you deal and overcome major challenges?

What are the career opportunities available for MCA Graduates?

Provide an example of a goal that you successfully attained.

What are the career options available in Software Testing Industry?

How to Overcome Employment Gap during interview.

Importance of an MBA for an entrepreneur

Tell me three things about you, which are not found in your resume

BPO Career for BTech Graduates

Do you like working in a team or alone? Explain.

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe