[JBoss-dev] [ jboss-Bugs-520650 ] Relationships Broken

[<no...@so...>]

Bugs item #520650, was opened at 2002-02-20 13:19
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=520650&group_id=22866

Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Jason Robertson (jrslim)
Assigned to: Dain Sundstrom (dsundstrom)
Summary: Relationships Broken

Initial Comment:
I'm running code pulled form CVS on 02/20/02 and 
relationships are not being handled correctly in that 
the field associated with the relation is being 
thought of as a cmp field and is being used in the sql 
generation when loading the bean. Thus, the sql is bad 
and causes the DB to throw an error.

I tried running the cmp-example that comes with the 
documentation and it fails in the same way as my code, 
specifically including an "order" field in the 
LineItemEJB load, and the order field is a cmr field.

I did not try running the JBoss testsuite, so I don't 
know if anything there fails.

Sorry I don't have detailed logs as I didn't copy them 
originally, but it seems easy to reproduce.

----------------------------------------------------------------------

>Comment By: Jason Robertson (jrslim)
Date: 2002-02-20 15:34

Message:
Logged In: YES 
user_id=464997

When I run the cmp-examples code, I get at least the 
following error (many pages of stack trace fly by and out 
of my screen buffer):

18:24:11,234 ERROR [LogInterceptor] 
TransactionRolledbackException, causedBy:
java.sql.SQLException: Unexpected token: ORDER in statement 
[SELECT id,quantity,
 shipped, order FROM LineItemEJB WHERE (id=10000) OR 
(id=10001) OR (id=10002) OR
 (id=10003) OR (id=10004) OR (id=10005) OR (id=10006) OR 
(id=10007) OR (id=10008
) OR (id=10009) OR (id=10010) OR (id=10011) OR (id=10012) 
OR (id=10013) OR (id=1
0014) OR (id=10015) OR (id=10016) OR (id=10017) OR 
(id=10018) OR (id=10019)]

The "Unexpected token: ORDER" error is the problem I'm also 
seeing in my code. It's an error because 'order' is not a 
field in the database, it is a container-managed-
relationship field.

It's entirely possibly that I have something configured 
wrong, as does possibly the cmp-examples stuff (I had to 
fix at least one EJB-QL typo to get it to deploy). I won't 
post the code specifics since I'm pretty sure you have the 
cmp-examples code! :) If your code works on your machine 
perhaps the code shipping with the documentation is a bit 
out of date.

I admit I haven't run the testsuite yet, I'll try it with 
my code as soon as I have a chance.

----------------------------------------------------------------------

Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-02-20 15:08

Message:
Logged In: YES 
user_id=251431

Relationships work fine.  We have a relationship testsuite.
 You need to be more detailed.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=520650&group_id=22866