Question

I m using a web application and, sometimes, I have MySql connection problems. Using the testConnectionOnCheckout and preferredTestQuery options in the Hibernate configuration file, I resolved the problem and my application is ok now.

但是,为了提高业绩,我只想在我提出申请时获得这一选择的效果。例如:

try {
    ...........
}
catch(Exception e) {
    // java code to obtain the same effect as
    // testConnectionOnCheckout option with "Select 1" query
}

我必须使用哪些 Java法?

Answer 1

回答这一问题的最佳办法是在来文方中研究这一问题。因此,我鼓励你们获得解放的源泉,并找到能够检测这一联系的法典。

但无论如何,这里只是简单一些。

public static boolean checkConnection(String jdbcUrl, String user, String password){
    boolean result = false;
    try {
                Configuration config = new AnnotationConfiguration().configure();
                config.setProperty("hibernate.connection.url", jdbcUrl);
                config.setProperty("hibernate.connection.username", user);
                config.setProperty("hibernate.connection.password", password);
                sessionFactory = config.buildSessionFactory();
                Session session = sessionFactory.openSession();
                Assert.assertFalse(sesssion.connection.isReadOnly());
                result = true;
    } catch(Throwable ex) {
                return = false;
    }
    return result;
}

友情链接