Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.java.programmer > #33955

Troubles with informix jdbc driver ...

From Andreas Leitgeb <avl@logic.at>
Newsgroups comp.lang.java.programmer
Subject Troubles with informix jdbc driver ...
Date 2016-03-14 13:54 +0000
Organization A noiseless patient Spider
Message-ID <slrnnedgqn.456.avl@login.logic.tuwien.ac.at> (permalink)

Show all headers | View raw


A previous version of Informix jdbc ("3.70.JC5DE") was very
strict with "thread safety", in that it governed any connection
to any db server with a global lock.  If one DB server was
temporarily unreachable, then it would block also connections
to any other db server (attempted from other threads).

Some newer version of their jdbc driver (4.10.JC5) seems to
have that fixed, but we now observe that Connections obtained
from calling DriverManager.getConnection(...) casually get
mixed up!  As a result, we observe threads retrieving data
from wrong servers - not always, but "moderately reproducible".

In my application the threads share little to no data, and there
are definitely no static fields involved in my code related to 
the keeping of jdbc-related objects.  I can't vouch for the
driver, though.

Has anyone else observed similar effects with Informix jdbc drivers
and a bunch of independent threads opening connections to different
db servers?

Back to comp.lang.java.programmer | Previous | Next — Next in thread | Find similar | Unroll thread


Thread

Troubles with informix jdbc driver ... Andreas Leitgeb <avl@logic.at> - 2016-03-14 13:54 +0000
  Re: Troubles with informix jdbc driver ... Marcel Mueller <news.5.maazl@spamgourmet.org> - 2016-03-14 21:23 +0100
    Re: Troubles with informix jdbc driver ... Andreas Leitgeb <avl@logic.at> - 2016-03-14 21:30 +0000
  Re: Troubles with informix jdbc driver ... Arne Vajhøj <arne@vajhoej.dk> - 2016-03-14 18:16 -0400
    Re: Troubles with informix jdbc driver ... Marcel Mueller <news.5.maazl@spamgourmet.org> - 2016-03-15 21:57 +0100
      Re: Troubles with informix jdbc driver ... Arne Vajhøj <arne@vajhoej.dk> - 2016-03-15 21:18 -0400
    Re: Troubles with informix jdbc driver ... Andreas Leitgeb <avl@logic.at> - 2016-03-15 22:25 +0000
      Re: Troubles with informix jdbc driver ... Arne Vajhøj <arne@vajhoej.dk> - 2016-03-15 21:25 -0400
  Re: Troubles with informix jdbc driver ... Kevin McMurtrie <mcmurtrie@pixelmemory.us> - 2016-03-14 21:26 -0700
    Re: Troubles with informix jdbc driver ... Andreas Leitgeb <avl@logic.at> - 2016-03-15 22:09 +0000
      Re: Troubles with informix jdbc driver ... Andreas Leitgeb <avl@logic.at> - 2016-03-16 21:37 +0000
        Re: Troubles with informix jdbc driver ... Kevin McMurtrie <mcmurtrie@pixelmemory.us> - 2016-03-16 22:36 -0700
          Re: Troubles with informix jdbc driver ... -- workaround found Andreas Leitgeb <avl@logic.at> - 2016-03-17 17:23 +0000
            Re: Troubles with informix jdbc driver ... -- workaround found Andreas Leitgeb <avl@logic.at> - 2016-03-18 11:13 +0000

csiph-web