From: | "Tyler Hains" <thains(at)profitpointinc(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | JDBC Postgres problem |
Date: | 2010-07-08 21:24:58 |
Message-ID: | H000006900c79624.1278624296.mailpa.profitpointinc.com@MHS |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Carlo Stonebanks | 2010-07-08 21:56:45 | Wrote a proc for massive updates - will I have problems? |
Previous Message | Tom Lane | 2010-07-08 21:13:47 | Re: [GENERAL] 'default nextval()' loses schema-qualification in dump ? |