If you say it doesn't work, what exactly does happen? Do you see any error/exception? In general I think you are better off by using different PK column values (e.g. the current approach will not be portable to Hibernate ORM). Or even yet better work with UUIDs. Still it should be possible on document stores.