Background Image

FORUM

2011.06.24 20:58

Connect Error

조회 수 19012 추천 수 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 도구 출시 안내 21 admin 2024.04.23 143856
1088 윈도우 도스 모드에서 쿼리 실행 방법 문의 1 ProMind 2011.10.12 14149
1087 [테이블의 하위 페치 중]만 계속 나오면서 DB의 테이블을 보여주지 않고 있습니다. 4 secret 어려운큐브 2011.10.11 12
1086 이미지사진파일 업로드 방법 1 우주와나 2011.10.10 14791
1085 윈도우 64Bit 버전에서 PHP에 Cubrid 모듈 올리는 방법좀 .. 1 삼돌이 2011.10.08 14406
1084 테이블 생성, 삭제, 백업 등이 되지 않습니다. 2 sugarkane 2011.10.06 10338
1083 함수 실행시 한글 깨짐 현상 4 대규 2011.10.05 14675
1082 데이터 베이스 생성이 되지 않습니다.. 1 삼돌이 2011.10.05 11228
1081 쉘스크립트파일이 cron으로는 실행이 되지않습니다. 2 secret 어려운큐브 2011.10.05 10
1080 뷰 테이블 검색 시간에 대해 궁금한점이 있습니다. 9 종이 2011.10.05 12498
1079 콘솔에서 csql로 접속할 때 인코딩 설정은 어떻게 하나요? 3 안지민 2011.09.29 14330
1078 4.0 패치2 는 언제쯤 나오나요? 3 유니콘 2011.09.28 9406
1077 8.4로 업그레이드후 cci_execute 실패 에러 10 천상하늘 2011.09.23 12092
1076 DB 접속실패 ( 7 file psygrapher 2011.09.21 14167
1075 테이블 목록확인 (show tables) 방법 문의 3 mkengnr 2011.09.20 23860
1074 Hibernate로 페이징 처리시 오류발생에 대한 내용입니다. 4 백화요란 2011.09.16 15859
1073 select count 한 개수와 select 한 개수가 다른이유는 뭘까요? 4 file 인경수 2011.09.16 14430
1072 계층적질의 결과물과 조인 시 문제점 2 하루야 2011.09.09 12256
1071 ROW_NUMBER() OVER(PARTITION BY 어떻게..해야 할까요??? 5 초식곰 2011.09.09 30372
1070 Oracle의 stored function/procedure에 대한 질문입니다. 2 배나온천사 2011.09.06 12955
1069 호스트 연결이 안되요.(비밀번호오류) 2 양희종 2011.09.06 17974
Board Pagination Prev 1 ... 154 155 156 157 158 159 160 161 162 163 ... 213 Next
/ 213

Contact Cubrid

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