Spring Error
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S0001]; error code [4060];
--- The error occurred in cws/sqlmap/mapping/common/directory.xml.
--- The error occurred while executing query.
--- Check the SELECT nid, nname, npath, ntype, subtype, parentid, childnotdeletedcount, subindex, deleteyn, createdate, updatedate, memo, linkurl, linknewyn FROM CWS_NODE WHERE nid = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 로그인에서 요청한 데이터베이스 "NAHF_CMS_OLD2"을(를) 열 수 없습니다. 로그인이 실패했습니다. ClientConnectionId:944482b1-767c-4961-af46-959d5353c0a7; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in cws/sqlmap/mapping/common/directory.xml.
--- The error occurred while executing query.
--- Check the SELECT nid, nname, npath, ntype, subtype, parentid, childnotdeletedcount, subindex, deleteyn, createdate, updatedate, memo, linkurl, linknewyn FROM CWS_NODE WHERE nid = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 로그인에서 요청한 데이터베이스 "NAHF_CMS_OLD2"을(를) 열 수 없습니다. 로그인이 실패했습니다. ClientConnectionId:944482b1-767c-4961-af46-959d5353c0a7
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:206)
at egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:269)
at kr.co.bbdg.common.directory.service.impl.DirectoryDAOImpl.getNode(DirectoryDAOImpl.java:18)
at kr.co.bbdg.common.directory.service.impl.DirectoryServiceImpl.getNode(DirectoryServiceImpl.java:99)
at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy75.getNode(Unknown Source)
at kr.co.bbdg.site.menu.service.impl.MenuServiceImpl.getUserSiteMenuTree(MenuServiceImpl.java:158)
at sun.reflect.GeneratedMethodAccessor181.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy102.getUserSiteMenuTree(Unknown Source)
at kr.co.bbdg.main.web.UserMainController.setMenuInfo(UserMainController.java:429)
at kr.co.bbdg.main.web.UserMainController.setMenuInfoByURI(UserMainController.java:419)
at kr.co.bbdg.main.web.UserMainController.dispatchKor(UserMainController.java:218)
at sun.reflect.GeneratedMethodAccessor305.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:120)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:97)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:109)
at kr.co.bbdg.common.security.filter.HTMLTagFilter.doFilter(HTMLTagFilter.java:35)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:89)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:89)
at com.caucho.server.rewrite.SetHeaderFilterChain.doFilter(SetHeaderFilterChain.java:62)
at com.caucho.server.rewrite.SetHeaderFilterChain.doFilter(SetHeaderFilterChain.java:62)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:156)
at com.caucho.server.webapp.AccessLogFilterChain.doFilter(AccessLogFilterChain.java:95)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:289)
at com.caucho.server.hmux.HmuxRequest.handleInvocation(HmuxRequest.java:476)
at com.caucho.server.hmux.HmuxRequest.handleRequestImpl(HmuxRequest.java:374)
at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:341)
at com.caucho.network.listen.TcpSocketLink.dispatchRequest(TcpSocketLink.java:1349)
at com.caucho.network.listen.TcpSocketLink.handleRequest(TcpSocketLink.java:1305)
at com.caucho.network.listen.TcpSocketLink.handleRequestsImpl(TcpSocketLink.java:1289)
at com.caucho.network.listen.TcpSocketLink.handleRequests(TcpSocketLink.java:1197)
at com.caucho.network.listen.TcpSocketLink.handleAcceptTaskImpl(TcpSocketLink.java:993)
at com.caucho.network.listen.TcpSocketLink.handleAcceptTask(TcpSocketLink.java:945)
at com.caucho.network.listen.ConnectionTask.runThread(ConnectionTask.java:114)
at com.caucho.network.listen.ConnectionTask.run(ConnectionTask.java:93)
at com.caucho.network.listen.SocketLinkThreadLauncher.handleTasks(SocketLinkThreadLauncher.java:169)
at com.caucho.network.listen.TcpSocketResumeThread.run(TcpSocketResumeThread.java:62)
at com.caucho.env.thread2.ResinThread2.runTasks(ResinThread2.java:173)
at com.caucho.env.thread2.ResinThread2.run(ResinThread2.java:118)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in cws/sqlmap/mapping/common/directory.xml.
--- The error occurred while executing query.
--- Check the SELECT nid, nname, npath, ntype, subtype, parentid, childnotdeletedcount, subindex, deleteyn, createdate, updatedate, memo, linkurl, linknewyn FROM CWS_NODE WHERE nid = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 로그인에서 요청한 데이터베이스 "NAHF_CMS_OLD2"을(를) 열 수 없습니다. 로그인이 실패했습니다. ClientConnectionId:944482b1-767c-4961-af46-959d5353c0a7
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:271)
at egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
... 61 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 로그인에서 요청한 데이터베이스 "NAHF_CMS_OLD2"을(를) 열 수 없습니다. 로그인이 실패했습니다. ClientConnectionId:944482b1-767c-4961-af46-959d5353c0a7
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:229)
at com.sun.proxy.$Proxy127.prepareStatement(Unknown Source)
at sun.reflect.GeneratedMethodAccessor133.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
at com.sun.proxy.$Proxy128.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
... 67 more