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 50
공지 SQLGate for CUBRID 영구 무료 라이선스 제공 file admin 2020.04.09 4458
474 sys_time 관련 문의드립니다. 1 말큼 2016.10.21 14080
473 java store procedure 실행시 "Java VM is not running" 오류 3 jetli_2012 2011.10.25 14088
472 테이블 컬럼에 COMMENT 추가는 어떻게 하나요? 1 파나순 2009.09.29 14096
471 자바 저장함수 속도 관련문제요.. 1 owlowl 2016.08.11 14118
470 데이터베이스 오류문제 7 pictions 2009.12.30 14120
469 트리거 동작 문의 1 종이 2016.08.12 14126
468 cubrid 2008 windows버전에서의 CUBRID_Service_Tray 실행오류 2 마비토 2009.02.12 14156
467 CUBRID Exception에 대해서 1 해킹 2013.04.26 14164
466 JPA 연동 시 질문 1 sensible13 2013.09.28 14186
465 2013년 현재 CUBRID 9.1에 DBLink 같은 기능이 있는지 궁금합니다. 1 뒷태지존 2013.04.30 14199
464 큐브리드 OLEDB 성능 문제 및 오류 2 file 쭈난 2010.01.18 14208
463 우분투서버에서 php모듈 설치때 1 NoisyWalker 2009.01.28 14214
462 auto increment 사용시 Insert 문제 1 지니보이 2009.11.11 14220
461 DB connect문제 질문입니다. 2 김주현 2009.04.17 14241
460 세로 데이터를 가로로 출력 문의 2 jjobi 2010.11.20 14268
459 io 확인 2 으아악 2016.10.18 14271
458 invalid buffer position 1 소라게 2013.09.26 14272
457 큐브리드 서버간 data 전송 1 응가돌이 2013.05.08 14281
456 [요청]JDBC를 이용하여 연결 할때 오류가 발생합니다. 3 슬픈앙마류 2013.05.14 14287
455 query 실행 로그도 있나요? 1 봉보로봉봉 2016.08.29 14290
Board Pagination Prev 1 ... 172 173 174 175 176 177 178 179 180 181 ... 200 Next
/ 200

Contact Cubrid

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