aspose file tools
The moose likes EJB and other Java EE Technologies and the fly likes How to insert data into multiple tables? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Reply Bookmark "How to insert data into multiple tables?" Watch "How to insert data into multiple tables?" New topic
Author

How to insert data into multiple tables?

prasant sahoo
Greenhorn

Joined: Dec 14, 2007
Posts: 7
I am new to MySql & Struts.My recent project needs data to be inserted into multiple tables...please help me....
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 26183
    
  66

Prasant,
Welcome to JavaRanch!

In order to insert data into multiple tables, you need to write multiple statements which each insert data to one table. Check for dependencies between the tables so the lower level tables get loaded first.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
prasant sahoo
Greenhorn

Joined: Dec 14, 2007
Posts: 7
Thanks Jeanne.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: How to insert data into multiple tables?
 
Similar Threads
Sub-header in datatable column
how to Join Multiple tables
TableColumnModelListener Questions
sqlException column not found
hybernate doubt