Bugs item #570078, was opened at 2002-06-17 08:13
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=570078&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Closed
Resolution: Invalid
Priority: 5
Submitted By: k (shannu)
Assigned to: Dain Sundstrom (dsundstrom)
Summary: 1:1 CMR Problem
Initial Comment:
Hi,
Can any one help me out from this CMR problem
I can deploy both the entity beans with 1 to 1 relation.
But once you do findByPrimaryKey of 1st bean it gives
the following exception
java.sql.SQLException: ORA-00904: invalid column
name
at oracle.jdbc.dbaccess.DBError.throwSqlException
(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError
(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive
(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7
(TTC7Protocol.java:1405)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe
(TTC7Protocol.java:643)
it looks,it is picking CMR field in select statement
imy forien key mapping is
<foreign-key-mapping>
<ejb-relationship-role>
<ejb-relationship-role-
name>one-PatientAllergy-has-one-Codevalues</ejb-
relationship-role-name>
<foreign-key-fields>
<foreign-key-field>
<field-
name>allergyType<field-name>
<column-name>ALLERGYTYPE</column-name>
</foreign-
key-field>
</foreign-key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-
name>Codevalues-has-one-PatientAllergy</ejb-
relationship-role-name>
<foreign-key-fields />
</ejb-relationship-role>
</foreign-key-mapping>
is it wrong with ejb-jar.xml?
Please any one help me
Thanks
VK
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2002-07-22 01:22
Message:
Logged In: NO
I think what he is saying (I am sorry, I do not have any xml
handy) but what happens is that when Ia field is defined as a
cmr field (which gets its value by using a foreign key to match
the primary key of the other table) the column name for the
cmr field (which is not a real column in the table) is being
added to the select statement and thus the syntax error.
----------------------------------------------------------------------
Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-07-20 14:21
Message:
Logged In: YES
user_id=251431
You have not provided enough information. What is the bad
column? Try copying the query in to the oracle command line
query tool. My guess is you mapping is wrong. The mapping
is described in the JBoss Quick Start Guide and the JBossCMP
documentatation.
If' I'm wrong, reopen the bug.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=570078&group_id=22866
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
