CMP Many-to-Many relationship in EJB 1.1 problem.

[enigma69]

First of all, I am new here. I used the search as good as I could, and I can't find an answer to my question.

I have tried to make a many-to-many relationship on 2 entity EJB's, with the tag in my ejb-jar.xml. First of all, is this possible in jBoss 2.4.4 with EJB 1.1 for CMP EJB's??

- If it is, how do I get all relations of a certain row in one entity (I have one table DEVICE, and another one called CAPABILITY). So how do I get lets say all capabilities of device x, or how do I get all devices with capability y? I found a website http://www.caucho.com/products/resin-ejb/ of some product, here you can just call getDevices or getCapabilities which are implemented by the container.

- If it is not, how should I get a many-on-many relationship in jBoss 2.4.4 without using any extra program (I read about MVC-something somewhere, but I don't want to spend any money). I was looking at some table I should have in between, but it should have composite keys, and I can't find any good references on how to implement this in my entity bean. (All I can find are examples with one key).

I hope I didn't make to big a mess of my english, and somebody understands my question :). Can somebody please help me solve my problem.

[lobo]

> I have tried to make a many-to-many relationship on 2
> entity EJB's, with the tag in my
> ejb-jar.xml. First of all, is this possible in jBoss
> 2.4.4 with EJB 1.1 for CMP EJB's??
Relationships are a EJB 2.0-feature. Since JBoss 2.4.4 has some features of EJB2.0 implemented there are no cmp-relationships. You should use Jboss3.0beta (not for production of course).

> - If it is not, how should I get a many-on-many
> relationship in jBoss 2.4.4 without using any extra
> program
Use JBoss 3.0 or bean managed persistence. But bmp is no good way I think.

Sven.

[enigma69]

But I need it for production, and I don't want to use BMP.... it seems I have a problem then. When is jBoss 3.0 going to be stable?

[rocketman]

You could try MVC Soft's persistance manager with JBoss2.4.x (http://www.mvcsoft.com/).

[enigma69]

I didn't want to use other programs, I already found references to MVC Soft, but thanx anyway.

Is solved the problem with a workaround, which works nice, but wil pose a little difficult when jBoss 3.0.0 is stable, because it requires a little reprogramming.

[lasterra]

why don't you create a CMP Entity abovea N-M Table and manage de realetion with a SLSB????

Regards, Enrique.