Why does Spring-data-jdbc not save my Car object?

by

This is not related to transactions not working.
Instead, it’s about Spring Data JDBC considering your instance an existing instance that needs updating (instead of inserting).

You can verify this is the problem by activating logging for org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate. You should see an update but no insert.

By default, Spring Data JDBC considers an entity as new when it has an id of an object type and a value of null or of a primitive type (e.g. int or long) and a value of 0.
If your entity has an attribute with @Version annotation that attribute will be used to determine if the instance is a new one.

You have the following options in order to make it work:

  1. Set the id to null and configure your database schema so that it will automatically create a new value on insert. After the save your entity instance will contain the generated value from the database.

    Note: Spring Data JDBC will set the id even if it is final in your entity.

  2. Leave the id null and set it in a Before-Convert listener to the desired value.

  3. Let your entity implement Persistable. This allows you to control when an entity is considered new. You’ll probably need a listener as well so you can let the entity know it is not new any longer.

  4. Beginning with version 1.1 of Spring Data JDBC you’ll also be able to use a JdbcAggregateTemplate to do a direct insert, without inspecting the id, see https://jira.spring.io/browse/DATAJDBC-282. Of course, you can do that in a custom method of your repository, as is done in this example: https://github.com/spring-projects/spring-data-examples/pull/441

More Related Contents:

  1. How to insert one string into the middle of another string? [duplicate]
  2. Java + Mysql UTF8 Problem
  3. How to including variables within strings? [duplicate]
  4. Java: How to insert CLOB into oracle database
  5. Java code doesn't work [closed]
  6. How does array work? How to create a basic array data structure using java? [closed]
  7. Code after if block inside a for loop doesn’t work
  8. What are static factory methods?
  9. Why to use Interfaces, Multiple Inheritance vs Interfaces, Benefits of Interfaces?
  10. How to read a file from jar in Java?
  11. JPA : How to convert a native query result set to POJO class collection
  12. Background timer task in JSP/Servlet web application [duplicate]
  13. Selenium switch focus to tab, which opened after clicking link
  14. The method getDispatcherType() is undefined for the type HttpServletRequest
  15. Understanding spring @Configuration class
  16. Why I’m not able to unwrap and serialize a Java map using the Jackson Java library?
  17. Java array with more than 4gb elements
  18. How to send java.util.logging to log4j?
  19. Java – C-Like Fork?
  20. Changing parameters after bind in Struts 2
  21. How to update the label box every 2 seconds in java fx?
  22. how to test in Java that a class implements Serializable correctly (not just is an instance of Serializable)
  23. Java: Array with loop
  24. When to log a stacktrace for a caught exception
  25. Java ArrayList how to add elements at the beginning
  26. Jackson JSON Deserialization: array elements in each line
  27. Is it faster to access final local variables than class variables in Java?
  28. SWIG (v1.3.29) generated C++ to Java Vector class not acting properly
  29. SWT components relayout after visibility set to false
  30. Why do we need to extend JFrame in a swing application?

Leave a Comment