• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

EJB with multiple MapKeys

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

I want to implement EJB with @MapKey and use JBoss 5.1.0.GA.
The following works perfectly (object A):

The database tables (mysql) will look like this:
Table A
Table B,
Table A_B with (A_id, name_id)


But I need more Maps like 'name' in A, e.g.

The database tables (mysql) will look like this:
Table A
Table B,
Table A_B with (A_id, name_id,symbol_id)


If I want to persist a object A (with a single object B in the Map name) I get this error:
Caused by: java.sql.BatchUpdateException: Field 'symbol_id' doesn't have a default value

I'm surprised a little bit about the databse structure and understand the error, but how to solve this??

Thank you
Thorsten
 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to our ORM/JPA forum where you might get some answers.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic