Hi everybody,

I have an issue,
I want to delete a record from a table.


Actually I want to delete the record from USER_PROJECTS table, the columns are
project_id -- f.k to Project table, user_name-- f.k to User table.

I have the POJOs like

UserProjects.java

UserPrjParam param,
Project project,
User userName

---------------------

Project.java

projectId,
prjDesc
.
.
.
.

-------------------------

User.java

userName,
phoneNo,
.
.
.
.

---------------------------------

UserPrjParam .java

userName,
projectId


-----------------------------------

I am trying to delete record by giving like

UserProjects up =(UserProjects) session.get(UserProjects.class, "here I am getting problem")

If I have any specific value in the POJO i can mention. Bu I have only relation.

So I have tried this one like.

Project p = (Project) session.get(Project.class, projectId);
UserProjects up =(UserProjects) session.get(UserProjects.class, p);

But this is throwing error like "entity not found".......



Can any one please help me on this issue.



Thanks in advance


[/b]

Well you can delete the entry from the link table (the USER_PROJECTS) table this way.

user.getProjects().remove(project);
project.getUsers().remove(user);

session.update(user);

Hey,

I got ur point. But this won't be helpful to remove the entry in USER_PROJECTS. Moreover u r saying session.update(user), this will update the USER table.

But I need to delete the record from USER_PROJECTS table. Do i need to go for any delete query.









I expect ur reply



Thanks

Hi

I think this is not your prblem. but i have to comment on this line




here session.get() is session.get(Class clazz,Serializable id).

clazz is ok

but id it is a serializable object.
Normally if you have a id not composite-id the serializable id may string parameter. but in composite-id situation you have to mention what is the class for composite-id



in such condition you can pass a named Object to get method to load entity.



Amila

(Don't forget to rate if helps)