Background Image

FORUM

2011.06.24 20:58

Connect Error

조회 수 14381 추천 수 0 댓글 1
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄

큐브리드 설정 정보 입니다.

jdbc.driverClassName=cubrid.jdbc.driver.CUBRIDDriver

jdbc.url=jdbc:CUBRID:172.21.0.90:33000:PMS:::charset=EUC-KR;


위와 같이 설정하여 db연결을 하는데 항상 연결되는것이 아니라 가끔씩 아래와 같이 오류가 발생합니다.


2011. 6. 22 오전 9:15:33 org.apache.catalina.core.StandardWrapperValve invoke

심각: Servlet.service() for servlet dispatcher threw exception

cubrid.jdbc.driver.CUBRIDException: Cannot connect to a broker

at cubrid.jdbc.driver.CUBRIDConnection.getTransactionIsolation(CUBRIDConnection.java:364)

at org.apache.commons.dbcp.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:313)

at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getTransactionIsolation(PoolingDataSource.java:239)

at org.springframework.jdbc.datasource.DataSourceUtils.prepareConnectionForTransaction(DataSourceUtils.java:173)

at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:210)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)

at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:124)

at com.yuraeltec.common.model.process.TransactionalProcessGroup.proceed(TransactionalProcessGroup.java:64)

at com.yuraeltec.common.model.process.AbstractProcessGroup.process(AbstractProcessGroup.java:65)

at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:76)

at com.yuraeltec.common.aop.GroupServiceAdvice.aroundTransactionProcess(GroupServiceAdvice.java:57)

at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:576)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:562)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:60)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy11.process(Unknown Source)

at com.yuraeltec.common.util.DelegateUtils.defaultSelectProcess(DelegateUtils.java:40)

at com.yuraeltec.system.model.web.control.SelectDelegate.SelectMainApprovalCountNum(SelectDelegate.java:600)

at com.yuraeltec.system.model.web.control.SelectDelegate$$FastClassByCGLIB$$13133095.invoke(<generated>)

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:695)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:630)

at com.yuraeltec.system.model.web.control.SelectDelegate$$EnhancerByCGLIB$$a1ba7149.SelectMainApprovalCountNum(<generated>)

at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:434)

at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:372)

at com.yuraeltec.common.web.WebDefaultHandler.handleRequestInternal(WebDefaultHandler.java:38)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:857)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:792)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:461)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:416)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)

at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)

at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)

at java.lang.Thread.run(Unknown Source)


추가적으로 연결 설정하여 계속적인 conntect를 유지하는 방법이 있는지 궁금합니다.

  • ?
    손승일 2011.07.19 20:02

    답변이 많이 늦어서 죄송합니다.

    추가 질문이 없었던 것으로 보아 아마 이미 해결 하셨을 것 같습니다만 답변을 드립니다.

    사용하고 계시는 CUBRID 버전이 R3.0이상이라면 url에 charset을 명시할 때 물음표(?)을 함께 붙여 주시기 바랍니다.

    즉, jdbc.url=jdbc:CUBRID:172.21.0.90:33000:PMS:::?charset=EUC-KR 와 같이 사용하시기 바랍니다.

    혹시 위와 같이 설정한 후에도 동일한 문제가 계속된다면 $CUBRID/conf/cubrid_broker.conf 파일에 SESSION_TIMEOUT 값을 -1로 변경 하신 후 브로커를 재시작하여 설정을 적용한 후 사용해보시기 바랍니다.


List of Articles
번호 제목 글쓴이 날짜 조회 수
공지 CUBRID 사용자를 위한 DBeaver 도구 출시 안내 admin 2024.04.23 51
공지 SQLGate for CUBRID 영구 무료 라이선스 제공 file admin 2020.04.09 4458
3994 큐브리드 다운로더 오류 발생 5 file 차오이 2008.11.22 78497
3993 큐브리드 2008 설치시 윈도우 서비스에 등록되지 않습니다. 3 file 진이 2008.11.22 63170
3992 .NET DB 제어를 위한 방법. 2 우페 2008.11.23 60878
3991 Image 데이터타입 사용방법 3 AD 2008.11.25 73850
3990 windows CUBRID PHP module 5 우페 2008.11.25 51099
3989 이전버전 제거시 오류 7 doplee 2008.11.26 53102
3988 update 쿼리를 이용한 시리얼 수정에 관하여 1 인경수 2008.11.27 63454
3987 cub_master: Cannot bind local address... aborting.... Address already in use 4 박상현 2008.11.28 83565
3986 JDK가 두개 설치된 경우 선택적으로 JDK를 설정 할 수 있는 방법은 없는지요 1 GoFly 2008.11.28 60615
3985 더 정확히 하자면 서버실행은 되지만 Manager가 실행이;;;; 1 file GoFly 2008.11.28 49420
3984 델파이에서는 어떻게 사용할수 있을까요? 2 이상원 2008.11.29 65568
3983 linux server 환경에서 php 버전은 어떤걸로 선택해야하는지. 1 거기 2008.11.30 66366
3982 안녕하세요 김범준님.. 3 GoFly 2008.12.01 30837
3981 시간표현 문제 2 asteroid 2008.12.02 30265
3980 Cubrid 2008 srpm 공개 여부? 1 김정균 2008.12.04 41384
3979 CUBRID 설치 문의 입니다. 1 해바라기 2008.12.04 27379
3978 DB 서버 자동 실행 문의. 1 우페 2008.12.04 30520
3977 2008 RC1.1 매니저 실행에 대한 문제점과 임시적인 해결책 1 GGG특별대원 2008.12.05 27220
3976 csql 유틸리티에서 쿼리플랜 확인 1 asteroid 2008.12.05 28258
3975 설치관련 다시 질문 올립니다. 2 해바라기 2008.12.05 17858
Board Pagination Prev 1 2 3 4 5 6 7 8 9 10 ... 200 Next
/ 200

Contact Cubrid

대표전화 070-4077-2110 / 기술문의 070-4077-2113 / 영업문의 070-4077-2112 / Email. contact_at_cubrid.com
Contact Sales