Join many to many problem
Join many to many problem
- Subject: Join many to many problem
- From: Buyung Pamungkas <email@hidden>
- Date: Thu, 27 Feb 2003 00:04:35 -0800 (PST)
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.