여기에 연결 문제에 문제가 있습니다.
Tomcat 7에 웹 서비스를 배포했습니다. 웹 서비스에서는 Filter를 사용하고 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 conf입니다-
<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.
여기에 제공된 오류로 인해 응용 프로그램이 연결을 닫은 것 같습니다. 오류 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
}
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다