JDBC insert


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: JDBC insert

Hybrid View

  1. #1
    Fredrik Magnusson Guest

    JDBC insert

    How to I know which position the row was inserted at when executing the
    following code:

    stmt.executeUpdate("INSERT INTO users (username, email) VALUES ('Test',
    'test@test.com')");

    The application should actually return the primary key from the inserted row
    (a field called "uid"). I've looked everywhere in the JDBC API and it seems
    like Sun forgot to add something like a getInsertionPosition() method.

    Any help is greatly appreciated,
    Fredrik Magnusson




  2. #2
    Giri Guest

    Re: JDBC insert


    Hi,

    I can think of one round-about way to do this. write a database after insert
    trigger for the USERS table. this trigger will capture the ROWID value from
    the USERS table and store it in a temp table (as DB triggers cannot return
    values). after the execUpd in the Java code, make a call to the temp table,
    get the rowid value and use that to get the UID from USERS table

    also, ensure that AutoCommit is not on. i have given this based on the assumption
    that you are using Oracle.

    Rgds

    Giri


    "Fredrik Magnusson" <fredrik.magnusson@home.se> wrote:
    >How to I know which position the row was inserted at when executing the
    >following code:
    >
    >stmt.executeUpdate("INSERT INTO users (username, email) VALUES ('Test',
    >'test@test.com')");
    >
    >The application should actually return the primary key from the inserted

    row
    >(a field called "uid"). I've looked everywhere in the JDBC API and it seems
    >like Sun forgot to add something like a getInsertionPosition() method.
    >
    >Any help is greatly appreciated,
    > Fredrik Magnusson
    >
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center