openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ashish22 <>
Subject OpenJPA DB2 and the QUERYNO Clause
Date Wed, 29 Dec 2010 20:15:03 GMT


We have a requirments from our  DBAs to add the QUERYNO clause in our
queries. We are using OpenJPA 1.2.1 and the underlying database  is DB2.

The current queries that go from the application server to the database via
the JPA are like

Select X from Y where A = B;

The DBAs want it to be

Select X from Y where A = B  QUERYNO 2223456;

We played around with the setHint but we are not able to add the QUERYNO
clause as required.

Any help would be appriciated


View this message in context:
Sent from the OpenJPA Developers mailing list archive at

View raw message