opensubscriber
   Find in this group all groups
 
Unknown more information…

o : ojb-user@db.apache.org 26 November 2008 • 3:42AM -0500

How can I make OJB to create a "select" on a select statement, not on a table?
by Hiller, Frank RD-PT31

REPLY TO AUTHOR
 
REPLY TO GROUP



Hi,

I'm using "ReportQueryByCriteria" of the PB API in OJB 1.0.3.

What I'm trying to do is to create a statement like this:
SELECT columnA, columnB, columnC FROM ( select ... from tableName where ...)

OJB always creates a statement like this:
SELECT A0.columnA, A0.columnB, A0.columnC FROM tableName A0 WHERE ...

How can I make OJB to create a "select" on a select statement, not on a table?

Thanks
Frank



  ________________________________
Confidentiality note:
The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.

Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

opensubscriber is not affiliated with the authors of this message nor responsible for its content.