How to map a single BMP instance with multiple rows returned

vishal_msit Jul 8, 2004 2:32 AM

I m facing a gr8 problem.
I have a table named TRIANINFO
when my jsp client passes train number, database returns a multiple rows related that train number. So how should I catch those rows in my client ??

If any one knows answer reply fast .

Thanking you.

1. Re: How to map a single BMP instance with multiple rows retu

jamesstrachan Jul 8, 2004 12:41 PM (in response to vishal_msit)

Vishal,

Have a look at the discussion chain on topic :-

http://www.jboss.com/index.html?module=bb&op=viewtopic&t=50863

That provides a complete solution to a similar problem with two differences.

Diff. 1

That problem was for a singleton solution, in which only one Entity Bean exists in the database.

In your case, you need a BMP entity bean for each train number. So replace the fixed primary key by train number.

Diff. 2

In the example, the Entity Bean stores and returns an ArrayList of String objects. You will presumably need to store and return an ArrayList of TrainInfo (or whatever) objects.

Hope this helps.

James
Actions