java - 部署 Spring 应用程序时出现连接超时错误

Question

我正在尝试部署一个简单的 Spring 应用程序并收到“连接超时”错误。我的应用程序尝试在一个 jsp 中获取用户的文本输入，将该值插入到数据库中的用户名下，然后在另一个 jsp 中显示该名称以及问候语，例如:“hello，”

我的环境:

1. 操作系统:Windows XP 专业版
2. 服务器:Tomcat 6
3. IDE:Eclipse
4. 数据库:MS Access 2007

我收到以下错误:

SEVERE: Context initialization failed

org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from ServletContext resource [/WEB-INF/applicationContext.xml]; nested exception is java.net.ConnectException: Connection timed out: connect

java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.Socket.connect(Socket.java:520) at java.net.Socket.connect(Socket.java:470) at sun.net.NetworkClient.doConnect(NetworkClient.java:157) at sun.net.www.http.HttpClient.openServer(HttpClient.java:388) at sun.net.www.http.HttpClient.openServer(HttpClient.java:523) at sun.net.www.http.HttpClient.(HttpClient.java:231) at sun.net.www.http.HttpClient.New(HttpClient.java:304) at sun.net.www.http.HttpClient.New(HttpClient.java:321)

SEVERE: Servlet /SpringExample threw load() exception

java.net.ConnectException: Connection timed out: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.Socket.connect(Socket.java:520) at java.net.Socket.connect(Socket.java:470) at sun.net.NetworkClient.doConnect(NetworkClient.java:157)

Access 数据库的代码如下:

//在profile.java类中

public void setUsername(String username) {
              int rowsInserted;
              setDataSource(dataSource);
             jt = new JdbcTemplate(dataSource);
             rowsInserted = jt.update("insert into usernamedb (username) values(?)",new Object[] { username });
             System.out.println(rowsInserted);
             }

在 profileFormController.java 类中

protected ModelAndView onSubmit(Object command)
    {
        Profile profile = (Profile) command; 
        String greeting = "Hello," + profile.getUsername() + "!";
        //System.out.println(greeting);
        profile.setUsername(profile.getUsername());
        return new ModelAndView("greetingDisplay", "greeting", greeting);
    }

为了设置 DNS，我在 ODBC 源中将“usernamedb”设置为用户的 DNS 源。我无法找出此错误的根本原因。

Answer 1

首先，我会检查您的数据库服务器是否正在运行。如果是，请确保您尝试通过正确的地址、正确的端口号连接到它，并且您是否为其提供了正确的用户名和密码。

如果所有这些似乎都有效，您可能还需要检查您的数据库服务器是否接受来自您的地址的连接。