[jboss-user] [IronJacamar] - Re: Feature request:Add an interface to allow end-user to have a second chance to create a normal database connection after failling to get connection because of database password error

private LocalManagedConnection getLocalManagedConnection(Properties props,Properties copy)                        throws JBossResourceException    {              boolean debug = log.isDebugEnabled();        Connection con = null;              try              {                        String url = getConnectionURL();                        Driver d = getDriver(url);                        // alreay got the new password                        if(this.newPasswordFromDbpm != null){                                  copy.setProperty("password", newPasswordFromDbpm);                        }                        try{                                  con = d.connect(url, copy);                        }catch(SQLException e){                                  if(debug){                                            log.debug("ErrorCode:"+e.getErrorCode() + " " + "SQLState:"+e.getSQLState());                                  }                                  // for mysql and db2                                  if("28000".equals(e.getSQLState())){                                            if(debug){                                                      log.debug("we catch a SQLException(SQLState=28000), so try to get new password from DBPM server, and then reconnect the database");                                            }                                           String dbName = url.split(":")[3].split("/")[1]; // get database name from url                                           String dbUserNm = copy.getProperty("user");                                           //try to get password!                                           String dbpmPassword = DsPasswdGetter.doGetPasswd(dbName, dbUserNm, false);                                           if(dbpmPassword != null){                                                     if(debug){                                                               log.debug("get dbpmPassword ok.. begin to reconnect the database");                                                     }                                                     copy.setProperty("password", dbpmPassword);                                                     this.newPasswordFromDbpm = dbpmPassword;                                                     //write it to xml configuration file                                                     if(securityDomain != null){                                                               Properties prop = new Properties();                                                               prop.setProperty(securityDomain, dbpmPassword);                                                               if(debug){                                                                         log.debug("begin to write dbpmPassword to login-config.xml");                                                               }                                                               UpdateJdbcPassword.doModifyPasswd(prop);                                                     }else{                                                               throw new JBossResourceException("securityDomain is null");                                                     }                                                     //begin to reconnect                                                     con = d.connect(url, copy);                                           }else{                                                     //error to get password from DBPM server                                                     throw new JBossResourceException("Can not get password from dbmp server for [dbName:"+dbName+", dbUserNm:"+dbUserNm+"]");                                           }                                 }                                 if(con==null)                                   throw new JBossResourceException("Wrong driver class for this connection URL");                        }                        return new LocalManagedConnection(this, con, props, transactionIsolation, preparedStatementCacheSize);              }              catch (Throwable e)              {                  if (con != null)                  {                     try                     {                        con.close();                     }                     catch (Throwable ignored)                     {                     }                  }                        throw new JBossResourceException("Could not create connection", e);              }    }