기술지원 문의

서버 재부팅 후 SQLException이 납니다.
김길순 / 2004-02-23 16:29

안녕하세요 

IIS + 레진2.1.12 + MSSQL2000로 만들어진 사이트가 있는데요 

서버를 재부팅한 후 로그인이나 다른 dbconnection하는 일을 하게되면 

500 Servlet Exception
java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]The requested instance is either invalid or not running.
at inc.loginsrv.checkID(loginsrv.java:111)
at inc.loginsrv.execute(loginsrv.java:37)
at inc.DefaultAction.doGet(DefaultAction.java:18)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]The requested instance is either invalid or not running.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.mapInstanceNameToPort(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
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:1452)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1353)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1203)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1177)
at inc.DBUtil.getConnect(DBUtil.java:32)
at inc.loginsrv.checkID(loginsrv.java:90)
... 11 more


--------------------------------------------------------------------------------
Resin 2.1.12 (built Tue Dec 9 14:58:25 PST 2003) 

이런 에러가 납니다. 그래서 다시 시도하면 아무 문제 없이 되구요... 

설정이 잘못된건지... 서버 재부팅후에 처음 꼭 한번은 이런 에러가 나니 이유를 모르겠네요... 

conf파일 첨부합니다. 이유좀 알려주세요

[Re]서버 재부팅 후 SQLException이 납니다.
관리자 / 2004-02-23 17:45

유효하지 않은 JDBC 드라이버를 사용해서 발생하는 메시지인데,
재부팅후 한번만 이런 메시지가 나오고 그 후로는 문제 없이 사용 가능 하다고 하니... ^^;

일단 새로운 JDBC드라이버를 받아서 사용하시는 것이 어떨까 합니다. 말그대로 JDBC문제 일 수 있으니까요.
다운로드 받으실때 Supported 하는 Operating Systems 무엇인지 확인하시고((예)Linux, Windows 2000 Service Pack 3), 사용가능 jdk버전도 확인하세요.

그리고, 다른 JDBC driver와 충돌이 없는지 classpath, 그 밖의 환경에 대해 확인하세요.(중복체크)

확인후, CLASSPATH에 jdbc드라이버를 추가하거나 $RESIN_HOME/lib에 해당 드라이버 파일들을 넣어 놓고 다시 테스트해보세요.