From: | Stefan Wild <wilds81(at)yahoo(dot)de> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Empty SELECT result at simultaneous calls |
Date: | 2010-09-07 21:11:18 |
Message-ID: | 425349.79318.qm@web26705.mail.ukl.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello guys,
I have a problem with my web application and postgres. I have several servlets on a page which results in severeal simultaneous data base calls kind of:
SELECT d.id, d.aa, d.ab, ts.ac, d.ad, d.af, d.ag, d.ah, d.ai, d.aj, d.ak, d.al, d.am, d.an, d.ao, d.ap, d.ar, d.as, d.at, d.au, d.av, d.ax, d.ay, d.az, d.ba, d.bb, d.bc FROM c_depots d INNER JOIN c_aa ts ON d.bd_id=ts.id INNER JOIN cx_users_depots cx ON cx.id_depots=d.id INNER JOIN c_users u ON cx.id_users=u.id WHERE d.id=13
Even though I have "d.id 13" the SELECT result is empty. When I'm working with delays in the servlets, everything works fine. The calling instance itself is realized as single instance:
public static DbManager getInstance() {
if(instance == null) {
instance = new DbManager();
}
return instance;
}
So I'm wondering why there are such problems and how can I resolve them?
My posgres version is (still) 8.2.
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2010-09-07 21:44:00 | Re: Find \ in text |
Previous Message | Christine Penner | 2010-09-07 21:04:08 | Find \ in text |