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