On Fri, 9 Feb 2018, Adrian Klaver wrote:

I remember seeing it, so I went back to look at the message. Turns out you sent it to me only. Unfortunately I am not a Java programmer so I did not catch the error. For the record:


Ah, blast... Apologies to everyone concerned. I need to understand why my mail reader (Alpine on Linux) insists on defaulting to the original poster's e-mail address when I hit 'Reply' rather than the group list. It's not doing that with any other mail list I subscribe to.

I was trying to be careful and changed the address manually for all messages except this one.

Thanks, Adrian! I was sure that I sent it - just not to the right place as it turns out.

"
Here is the JDBC code:

           try {
               conn.setAutoCommit(false);
               PreparedStatement sth = null;
               ResultSet rs = null;

               // Insert new
               sth = conn.prepareStatement(addAssetType);
               sth.setString(1, name);
               sth.execute();

               sth = conn.prepareStatement(lastTypeId);
               rs = sth.executeQuery();
               if (rs.next()) {
                   long id = rs.getLong(1);
                   result.put("id", id);
                   result.put("name", name);
               }
               else {
throw new WebApplicationException(buildError(BAD_REQUEST, "Lookup of most recent sequence failed"));
               }
               conn.commit();
           }
           catch (SQLException e) {
               conn.rollback();
throw new WebApplicationException(buildError(BAD_REQUEST, e.getMessage()));
           }


Where:

   private final static String addAssetType =
           "INSERT INTO udm_asset_type_definition (def_name) "
           + "VALUES (?)";

private final static String lastTypeId = "SELECT currval( pg_get_serial_sequence('udm_asset_type_definition', 'def_id'))";

Code with this exact same structure (but different SQL, obviously) is working just fine with five other tables using sequences. The above code snippet always produces '0' for the id. If I use the 'INSERT .. RETURNING..' approach, it gives the right answer.
"

--

Reply via email to