* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.
CentOS 6.4 64bit | |
CUBRID 9.3 (9.3.5.0002) (64bit release build for linux_gnu) (Jan 18 2016 10:16:37) | |
CUBRID Manager 9.3.3.706 (64bit) | |
d |
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.
에러 내용 및 재현 방법 | 재현 가능한 Source와 SQL |
관련 테이블(인덱스, 키정보 포함) 정보 | CUBRID 홈 디렉토리 아래 log 디렉토리 압축 |
-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------
2월 25, 2016 1:40:44 오후 org.apache.catalina.core.StandardWrapperValve invoke
심각: Servlet.service() for servlet [dispatcher] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [-1150];
--- The error occurred while applying a parameter map.
--- Check the user.getArticle-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: cubrid.jdbc.driver.CUBRIDException: Context requires compatible collations.[CAS INFO-192.168.0.3:30000,2,11479],[SESSION-915],[URL-jdbc:cubrid:192.168.0.3:30000:testdb:dba:********:?charset=utf-8].; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the user.getArticle-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: cubrid.jdbc.driver.CUBRIDException: Context requires compatible collations.[CAS INFO-192.168.0.3:30000,2,11479],[SESSION-915],[URL-jdbc:cubrid:192.168.0.3:30000:testdb:dba:********:?charset=utf-8].] with root cause
cubrid.jdbc.driver.CUBRIDException: Context requires compatible collations.[CAS INFO-192.168.0.3:30000,2,11479],[SESSION-915],[URL-jdbc:cubrid:192.168.0.3:30000:testdb:dba:********:?charset=utf-8].
at cubrid.jdbc.jci.UConnection.createJciException(UConnection.java:2178)
at cubrid.jdbc.jci.UInputBuffer.<init>(UInputBuffer.java:112)
at cubrid.jdbc.jci.UConnection.send_recv_msg(UConnection.java:1751)
at cubrid.jdbc.jci.UConnection.send_recv_msg(UConnection.java:1763)
at cubrid.jdbc.jci.UStatement.executeInternal(UStatement.java:780)
at cubrid.jdbc.jci.UStatement.execute(UStatement.java:847)
at cubrid.jdbc.driver.CUBRIDStatement.executeCoreInternal(CUBRIDStatement.java:906)
at cubrid.jdbc.driver.CUBRIDStatement.executeCore(CUBRIDStatement.java:871)
at cubrid.jdbc.driver.CUBRIDPreparedStatement.execute(CUBRIDPreparedStatement.java:486)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
at com.sun.proxy.$Proxy25.execute(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
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 org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:270)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:268)
at egovframework.rte.psl.dataaccess.EgovAbstractDAO.selectByPk(EgovAbstractDAO.java:129)
at kr.co.evolcano.dao.BasicDAO.getArticle(BasicDAO.java:36)
at kr.co.evolcano.controller.PageController.login(PageController.java:58)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
에러 메세지만으로 문제를 파악하기는 어렵습니다.
콜레이션은 데이터의 정렬 순서를 결정하는 것으로
콜레이션이 다르면 값의 비교가 불가능하거나 비정상 출력됩니다.
해당 메세지로는 서버와 호스트가 아닌
쿼리문에 포함된 컬럼간, 혹은 실제 입력되는 값의 콜레이션 차이로 인해 발생하는 오류 메세지로
오류 내용만 전달받고 정확히 어떤 부분이 문제인지 확인해드리지 못하는점 죄송합니다.
테이블 내 컬럼들의 콜레이션 조회는 큐브리드 매니저 및 CSQL로 가능하니 참고해주시고
콜레이션간 변환 우선순위와 불가 내역은
아래 링크의 매뉴얼을 참고해주세요
http://www.cubrid.org/manual/ko/9.3.0/sql/i18n.html