Yes, you guessed it right - the access of the collection results in some
mismatch. Can you post your latest Team and User classes?
thanks,
-marina
Romanowski, Tim wrote:
> Ok, section 9.1.26, "FetchType fetch() default LAZY;". I didn't find that
> particularly clear, but I do see that Basic is only applicable to a handful
> of types. Chapter 9 of the spec is not something I had looked at before.
>
> @ManyToMany(fetch=FetchType.EAGER)
> @JoinTable(name = "team_users",
> joinColumns = {_at_JoinColumn(name = "teamid", referencedColumnName =
> "teamid")},
> inverseJoinColumns = {_at_JoinColumn(name = "username",
> referencedColumnName = "username")})
> private java.util.Collection <com.my.persistence.entity.Users>
> userCollection;
>
> However, now I'm back to square one. I'm getting this name mismatch error.
> I thought, "must be a mismatch with the database join table." But I look,
> and my table is as expected:
>
> Table: team_users
> Columns: teamid, username
>
>
> ANY access to the Team entity is causing the exception below. But I do have
> some new info: a single call to an instance of Users' "getTeamCollection()"
> generates the following exception:
>
> Exception Description: The parameter name [username] in the query's
> selection criteria does not match any parameter name defined in the query.
> Query: ReadAllQuery(com.my.persistence.entity.Team)
> at
> oracle.toplink.essentials.exceptions.QueryException.parameterNameMismatch(Qu
> eryException.java:966)
> at
> oracle.toplink.essentials.internal.expressions.ParameterExpression.getValue(
> ParameterExpression.java:215)
> at
> oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.translate(Dat
>
>
>
>
> However, if I instead access the Team entities "getUserCollection()," I get
> a similar exception, but it says "Query:
> ReadAllQuery(com.my.persistence.entity.Users)", and "The parameter name
> [teamid] in the query's ..."
>
>
>
>
> -----Original Message-----
> From: Marina.Vatkina_at_Sun.COM [mailto:Marina.Vatkina_at_Sun.COM]
> Sent: Wednesday, March 28, 2007 6:28 PM
> To: persistence_at_glassfish.dev.java.net
> Subject: Re: Problem using ManyToMany relationship
>
> Did you look at attributes of the @ManyToMany annotation?
>
> thanks,
> -marina
>
> Romanowski, Tim wrote:
>
>>What else would I use? Isn't that how you define the fetch type?
>>
>>-----Original Message-----
>>From: Marina.Vatkina_at_Sun.COM [mailto:Marina.Vatkina_at_Sun.COM]
>>Sent: Wednesday, March 28, 2007 6:23 PM
>>To: persistence_at_glassfish.dev.java.net
>>Subject: Re: Problem using ManyToMany relationship
>>
>>Tim,
>>
>>Why did you use @Basic to do it?
>>
>>thanks,
>>-marina
>>