与DB在同一台PC上进行开发时，数据库连接始终断开 [英] Database Connection Always disconnect when Developing on same PC as DB

问题描述

我正在开发JSP应用程序，并且我使用Oracle Express 10g作为数据库.我注意到，当我尝试在同一台PC上进行开发时，我将只能进行多个页面请求和转换，并且我会立即获得IO异常.但是我将相同的代码下载到另一台PC上，并连接到所述数据库PC.它不会立即把我赶出去.想知道是否需要在这里进行其他设置吗?

I am developing a JSP application and I used Oracle Express 10g as database. I notice when I try to develop in the same PC, I would only be able to make several page request and transition and I immediately get IO exceptions. But I download the same code in a different PC and connect to the said database PC. It does not kick me out immediately. Any Idea if there is any other settings that needs to be set here?

我使用Apache Tomcat 5.5和Eclipse作为IDE.

Im using Apache Tomcat 5.5 and Eclipse as IDE.

[ 2009/10/05 17:59:02   The error occurred by XXXClass. ]
java.sql.SQLException: I/O Exception。: Connection reset by peer: socket write error
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:133)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:115)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:221)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:293)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:646)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1057)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:1139)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1471)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3874)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3944)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:3613)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)

推荐答案

您带有数据库的PC绝没有配置为通过DHCP获得IP地址，是吗?如果是这样，则需要安装 Microsoft回送适配器

Your PC with the database isn't by any chance configured to get it's IP via DHCP, is it? If so you need to install the Microsoft Loopback Adapter.

这篇关于与DB在同一台PC上进行开发时，数据库连接始终断开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！