CrudRepositories with dynamic table names [DATAJDBC-358]

[spring-projects-issues]

Philipp Jauert opened DATAJDBC-358 and commented

We have a few set of database tables which should created, duplicated (renamed) and deleted dynamically during runtime. Thats are "audit" tables with a numeric suffix (e.g. USER_2, USER_42, ADDRESS_2, ADDRESS_42).

So we have the same structure but the table name differs. It is possible to use different tablenames on an existing CrudRepository when we invoke the methods?

---

Issue Links:

• DATAJDBC-208 SqlGenerator caches statement thereby disabling dynamic NamingStrategies
  ("duplicates")

[spring-projects-issues]

Jens Schauder commented

Currently this doesn't work, because Spring Data JDBC does cache generated SQL statements.
But it should be fairly easy to make this caching controllable by the NamingStrategy.

Add an attribute getCacheKey or similar and the returned key is used to maintain separate caches of the statements.

The NamingStrategy then could create different table names, column names and cache keys depending on the context

[spring-projects-issues]

Jens Schauder commented

This is a duplicate of DATAJDBC-208