文章/答案/技术大牛

发布

社区首页 >问答首页 >无法连接连接，在连接关闭后不允许操作。Tomcat 7中的错误

问无法连接连接，在连接关闭后不允许操作。Tomcat 7中的错误
EN

Stack Overflow用户

提问于 2013-12-05 05:04:56

回答 2查看 5.4K关注 0票数 0

在这里，我有一个关于关联问题的问题。

我在Tomcat 7中部署了一个web服务，在web服务中，我使用过滤器，在init()中调用连接。

public static Connection connection = null;

    @Override
        public void init(FilterConfig config) throws ServletException {
        connection = ConnectionFactoryJndi.getConnection(); 
        }

现在，我在整个应用程序中使用相同的连接对象。因此，以这种方式，我只创建一个连接并执行sql查询。一切都很好。但是当我访问服务url时，它会产生“无法连接；连接关闭后没有操作”的错误，“我也设置了maxWait=”28800000，即8小时；最长持续时间。我的问题是如何让它始终开放。或者当我访问url时，它不应该提供相同的错误，并且能够自动连接。我正在使用MySql。

这是server.xml餐厅-

  <Resource
        name="jdbc/xxxxx"
        auth="Container"
        type="javax.sql.DataSource"
        maxActive="200"
        maxIdle="30"
        maxWait="28800000"
        username="xxx"
        password="xxxxx"
        driverClassName="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost/xxxxx" />

在ConnectionFactoryJndi课上-

公共连接createConnection() {

Connection connection = null;
try {
try {
envContext = new InitialContext();
} catch (NamingException e) {
}
Context initContext = null;
try {
initContext = (Context) envContext.lookup("java:/comp/env");
} catch (NamingException e) {
}
DataSource datasource = null;
try {
datasource = (DataSource) initContext.lookup("jdbc/xxxxxx");
} catch (NamingException e) {
System.out.println("Name not found");
}
connection = datasource.getConnection();
} catch (SQLException e) {
System.out.println("ERROR: Unable to Connect to Database.");
}
return connection;
}

请提出最佳做法。

谢谢。

服务器日志-

Dec 05, 2013 10:09:44 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [ServletAdaptor] in context with path [/IntellixWebApi] threw exception
java.lang.NullPointerException
    at com.astroved.intellix.jdbc.dao.ClientDAO.getClientDetails(ClientDAO.java:44)
    at com.astroved.intellix.security.ValidateClient.isValidClient(ValidateClient.java:14)
    at com.astroved.intellix.security.SecurityFilter.doFilter(SecurityFilter.java:110)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)

但是，它是由于连接失败而出现的，因此无法执行查询。

ClientDao类-

    ResultSet rs = null;
    try {
        try {
            statement = connection.createStatement();
        } catch (SQLException e) {
            log.error("Error in Client DAO class (unable to connect connection) "
                    + e.getMessage());
            // e.printStackTrace();
        }
        try {
            rs = statement.executeQuery(query);
        } catch (SQLException e) {
            log.error("Error in Client DAO class (unable to Execute Query ) "
                    + e.getMessage());
            // e.printStackTrace();
        }

        try {
            while (rs.next()) {
                client = new ClientTO();
                client.setClientId(rs.getInt("clientid"));
                client.setClientUrl(rs.getString("clienturl"));
                client.setClientSecurityKey(rs
                        .getString("clientserviceapiKey"));

                clientList.add(client);
            }
        } catch (SQLException e) {
            log.error("Error in Client DAO class ( Error in iteration ) "
                    + e.getMessage());
            // e.printStackTrace();
        }
    } finally {
        DbUtil.close(rs);
        DbUtil.close(statement);
        //DbUtil.close(connection);
    }

专用连接连接= SecurityFilter.connection;

Server.xml -

 <Resource
        name="jdbc/xxxxx"
        auth="Container"
        type="javax.sql.DataSource"
        maxActive="200"
        maxIdle="30"
        maxWait="28800000"
        username="xxxxxx"
        password="xxxxxx"
        driverClassName="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost/xxxxxx" />


  </GlobalNamingResources>

客户DAO类-

