Re: [eclipselink-users] New QueryException in version 1.1

[khaskett <khaskett@xxxxxxxxxxx>]

I removed the @JoinColumn as suggested but I still get the same error -
[3/31/09 20:28:00:437 CDT] 00000035 SystemOut     O [EL Warning]: 2009-03-31
20:28:00.421--UnitOfWork(2109111734)--Thread(Thread[WebContainer :
0,5,main])--Exception [EclipseLink-6094] (Eclipse Persistence Services -
1.1.0.r3634): org.eclipse.persistence.exceptions.QueryException
Exception Description: The parameter name [POLICY_NUMBER] in the query's
selection criteria does not match any parameter name defined in the query.
Query: DeleteObjectQuery(com.gmrc.jpa.domain.CpTransaction@de21fdeb)

Anything else I might try?
Thanks


James Sutherland wrote:
> 
> I'm not exactly sure, but my guess is it has something to do with the,
> 
> @JoinColumn(name = "POLICY_NUMBER", referencedColumnName = "POLICY_NBR") 
> 
> Annotation in your @OneToMany mapping.  In JPA 1.0 using a @JoinColumn in
> a @OneToMany was not supported.  However in JPA 2.0 it will be, and is in
> EclipseLink 1.1.  Because you are using a mappedBy in your mapping though,
> you should not have the @JoinColumn, so you should remove it.
> 
> 
> khaskett wrote:
>> 
>> Is there a way to figure out why I am getting a QueryException in a
>> delete request?
>> [3/30/09 14:47:35:328 CDT] 0000003f SystemOut     O [EL Warning]:
>> 2009-03-30
>> 14:47:35.328--UnitOfWork(2104393070)--Thread(Thread[WebContainer :
>> 5,5,main])--Exception [EclipseLink-6094] (Eclipse Persistence Services -
>> 1.1.0.r3634): org.eclipse.persistence.exceptions.QueryException
>> Exception Description: The parameter name [POLICY_NUMBER] in the query's
>> selection criteria does not match any parameter name defined in the
>> query.
>> Query: DeleteObjectQuery(com.gmrc.jpa.domain.CpTransaction@de21fdeb)
>> 
>> I was not seeing this in the 1.0.2 version.
>> 
>> I have narrowed it down to the relationship between these two entities.
>> 
>> @Entity
>> @Table(name = "CP_TRANSACTION")
>> public class CpTransaction extends BaseDomain implements
>> java.io.Serializable {
>> ....
>>     private Set<CpMsg> cpMsgs = new HashSet<CpMsg>(0);
>> ....
>>     @OneToMany(fetch = FetchType.LAZY, mappedBy = "cpTransaction")
>>     @JoinColumn(name = "POLICY_NUMBER", referencedColumnName =
>> "POLICY_NBR")
>>     @PrivateOwned
>>     public Set<CpMsg> getCpMsgs() {
>>         return this.cpMsgs;
>>     }
>> 
>>     @Column(name = "POLICY_NUMBER", length = 20)
>>     public String getPolicyNumber() {
>>         return this.policyNumber;
>>     }
>> }
>> 
>> @Entity
>> @Table(name = "CP_MSG")
>> public class CpMsg extends BaseDomain {
>>     private Long msgId;
>> .....
>>     private String policyNbr;
>>     private CpTransaction cpTransaction;
>> 
>>     @ManyToOne(fetch = FetchType.LAZY)
>>     @JoinColumn(name = "POLICY_NBR", referencedColumnName =
>> "POLICY_NUMBER", updatable = false, insertable = false)
>>     public CpTransaction getCpTransaction() {
>>         return this.cpTransaction;
>>     }
>> 
>>     @Id
>>     @GeneratedValue(strategy = GenerationType.IDENTITY)
>>     @Column(name = "MSG_ID", unique = true, nullable = false, precision =
>> 11, scale = 0)
>>     public Long getMsgId() {
>>         return this.msgId;
>>     }
>>     
>>     @Column(name = "POLICY_NBR", length = 20)
>>     public String getPolicyNbr() {
>>         return this.policyNbr;
>>     }
>> }
>> 
>> The SQL relationship is CP_TRANSACTION.POLICY_NUMBER = CP_MSG.POLICY_NBR.
>> 
>> If I do a getCpMsgs() it seems to find them correctly.
>> 
>> Thanks
>> Kevin
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/New-QueryException-in-version-1.1-tp22792539p22818202.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.