In my project  we are using CASTOR JDO for database connective and
using iplanet server.

Following query is working fine in local in environment using
websphere but when tiring in iplanet server(Dev).  I am getting
inconsistence in data retrieval.  Please give me some suggestion to
solve the issue.

SELECT distinct t FROM
com.ford.fleet.pm.domain.impl.DebitTransactionImpl t WHERE
t.DealerToCache = $1 AND t.transactionState = $2 ORDER BY
t.DealerInvoiceDateToCache ASC", new Object[]{dealer,
transactionState})

Thanks & Regards,
Ramesh