Re: [JBoss-user] cmp-field and cmr-field mapped to same database column

[Alexey L. <al...@jb...>]

Hello Russell,

it should work properly. Try to upgrade your JBoss version. If the
issue is still there then submit a bug report.

alex

Thursday, June 12, 2003, 5:29:05 PM, Russell Chan wrote:

RC> Hi,

RC> I'm trying to find out if I can have a CMP EJB with a cmp-field
RC> accessors and cmr-field accessors mapping to the same database
RC> column/foreign key.

RC> I'm using jboss-3.2.1 with cmp2 (and xdoclet-1.2b)

RC> In my case, the actual foreign key is enough for some circumstances, and
RC> I don't want to trigger off another database read just to get the
RC> foreign key that's already in the table and that the cmp engine should
RC> already know about. 

RC> Having traced through the sql being generated, if I include accessors on
RC> the column as cmp-fields and a cmr-relation on the same field, the CMP
RC> engine appears to be including the column twice in the generated sql. 
RC> I'm also worried about the effect this will have on updates/inserts.

RC> Is there any way to properly do this in jboss-3.2.1?

RC> I've searched through the archives, and noticed a couple of people
RC> asking this same question.  The answer at the time was "not yet
RC> supported, but soon", but that was way back in December 2002.

RC> Thanks,
RC> Russ