Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] NamedNativeQuery using in
I am using the IN Keyword as the list will vary.  So I am not sure how I could create a query that would dynamically have place holders for the number of values coming in.
 
I am using a tool called Squirrell to run the query outside of Eclipselink,  so it looks like  .... rs.role_code in ('GA', 'GRN', 'PA', 'SA')  when I run it there.
 
Not sure how to convert this using JPQL easily.
 

From: eclipselink-users-bounces@xxxxxxxxxxx [mailto:eclipselink-users-bounces@xxxxxxxxxxx] On Behalf Of Christopher Delahunt
Sent: Monday, August 30, 2010 11:07 AM
To: EclipseLink User Discussions
Subject: Re: [eclipselink-users] NamedNativeQuery using in

Hello Kevin,

Native SQL gets executed exactly as you have defined it, with each parameter passed in passed directly to the driver as a single parameter.  Drivers treat the parameter as a single serialized object, which will not match to your role_code field.
Try using a single parameter for each component in the list.  How are you running this outside of EclipseLink, and does it work if you use JPQL instead of a native query?

Best Regards,
Chris

On 30/08/2010 11:50 AM, Kevin Haskett wrote:
I have a NamedNativeQuery that is using the "in" SQL statement -

@NamedNativeQuery(name = "findCpSecuredFeatureListRole", query = "select distinct s.FEATURE_ID, FEATURE_NAME, FEATURE_DESC, FEATURE_TYPE, LICENSE_CHECK, PRIVILEGE_LEVEL "

+ "from cp_secured s, cp_role_secured rs where s.feature_id = rs.feature_id and rs.role_code in (?) ", resultClass = com.gmrc.jpa.domain.CpSecuredFeature.class)

in my code I call -

final Query query = this.em.createNamedQuery("findCpSecuredFeatureListRole");

query.setParameter(1, roles);

return query.getResultList();

 

where roles is a string representing - 'GA', 'PA', 'GRN'

If I execute this outside of Eclipselink it seems to run fine.  But when it runs in EclipseLink I get nothing returned in my results.  I tried changing this to a List<String> with each as a seperate entity in the List but that gave me a Data Type mismatch.

 

Thanks,

Kevin

This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you.




_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you.

Back to the top