title: informix jdbc stuck connecting
body: <p>I'm trying to connect to a Informix database server with jdbc using the standard way :</p>
  
  <pre><code>connection = DriverManager.getConnection("jdbc:informix-sqli://"+ip+
  /"+sid+":INFORMIXSERVER="+server+";user="+user+";password="+pass+"");
  </code></pre>
  
  <p>But it keeps trying to connect and does not throw a error message (I suppose it tries to connect because it does not show anything). I'm using IBM Informix driver 4.10.00.1534 and Java 1.7.
  I have been using this method to connect to Informix servers until now, in fact it only fails with one server. I can connect to this server through Informix clients with odbc but it keeps failing with jdbc with no error message.</p>
  
  <p>Is there any method to verbose the jdbc connection? Any suggestion about why it fails?</p>
  
  <p>UPDATE: The sqlidebug trace:</p>
  
  <pre><code>C-&gt;S (4)            
      SQ_VERSION
      SQ_EOT
  
  S-&gt;C (14)           
      SQ_VERSION
          "7.31.TD6" [8]
      SQ_EOT
  
  C-&gt;S (66)           
      SQ_INFO
          INFO_ENV
              Name Length = 12
              Value Length = 8
              "DBTIME"="%d/%M/%Y"
              "DBTEMP"="/tmp"
              "SUBQCACHESZ"="10"
          INFO_DONE
      SQ_EOT
  
  S-&gt;C (2)            
      SQ_EOT
  
  C-&gt;S (16)           
      SQ_DBOPEN
           "database" [8]
          NOT EXCLUSIVE
      SQ_EOT
  
  S-&gt;C (28)           
      SQ_DONE
          Warning..: 0x15
          # rows...: 0
          rowid....: 0
      serial id: 0
  SQ_COST
      estimated #rows: 1
      estimated I/O..: 1
  SQ_EOT
  
  C-&gt;S (78)           
      SQ_PREPARE
          # values: 0
          CMD.....: "select site from informix.systables where tabname = '   GL_COLLATE'" [65]
      SQ_NDESCRIBE
      SQ_WANTDONE
      SQ_EOT
  </code></pre>
  
  <p>And the jdbctrace.log says:</p>
  
  <pre><code> trying com.informix.jdbc.IfxDriver
      SQLWarning: reason(Database selected) SQLState(01I04)
      SQLWarning: reason(Float to decimal conversion has been used) SQLState(01I05)
      SQLWarning: reason(Database has transactions) SQLState(01I01)
      SQLWarning: reason(Database selected) SQLState(01I04)
      SQLWarning: reason(Database has transactions) SQLState(01I01)
      SQLWarning: reason(Database selected) SQLState(01I04)
  </code></pre>