기술지원 문의
connection pool error
곽상현 / 2003-02-10 00:00
한컴리눅스 2.2에서
resin을 테스트중입니다..
클래스패스는 모두 수정했습니다...
resin.conf 부분은 ....
로 수정했습니다...
아래 jsp소스를 돌리면
<%@page import=\"java.sql.*,java.lang.*,javax.sql.*, javax.naming.* \"%>
<%
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup(\"java:comp/env/jdbc/test\");
Connection conn = ds.getConnection(); <================커넥션이 사라져 버림...
%>
<%
try {
Statement stmt = conn.createStatement();
//ResultSet rs = stmt.executeQuery(\"select version* from starcraft\");
ResultSet rs = stmt.executeQuery(\"select version(),current_date\");
%>
Brooms:
<%
while (rs.next()) {
%>
<%//= rs.getString(1) %> <%//= rs.getString(2) %>
<%
}
}
finally
{
conn.close();
}
%>
웹화면에 출력되는 에러
500 Servlet Exception
java.sql.SQLException: Dropped connection
at com.caucho.jdbc.mysql.DatabaseConnection.readStatus(DatabaseConnection.java:574)
at com.caucho.jdbc.mysql.DatabaseConnection.login(DatabaseConnection.java:191)
at com.caucho.jdbc.mysql.DatabaseConnection.
at com.caucho.jdbc.mysql.Connection.create(Connection.java:126)
at com.caucho.jdbc.mysql.Driver.connect(Driver.java:113)
at com.caucho.sql.XADataSourceAdapter.getXAConnection(XADataSourceAdapter.java:119)
at com.caucho.sql.XADataSourceAdapter.getPooledConnection(XADataSourceAdapter.java:141)
at com.caucho.sql.DBPool.createConnection(DBPool.java:1391)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1326)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1196)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1173)
at _globus._testdb4__jsp._jspService(/globus/testdb4.jsp:12)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:244)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:479)
--------------------------------------------------------------------------------
Resin 2.1.6 (built Fri Nov 8 08:18:18 PST 2002)
......
Re:connection pool error
관리자 / 2003-02-12 00:00
resin설정과 스소는 문제 없어보입니다만
error 에서 XADataSource라는 부분이 보이는 것이
아무래도 의심이 갑니다.
mysql DB는 트랜잭션을 지원하지 않으므로 위의 내용이
있을 수 없거든요. XADataSource설정이 어디 남아
있는지..
resin에 Connection Pool설정 후 resin을
Restart하셨는지요.
좀 이상하네요. 저도 테스트해보았지만 전혀 문제 없었습니다
--곽상현 님의 글 [2003-02-10 16:48:35]
>한컴리눅스 2.2에서
resin을 테스트중입니다..
클래스패스는 모두 수정했습니다...
resin.conf 부분은 ....
로 수정했습니다...
아래 jsp소스를 돌리면
<%@page import=\"java.sql.*,java.lang.*,javax.sql.*, javax.naming.* \"%>
<%
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup(\"java:comp/env/jdbc/test\");
Connection conn = ds.getConnection(); <================커넥션이 사라져 버림...
%>
<%
try {
Statement stmt = conn.createStatement();
//ResultSet rs = stmt.executeQuery(\"select version* from starcraft\");
ResultSet rs = stmt.executeQuery(\"select version(),current_date\");
%>
Brooms:
<%
while (rs.next()) {
%>
<%//= rs.getString(1) %> <%//= rs.getString(2) %>
<%
}
}
finally
{
conn.close();
}
%>
웹화면에 출력되는 에러
500 Servlet Exception
java.sql.SQLException: Dropped connection
at com.caucho.jdbc.mysql.DatabaseConnection.readStatus(DatabaseConnection.java:574)
at com.caucho.jdbc.mysql.DatabaseConnection.login(DatabaseConnection.java:191)
at com.caucho.jdbc.mysql.DatabaseConnection.
at com.caucho.jdbc.mysql.Connection.create(Connection.java:126)
at com.caucho.jdbc.mysql.Driver.connect(Driver.java:113)
at com.caucho.sql.XADataSourceAdapter.getXAConnection(XADataSourceAdapter.java:119)
at com.caucho.sql.XADataSourceAdapter.getPooledConnection(XADataSourceAdapter.java:141)
at com.caucho.sql.DBPool.createConnection(DBPool.java:1391)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1326)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1196)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1173)
at _globus._testdb4__jsp._jspService(/globus/testdb4.jsp:12)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:244)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:479)
--------------------------------------------------------------------------------
Resin 2.1.6 (built Fri Nov 8 08:18:18 PST 2002)
......