Announcement Announcement Module
Collapse
No announcement yet.
inserting data and fetching data at a time Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • inserting data and fetching data at a time

    Hi,
    i need to insert the data to the DB, then immediatley i need to get the all rows including present inserted values. How can i do it in jdbc template?
    I can call insert in my DAO then again call select in DAO, instead of this i need to do one operation but 2 functionality. How can i do it?
    Note: i am using simple query and willnot be using stored procedure.

  • #2
    I don't think you can insert and select in the same statement.
    Last edited by karldmoore; Aug 27th, 2007, 02:34 PM.

    Comment


    • #3
      Do you mean transactions ?

      Comment


      • #4
        If you want to lock the table, or set an isolation level that's one thing, but as I said I don't think you can peform the two operations in one statement.
        Last edited by karldmoore; Aug 27th, 2007, 02:34 PM.

        Comment

        Working...
        X