where to set Mapped Primary Table

I am using sunOne studio 4 update 1, EE.

I have created a schema by doing New->Database->Database Schema, all OK.

I have then created related ejbs by doing New->J2EE->Related CMP Entity EJBs, all OK.

Now I want to view the mapping information so

I look at the CMP bean entry properties under the EJB module but I see no mapping information in Sun ONE AS Mappings tab. !!!

When I try to edit the protected field I get warning indicating that bean must have a valid Mapped primary table. It tells me to set a Mapped Primary Table in the main properties sheet for this bean.

My problem is I can not find this sheet

Please help before I go crazy

Thanks in advance

Tex...

[746 byte] By [704510] at [2007-11-25 9:42:02]
# 1

OK I know where to set these fields now.

It is set in the Sun ONE AS tab pane.

However, here comes the next problem.

The Wizard generated schema does not recognise the primary key fields so I can not map CMP to any table :-)

I think this is a bug because I have generated schemas from 3 different databases (IBM, MySWL, SAP) and the tables have primary key fields.

When I get a connection in Runtime Pane under Database node, I can see the primary fields are highlighted with red color.

However, when I obtain the schema using, New->Database->Database Schema, there are no key fields generated.

Anyone have any ideas, work around?

Thanks

Tex...

704510 at 2007-7-1 18:48:17 > top of Java-index,Development Tools,Java Tools...