JDBC Postgres problem

We are having a very strange issue where for certain records, queries
sent via JDBC return no results when the identical query via command
line or pgadmin return non-null (expected) results. Example below. We
are running 8.3.9.

>> SELECT client_id FROM locations WHERE external_id = '278';

>>

>> Doing an EXPLAIN ANALYZE from psql gives:

>>

>> Seq Scan on locations (cost=0.00..17.01 rows=1 width=4) (actual

>> time=0.189..0.197 rows=1 loops=1)

>> Filter: ((external_id)::text = '278'::text) Total runtime: 0.245

>> ms

>>

>> And doing the same thing from JDBC stmt.executeQuery() gives:

>>

>> Seq Scan on locations (cost=0.00..17.93 rows=1 width=4) (actual

>> time=0.206..0.206 rows=0 loops=1)

>> Filter: ((external_id)::text = '278'::text) Total runtime: 0.221 ms

Note the 0 rows returned via JDBC. Has anyone ever heard of anything
like this before?

Thanks,

Tyler Hains

IT Director

ProfitPoint, Inc.

www.profitpointinc.com