Hi,

Finally got middlegen hibernate plug-in working, and loaded up an existing database.

The current application code was handling the foreign key relationships, but I would like to change this when I rearchitect everything and employ hibernate.

Obviously, no relationships are showing in the GUI, but I can't find a way to add them! Can anyone point me in the right direction?

Many thanks,

David

PS Using SAPDB 7.4

Outside of adding the constraints to the database, you can use the table tag with the cross reference attribute to setup the relationships if the constrints don't exist.

http://boss.bekk.no/boss/middlegen/ant/table.html

So there's no way to do it through the GUI? I imagined I could just specifiy it there, or even better, do it by dragging the mouse.

If not, can this be added as a feature request?

Could someone give an example how the pktable should be defined? I looked into document but found it too vague to start with.


I ran into a problem that the tables i am working on, contain unique index constraint, not primary key constraint. And middlegen only tries to get primary keys only.

Thanks

Albert L.

Sorry, I posted this message in wrong thread. Should've been in new thread.

But I found out answer to my question. It uses pkcolumnsoverride, for example, <table name="tbl_nokey" pkcolumnsoverride="col1, col2, col3"/> to create composite-id on col1,col2,col3. Need to download src from CVS not from sourceforge download pages since it was too old (Jan 8 2004). The patch was put in sometime in March or May 2004.

Sorry again!

If you want to add a new linkage, that is quite easy (i guess). To define a new linkage from alu_nokey to alu_nokey_xref, something like this within middlegen task should work.

<table name="alu_nokey" pkcolumnsoverride="col1,col2">
<crossref fktable="alu_nokey_xref" fkcolumn="pk1" pkcolumn="col1"/>
<crossref fktable="alu_nokey_xref" fkcolumn="..." pkcolumn="..."/>
</table>

where:
table alu_nokey columns: (no any primary keys defined for this table)
col1
col2
col3
col4

table alu_nokey_xref columns: (primary key constraints are pk1, pk2)
pk1
pk2
col1
col2

see linkage created by middlegen as:
http://home.comcast.net/~albert.lu/publ ... ossref.JPG

(pkcolumnsoverride needs new src from cvs not from sourceforge download page)

You you can create a Feature request in Middlegens JIRA.