One BMP for several postgresql tables

[greishka]

I deployed two bean components in JBoss server.From one component i want to refer to second component,(with out performing the Directory Service lookup operation ,both components are resided in the same container)
Plz send the reply on this .I involved in this.
Thanks in Advance

[jamesstrachan]

Well Nicolas,

BMP won't go back to reload from the database because it sees a primary key "2" that it believes that it has already loaded.

I suggest that you prefix each ID field in the BMP entity bean with the name of the table as below :-

table1/2
table2/2

This gives each combination of table and row a unique ID.

Good database design would also suggest rolling tables with the same structure into a single table, again using an extra key field to identify the contents of each original table.

James

[greishka]

Many thanks James, I solved the problem by creating a unique sequence for all generic tables, that can give unique id for all my tables.
Nicolas