Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Insert in master detail table entity with composite primary key

 
Sasha Shams
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am working on a project with MySQL database Java GUI.

This is my SQL script

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

I created the entity classes with Netbeans 7.0 and created 4 classes:

Service
Reservation
ServiceTaken
ServiceTakenPK

but I cant enter values to the table and it gives me an error that I am trying to enter null values in as primary keys.

I have found the bug actually in Netbeans forum which is http://netbeans.org/bugzilla/show_bug.cgi?id=105084.

and accordingly I have added the following methods to the class ServiceTaken

upon inserting a new entry in the table I get this error :

Error Code: 1048
Call: INSERT INTO takenservice (PayRecBy, ServRecBy, Quantity, PayStat, ServUsedDate, ResvID, ServID) VALUES (?, ?, ?, ?, ?, ?, ?)
bind => [ddd, ddd, 0, ddd, null, null, null]

------------------------------------------------------
What I can do to fix this ? Please help me with this I am running out of time =/
 
James Sutherland
Ranch Hand
Posts: 553
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Seems like you have incorrectly mapped your class. Include you mappings (annotations/xml).

See,
http://en.wikibooks.org/wiki/Java_Persistence/Identity_and_Sequencing
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic