Hi. We are using Spring JDBC support classes to access the database. Currently, we are using PostgreSQL as the development and testing database but the production system could be MySQL. ID columns are sequences (auto increment for MySQL in the future plan). I found this utility class: DataFieldMaxValueIncrementer with implementation for different RDBMS (PostgreSQL, MySQL, DB2 ...) Can I depend on it to achieve portability between PostgreSQL sequences and MySQL auto-increment columns? Thanks.
posted 8 years ago
Yes, that's the idea - you abstract away the source of the unique IDs for your persistent objects, thereby making the potential migration from PostgreSQL to MySQL a matter of setting up the new database schema and reconfiguring your application with a different incrementer implementation.