Background Image

FORUM

2011.06.24 20:58

Connect Error

조회 수 14382 추천 수 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 127
공지 SQLGate for CUBRID 영구 무료 라이선스 제공 file admin 2020.04.09 4476
1063 loaddb 로 대량의 data insert 시 질문드립니다. 1 laim 2012.11.16 10420
1062 Java 저장 함수/프로시저 문의 1 초도한정 2014.01.03 10431
1061 에러 문의 1 시나브로 2016.04.19 10438
1060 CUBRID-8.2.1.0215 CentOs5.1에 설치 중입니다. 1 Philip Park 2010.01.27 10439
1059 cubrid_connect() 가 정의 되어 있지 않다고 나옵니다. 1 독고구검 2011.08.03 10439
1058 group by 오류 1 초보 2010.03.31 10444
1057 큐브리드 매니저에서 쿼리 포맷팅 기능이 있나요? 1 풀리야 2009.11.13 10448
1056 spec 나 srpm 은 어디에서 받을 수 있나요? 5 아주가끔은 2009.06.21 10448
1055 큐브리드->큐브리드 데이터 이관시 어떤 방식이 가장 좋을까요 3 호짱 2010.07.08 10467
1054 테이블 파티션 추가 문의 1 초보 2010.04.09 10470
1053 오라클과 큐브리드중 어느걸 도입해야하는지 고민중입니다. 1 신의손 2010.03.16 10475
1052 mysql 구문변환 2 초보 2010.02.03 10478
1051 리눅스 설치 확인 부탁 드립니다. 1 Philip Park 2010.02.12 10483
1050 RANK 함수 관련 질문드립니다. 2 이종진 2013.06.11 10487
1049 jboss 7.1 + cubrid 연동문의 1 khs0324 2014.05.26 10488
1048 초보질문 - insert할때 질문 1 rusell 2009.07.02 10489
1047 MSSQL같이 레코드 복사는 안 되나요? 1 하늘나무 2014.03.28 10491
1046 mysql로 마이그레이션하는방법좀.. 1 썬해바라기 2009.12.14 10494
1045 systimestamp 함수로 현재시간을 불러올 경우 에러가 발생합니다. 1 노랑배 2011.01.28 10495
1044 마이그레이션 툴문의 3 webdoors 2010.03.23 10497
Board Pagination Prev 1 ... 143 144 145 146 147 148 149 150 151 152 ... 201 Next
/ 201

Contact Cubrid

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