Hello,
Oracle and DB2 allow multiple columns to be used for IN predicate in where
clause. I can construct a query like this SELECT * FROM CUSTOMER C WHERE
(C.STATE, C.CITY) IN (SELECT L.STATE, L.CITY FROM LOCATIONS L WHERE
L.COUNTRY='USA') to retrieve a list of customers located in the same
Does anyone know any of those? I need to parse something similar to tab
delimited file and having OJB interface for it would be ideal.
Thank, you.
Max.
-Original Message-
From: Mahler Thomas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 3:22 AM
To: 'OJB Users List'
Subject:
I generate model classes using repository.xml as a template definition. In
addition to populating a collection of fields in a data object class I
generate a list of public static members that represent column names in DB.
It works really well providing a compile time check for a valid column name
Hi,
Is there a way to use your own implementation of RowReader interface?
Thank, you.
Max.
It's not implemented in OJB version 0.9.8. I had to extend
org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl class to build
alter select statement with TOP keyword.
Max Vesely -Dynax Solutions, Inc.
Main: 212 889 7722
Direct: 212 331 8627
Mobile: 732 803
0) {
stmt += OFFSET + startIndex;
}
return stmt;
}
}
Hope that helps,
Scott Howlett
-Original Message-
From: Max Vesely [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 10:27 PM
To: [EMAIL PROTECTED]
Subject: Limiting a number of rows
Hi,
Does anyone know how to limit a number of rows returned from database
using OJB?
Most of the database engines implement custom keywords to limit a number of
rows for select statement (top, limit, rownum () .), OJB Query
interface has methods in it to set EndAt and StartAt indexes