Re: Retrieve auto-generated key. - Mailing list pgsql-jdbc

Have you tried using the “RETURNING” keyword?  For example…

String sql = “ INSERT INTO \“YourSchemaName\”.\”YourTableName\” (\”YourColName1\”, \”YourColName2\”) VALUES (?, ?) RETURNING \“YourSerialColName\”;

PreparedStatement ps = con.prepareStatement(sql);

ps.setString(1, “someValue”);

ps.setString(2, “anotherValue”);

rs = ps.executeQuery();

if (rs.next()) {

  System.out.println(“Auto-generated key is:” +rs.getInt(1));

}

Hope this helps

Hi

Ability to retrieve auto-generated key is one of the key features of JDBC3.
I tried using prepareStatement(String sql, int autoGeneratedKeys) , prepareStatement(String sql, int[] columnIndexes) and prepareStatement(String sql, String[] columnNames) but with no success . It returned with exception message as "Returning autogenerated keys is not supported."

I know there is already one thread for retrieve auto-generated key but look like that thread does not have one distinct   solution.

Is there any patch or workaround to retrieve auto-generated key ?

Thanks

Sangeeta