Re: Join many to many problem
Re: Join many to many problem
- Subject: Re: Join many to many problem
- From: George Domurot <email@hidden>
- Date: Thu, 27 Feb 2003 08:22:24 -0500
After selected two entities in EOM, then performing the join
many-to-many command, the only changes you need to make to your model
are filling in the database table name and the attributes related to
the keys to connect the join table in EOM to the one in your database.
If the join table doesn't already exist, make sure you also create if.
It is unnecessary to change any of the relationship attributes.
On Thursday, February 27, 2003, at 03:04 AM, Buyung Pamungkas wrote:
Dear,
I have used OpenBase 7.0.8, Web Object 5.2 and jdbc
that built-in when I have installed WebObject. The, I
try to construct very simple application that using
many-to-many relationship
I have two entities, Task and Programmer.
Task
- pkTask (PK, auto increment, not shown both in server
and client side, locked)
- name (String(50), shown both in server and client
side, locked)
Programmer
- pkProgrammer (PK, auto increment, not shown both in
server and client side, locked)
- name (String(50), shown both in server and client
side, locked)
After made many-to-many relatonship between those two
entities, I have :
ProgrammerTask
- pkProgrammer (PK), not shown in server and client
side
- pkTask (PK), not shown in server and client side
The relationship
Progammer
- tasks (no destination, generated when I made
many-to-many relationship, I didn't make any changes)
- programmertasks (propagate primary key
Task
- programmers (no destination, generated when I made
many-to-many relationship, I didn't make any changes)
- programmertasks (propagate primary key
ProgrammerTask
- programmer (I didn't make any changes, shown in
server and client-side, locked)
- task (I didn't make any changes, shown in server and
client side, locked)
No problem when I execute SQL to database.
No problem when I built and ran application until I
tried to insert one record on ProgrammerTask.
I have insert "Buyung" on PROGRAMMER table and
"coding" on "TASK" table. When I inserted "Buyung" and
"coding" on PROGRAMMER_TASK, this is the error
messages :
"Save failed: Server exception: Adaptor
com.webobjects.jdbcadaptor.JDBCAdaptor@4e9dc5 failed
to provide new primary key for entity
'ProgrammerTask'!
I have tried many possibility and failed to insert :(
Please, give me a solution here. I will appreciated
it.
Best Regards,
Buyung
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.