returning autogenerated primary key after insertion
[219 byte] By [ketancmaheshwaria] at [2007-11-27 6:03:46] 
HiI am inserting a row into the database using simple jdbc statement. The primary key for that row is autogenerated by the database.Is there any way to get the primary key and return it to the user?
# 1
PreparedStatement ps = con.preparedStatement("INSERT INTO Table (title, name) VALUES ("test", "name")", PreparedStatement.RETURN_GENERATED_KEYS);ps.executrUpdate();ResultSet rs = ps.getGeneratedKeys();while (rs.next()) {primaryKey = rs.getInt(1);}Mike_Calgooa at 2007-7-12 16:46:52 >
# 2
By the way, it also depends on the Database and the JDBC driver used. This example doesn't work on Oracle and PostgreSQL for example.BalusCa at 2007-7-12 16:46:52 >
Database Connectivity Hot Topic
- Problem with big table (Oracle DB)
- jdbc
- how to hide username/password in JDBC program.
- Can i store file in Database?
- JDBC Driver Problem
- Maximum Parameters for PreparedStatement
- Instantiation Error in JAR file
- number of rows returned by SELECT LAST(column)
- PreparedStatement
- I have name of a savepoint, can i rollback to that savepoint?
- JDBC INSERT PROGRAM
- COUNT field incorrect or syntax error
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding