Recursive table with non-primary key field problem
posted 4 years ago
Hi, I got a problem I really don't know how to tackle
Got 1 table:
AutonumericID NUMBER(20,0) PK
User VARCHAR(100) FK
Turns out that if 2 users have a folder with the same name, the FolderID is identical, for which the autonumericID is used. I know there should be a PK with USER & FolderID then but we can't make that change.
I'm using Hibernate, I'm able to do something like UserDAO.getFolders() and I would like to be able to ask that collection for a Collection of child folders, this was my attempt:
This doesn't work because its actually trying to map the parentFolderID to the autonumericID.
My goal is to prevent having to create another DAO for the folder class and having to map the childs manually.