Forums Register Login

Recursive table with non-primary key field problem

+Pie Number of slices to send: Send
Hi, I got a problem I really don't know how to tackle

Got 1 table:

FOLDER
----------
AutonumericID NUMBER(20,0) PK
User VARCHAR(100) FK
FolderID VARCHAR(250)
ParentFolderID VARCHAR(250)

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.

Any idea is welcome, thanks in advance
An elephant? An actual elephant. Into the apartment. How is the floor still here. Hold this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 987 times.
Similar Threads
problem with one-to-one mapping
identifier of an instance of <class> was altered from old to null
Populate child table foreign keys from primary table?
Removing from collection in many-to-one bi-directional mapping not working
OneToOne relation gives problem
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 08:55:29.