JDBC tries multiple times to connect on a bad login

[Caroline Thorn]

Hi, we got this problem when there's a bad login (ora-01017) from a user.
Note that everything works fine for a successful login.

So when a bad login occur it takes at least 2-3 minutes to catch the exception.
During that time we can see in the JDBC tracing that there's multiple tries to connect, about 200.

We use classes12 and Oracle 10g (RAC).
LOAD_BALANCE=ON
FAILOVER=ON
SERVER = DEDICATED

I did try with DriverManager and OracleDatasource with no difference.

        Connection con = null;
        try{ 
          compteur = compteur+1;
          trace.ecrireLogEnv("compteur : "+compteur);
          //DriverManager.setLogWriter(new PrintWriter(new FileOutputStream(chemin.substring(0,chemin.indexOf("classes"))+"log//test_connexion.txt")));
          //con = DriverManager.getConnection(url,user,motPass);
          OracleDataSource ods = new OracleDataSource();
          ods.setURL(url);
          ods.setLogWriter(new PrintWriter(new FileOutputStream(chemin.substring(0,chemin.indexOf("classes"))+"log//test_connexion_ds.txt")));
          con = ods.getConnection(user,motPass);
          etat = true;
        } catch( SQLException e ){
          msg = e.getMessage();
          trace.ecrireLogEnv("mesg "+ msg);
        }
        finally {
          if( con != null ) {
            try { con.close(  ); }
            catch( Exception e ) { }
          }
        }
    

Anyone can help?
Caroline

[Ben Souther]

"Carot",
Please check your private messages regarding an important administrative matter.
-Ben