The differences between GeneratedValue strategies

by

Check the latest doctrine documentation

Here is a summary :
the list of possible generation strategies:

AUTO (default): Tells Doctrine to pick the strategy that is preferred by the used database platform. The preferred strategies are IDENTITY for MySQL, SQLite and MsSQL and SEQUENCE for Oracle and PostgreSQL. This strategy provides full portability.

SEQUENCE: Tells Doctrine to use a database sequence for ID generation. This strategy does currently not provide full portability. Sequences are supported by Oracle and PostgreSql and SQL Anywhere.

IDENTITY: Tells Doctrine to use special identity columns in the database that generate a value on insertion of a row. This strategy does currently not provide full portability and is supported by the following platforms:

  • MySQL/SQLite/SQL Anywhere => AUTO_INCREMENT
  • MSSQL => IDENTITY
  • PostgreSQL => SERIAL

TABLE: Tells Doctrine to use a separate table for ID generation. This strategy provides full portability. This strategy is not yet implemented!

NONE: Tells Doctrine that the identifiers are assigned, and thus generated, by your code. The assignment must take place before a new entity is passed to EntityManager#persist. NONE is the same as leaving off the @GeneratedValue entirely.

SINCE VERSION 2.3 :

UUID: Tells Doctrine to use the built-in Universally Unique Identifier generator. This strategy provides full portability.

More Related Contents:

  1. Deep clone Doctrine entity with related entities
  2. Auto quote reserved words with Doctrine 2
  3. Ignore a Doctrine2 Entity when running schema-manager update
  4. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  5. Doing a WHERE .. IN subquery in Doctrine 2
  6. Count Rows in Doctrine QueryBuilder
  7. On delete cascade with doctrine2
  8. How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?
  9. Using EntityManager inside Doctrine 2.0 entities
  10. Using Relationships with Multiple Entity Managers
  11. How to use WHERE IN with Doctrine 2
  12. Select entries between dates in doctrine 2
  13. Too much data with var_dump in symfony2 doctrine2
  14. symfony2: how to use group_concat in QueryBuilder
  15. Subquery in doctrine2 notIN Function
  16. How to set up entity (doctrine) for database view in Symfony 2
  17. The EntityManager is closed
  18. Symfony 2: Creating a service from a Repository
  19. Symfony2 and Doctrine – Error: Invalid PathExpression. Must be a StateFieldPathExpression
  20. Doctrine 2 mysql FIELD function in order by
  21. Symfony 2.0 getting service inside entity
  22. Doctrine query builder using inner join with conditions
  23. How can I use SQL’s YEAR(), MONTH() and DAY() in Doctrine2?
  24. Can I access discriminator field from php in doctrine2?
  25. How to convert this to Doctrine 2 QueryBuilder format?
  26. How to force Doctrine to update array type fields?
  27. INNER JOIN Results from Select Statement using Doctrine QueryBuilder
  28. CASTING attributes for Ordering on a Doctrine2 DQL Query
  29. Doctrine2 association mapping with conditions
  30. How can I use DATE() in Doctrine 2 DQL?

Leave a Comment