Hi Andrei,
I would expect I have to call setParameter only once for the query
Marina mentioned below:
Query q = em.createNativeQuery("select * from ... where columnA=?1 or
columnB=?1");
q.setParameter(1, value);
List result = query.getResultList();
When using JDBC parameter syntax (just a question mark) I have to call
setParameter twice:
Query q = em.createNativeQuery("select * from ... where columnA=? or
columnB=?");
q.setParameter(1, value);
q.setParameter(2, value);
List result = query.getResultList();
Am I right?
Regards Michael
> yes it does
> ----- Original Message ----- From: "Marina Vatkina"
> <Marina.Vatkina_at_Sun.COM>
> To: "persistence" <persistence_at_glassfish.dev.java.net>
> Sent: Wednesday, August 23, 2006 12:32 PM
> Subject: [Fwd: [Issue 990] New - ? AND # SYMBOLS CAN'T BE USED IN
> NATIVE QUERY]
>
>
>> Andrei,
>>
>> Does TopLink support repeated parameters in native queries, e.g.
>> "select * from ... where columnA=?1 or columnB=?1"
>>
>> thanks,
>> -marina
>>
>> -------- Original Message --------
>> From: ailitche_at_dev.java.net
>> Subject: [Issue 990] New - ? AND # SYMBOLS CAN'T BE USED IN NATIVE QUERY
>> To: issues_at_glassfish.dev.java.net
>>
>> https://glassfish.dev.java.net/issues/show_bug.cgi?id=990
>> Issue #|990
>> Summary|? AND # SYMBOLS CAN'T BE USED IN NATIVE QUERY
>> Component|glassfish
>> Version|9.1pe
>> Platform|All
>> OS/Version|All
>> URL|
>> Status|NEW
>> Status whiteboard|
>> Keywords|
>> Resolution|
>> Issue type|DEFECT
>> Priority|P3
>> Subcomponent|entity-persistence
>> Assigned to|ailitche
>> Reported by|ailitche
>>
>>
>>
>>
>>
>>
>> ------- Additional comments from ailitche_at_dev.java.net Wed Aug 23
>> 14:33:10 +0000 2006 -------
>> Also logged as TopLink bug 5472919.
>> ? denotes positional parameter in native queries:
>> "select * from CMP3_ADDRESS where city=?"
>> or
>> "select * from CMP3_ADDRESS where city=?1"
>>
>> However if ? are found in a literal - where it shouldn't be
>> interpreted as a
>> parameter - the query fails:
>> "select * from CMP3_ADDRESS where city='?'"
>> The same with #:
>> "select * from CMP3_ADDRESS where city='#'"
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: issues-unsubscribe_at_glassfish.dev.java.net
>> For additional commands, e-mail: issues-help_at_glassfish.dev.java.net
>>
>>