Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-23815

[QA](7.4.z) Some issues with db validation connection

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Major Major
    • None
    • 7.4.6.CR1
    • JCA
    • None
    • False
    • None
    • False

      When testing validation with oracle (using oracle19cRAC and ojdbc8) using the following code:

      for ... iterationNum {
        OracleValidConnectionChecker or = new OracleValidConnectionChecker();             
        SQLException ex = or.isValidConnection(con);
              
        if(ex==null) System.out.println("Valid connection ...");
        else System.out.println("InValid connection ..."+ex.toString());
        sleep(time) 
      }  
      • when the connection to the db is fine the db connection is validated normally ....
      • when the connection to the db is interrupted the invalidation message is printed normally ...
      • when the network connection is re-established still there are invalidation messages ...
      • when the server is restarted the db connection is validated normally again ...

       

      When testing validation with mssql (using mssql2019 and mssql-jdbc-9.2.0.jre8) using the following code ...

      for ... iterationNum {
        MSSQLValidConnectionChecker ms = new MSSQLValidConnectionChecker();
        SQLException ex = ms.isValidConnection(con);
      
        if(ex==null) System.out.println("Valid ms connection ...");
        else System.out.println("InValid ms connection ..." + ex.toString());
        sleep(time) 
      }  
      • when the connection to the db is fine the db connection is validated normally ....
      • when the connection to the db is interrupted the isValidConnection method seems to get stuck ...
      • most probably the previous network disconnection issue could be the same here ...

            istudens@redhat.com Ivo Studensky
            psotirop@redhat.com Panagiotis Sotiropoulos (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: