Seam-gen problem with 2 foriegn keys for the same table

[ahmadadly]

Hi all,
I am newbie with jBoss Seam. I have a problem with Seam-gen when developing exchange sample. I have 2 tables in my database, currency table [code, name, symbol, rate] and transaction_history table [id, currency_from, currency_to, transaction_date, amount].

currency_from is a foreign key for Currency entity, that user want to convert an amount from this currency

currency_to is a foreign key for Currency entity, that user want to convert an amount to this currency

when I ran seam-gen tool to generate entities I got 2 instances in TransactionHistoryHome class with 2 fields like:

     @In(create = true)
     CurrencyHome currencyHome;
     @In(create = true)
     CurrencyHome currencyHome;

as you can see, these 2 instances should reflect the foreign key relations between TransactionHistory and Currency entities. I think seam-gen has a bug with generating entities from database.

I will appreciate any help in advance

[dsailer.d.sailer.comcast.net]

this is a known issue. I recall seeing a jira for it. It really comes down to the fact that it's not possible to generate an intelligent CRUD app without having more context than just the hibernate relationship annotations. You will most likely find yourself changing a lot of what seam-gen generates anyway and having to understand how it works. I found it a good way to learn seam. But to start out, just delete one of the two currentyHome's.

[dan.j.allen]

I fixed seam-gen in SVN so that it only creates one of the injection points. Unfortunately, you cannot establish the relationship in the UI because it's just outside of what we can accomplish with the reverse engineering without introducing unnecessary complexity. Therefore, it will be up to you to make the UI work. At least it compiles now ;)

[ahmadadly]

Thanks Dan Allen and d sailer for your reply and help

[ahmadadly]

Hi agian,

I have removed the duplicated instance from my class. But I got another problem, which is the 2 relations will reflect each other.

By another meaning, when I try to create new record of the TransactionHistory in the web application and try to select specific From Currency instance, I found that the To Currency instance is the same in TransactionHistoryEdit.seam!

Can anyone help in this?