[EMAIL PROTECTED] writes:
> If two users (we have not tried more) use different clients and click on the
>getInvoices button at the same time, the data becomes mixed.
> I.e.
> If i say pick client 'smith trucks' and my collegue picks a client 'post modern', i
>get some of 'post modern' invoices (data) and he get some (if not a large portion) of
>'smith trucks' data.
> As you can imagine, this is an extremely serious issue.
I am practically certain that this problem must be on the client side.
Your mention of pooled connections is suspicious --- couldn't it be that
something is getting confused about which connection it's reading from?
It's very hard to see how one backend could deliver data from another
backend's query (and moreover, no such problem has ever been reported
before).
I'm prepared to believe a JDBC driver bug, however. I'd suggest asking
on the pgsql-jdbc list to see if anyone has any ideas.
> We were using postgres 6.5, but switched to 7.12 using JDBC driver
> jdbc7.0-1.2.jar.
The JDBC driver released with 7.1 was pretty buggy :-(. I think most
people are using a more recent snapshot. Again, you can get better
advice on the jdbc list.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
