String defaultServer = new AppDatabaseConnectionObject().getDefaultServer();в классе "DataviewerServlet" веб-страница "зависает" после 8-го обновления страницы в браузере.
Причина мне пока не понятна.
AppDatabaseConnectionObject.java:
import javax.naming.Context;DataviewerServlet.java:
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;
public class AppDatabaseConnectionObject {
private Connection connection;
private String defaultServer;
public AppDatabaseConnectionObject(
) throws ClassNotFoundException, NamingException, SQLException {
Context context = new InitialContext();
DataSource datasource = (DataSource) context.lookup("java:/comp/env/jdbc/myapp");
connection = datasource.getConnection();
defaultServer = (String) context.lookup("java:/comp/env/myapp/defaultServer");
}
public Connection getConnection() {
return connection;
}
public String getDefaultServer() {
return defaultServer;
}
}
import ch.qos.logback.classic.Logger;
import com.myapp.AppDatabaseConnectionObject;
import org.slf4j.LoggerFactory;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class DataviewerServlet extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
Connection con = new AppDatabaseConnectionObject().getConnection();
String defaultServer = new AppDatabaseConnectionObject().getDefaultServer();
...
Исправил, заменив в классе "DataviewerServlet" эти строки:
Connection con = new AppDatabaseConnectionObject().getConnection();на эти:
String defaultServer = new AppDatabaseConnectionObject().getDefaultServer();
AppDatabaseConnectionObject appdbcon = new AppDatabaseConnectionObject();
Connection con = appdbcon.getConnection();
String defaultServer = appdbcon.getDefaultServer();