ResultSet rs = null;
try {
    try {
        connection = ConnectionFactoryJndi.getConnection();
        statement = connection.createStatement();
        rs = statement.executeQuery(query);
    } catch (SQLException e) {
        log.error("Error in Client DnaReportDao class (unable to Execute Query ) "+ e.getMessage());

    }

    try {
            if(rs != null) {
                while (rs.next()) {
                    codeValue = new DnaReportTO();
                    codeValue.setNature(rs.getString("Nature"));
                    codeValue.setInterestedSubject(rs.getString("InterestdSubject"));
                    codeValue.setTipToParent(rs.getString("TipsToParent"));
                }
            }

    } catch (SQLException e) {
        log.error("Error in DnaReportDao class ( Error in iteration ) "
                + e.getMessage());
    }
} finally {
    DbUtil.close(rs);
    DbUtil.close(statement);
}

Currenr服务器日志

Dec 05, 2013 12:22:22 PM com.sun.jersey.spi.container.ContainerResponse logException
SEVERE: Mapped exception to response: 500 (Internal Server Error)
javax.ws.rs.WebApplicationException: com.sun.jersey.api.MessageException: A message body writer for Java class com.astroved.intellix.resource.DnaReportResource, and Java type class com.astroved.intellix.resource.DnaReportResource, and MIME media type application/xml was not found
    at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:285)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1448)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1360)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1350)
    at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.astroved.intellix.security.SecurityFilter.doFilter(SecurityFilter.java:112)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
Caused by: com.sun.jersey.api.MessageException: A message body writer for Java class com.astroved.intellix.resource.DnaReportResource, and Java type class com.astroved.intellix.resource.DnaReportResource, and MIME media type application/xml was not found
    ... 27 more

ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.
ERROR: Unable to Connect to Database.

servlets

jdbc

tomcat7

jndi

java

回答 2

Stack Overflow用户

回答已采纳

发布于 2013-12-05 05:13:13

从您在这里给出的错误来看，连接似乎是由应用程序关闭的。错误no operation after connection closed实际上可能意味着应用程序中的某些东西正在关闭它。没有日志，就很难诊断是什么导致了问题。

使用连接池的正确方法是每次需要时借用一个连接。不要在您自己的类中将对连接的引用存储为单例或静态字段。这是因为池可能会在某个时间后回收连接，您将得到一个有效的连接对象，该对象被关闭。这也可能是你的问题的原因。正确的做法如下：

ResultSet rs = null;
try {
    try {
        connection = ConnectionFactoryJndi.getConnection(); //always do this everytime you need a conenction.
        statement = connection.createStatement();
    } catch (SQLException e) {
        log.error("Error in Client DAO class (unable to connect connection) "
                + e.getMessage());
        // e.printStackTrace();
    }
    try {
        if(statement != null){
            rs = statement.executeQuery(query);
        }else{
            //log error and return or throw exception
        }
    } catch (SQLException e) {
        log.error("Error in Client DAO class (unable to Execute Query ) "
                + e.getMessage());
        // e.printStackTrace();
    }

    try {
        if(rs != null){
            while (rs.next()) {
                client = new ClientTO();
                client.setClientId(rs.getInt("clientid"));
                client.setClientUrl(rs.getString("clienturl"));
                client.setClientSecurityKey(rs
                        .getString("clientserviceapiKey"));

                clientList.add(client);
            }
        }else{
            //log error and return or throw exception
        }
    } catch (SQLException e) {
        log.error("Error in Client DAO class ( Error in iteration ) "
                + e.getMessage());
        // e.printStackTrace();
    }
} finally {
    //close rs
    //close statement
    //never close a conenction
}

票数 0

Stack Overflow用户

发布于 2013-12-12 23:25:29

我在整个应用程序中使用相同的连接对象。

这不管用。您应该使用连接池。否则，您必须自己做两件事，这样连接池就会自动避免：

确保每次使用连接时都具有活性，并且
确保连接的单线程使用，这完全破坏了服务器的性能。

不要这样做。使用Tomcat连接池。很简单。

票数 1

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/20391869

复制

相似问题

问无法连接连接，在连接关闭后不允许操作。Tomcat 7中的错误
EN

回答 2

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法连接连接，在连接关闭后不允许操作。Tomcat 7中的错误EN

回答 2

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法连接连接，在连接关闭后不允许操作。Tomcat 7中的错误
EN