• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate - Multiple Primary Keys Composite-id Mapping problems

 
David Chao
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I have 3 tables with multiple primary keys and trying to get composite-id to work. Here are the tables.

Table: tb_hl7MSH (regular id)
Primary key: reportID
Table: tb_hl7PID (composite-id mapping)
Primary Key: reportID, setIDPID
Table: tb_hl7OBR (composite-id mapping)
Primary Key: reportID, setIDPID, setIDOBR






Code:



Was able to retrieve the first set of rows for all the tables but second set isn't coming thru for OBR. I get everything but the OBR records. I verify in the database that the row exist. I'm using SQLServer database. Any help would be appreciated. Thanks in advance.

Frustrated Hibernate Mapping

[ October 30, 2006: Message edited by: David Chao ]

[ October 30, 2006: Message edited by: David Chao ]

[ October 30, 2006: Message edited by: David Chao ]

[ October 30, 2006: Message edited by: David Chao ]

[ Edited to use code tags - Paul Sturrock ]
[ October 31, 2006: Message edited by: Paul Sturrock ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic