Hello Sunit,
> Anyone have any experience with this before ? I'm working with an Oracle
> database. When using Castor to execute a query I get a certain set of rows.
> Executing the exact same query with sqlplus yields more rows. The castor
> query always skips a certain set of rows. I've tried it many different ways
> changing the order by and the group by and running it in ReadOnly and Shared
> mode. Castor always skips the exact same set of rows every single time and
> sqlplus does not. The rows exist and do satisfy the condition in te where
> clause.
Could you please post the related part of your mapping file?
In particular, what PK definition do you use?
Could it be, the skipped lines are just that with identical PK values
compared to there predecessors? In that case you should define
another, unique PK column to get all your data as result set.
Regards,
Martin
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
