Background Image

FORUM

  1. Home
  2. FORUM
  3. Q&A
2015.07.04 01:19

jdbc 설정이 안됩니다.

kty7777
조회 수 10578 추천 수 0 댓글 2
?

단축키

Prev이전 문서

Next다음 문서

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

* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.
OS
 Window7 32bit
CUBRID Ver.
 9.2
CUBRID TOOL Ver.
 9.3.1.703
응용 환경(API)
 java jsp

* CUBRID 응용 오류, SQL 오류 또는 SQL 튜닝 관련된 문의는 반드시 다음의 내용을 추가해 주세요. 비밀글이나 비밀 댓글도 가능합니다.
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.
에러 내용 및 재현 방법 재현 가능한 Source와 SQL
관련 테이블(인덱스, 키정보 포함) 정보 CUBRID 홈 디렉토리 아래 log 디렉토리 압축

-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------
 <Context docBase="KCG_STAMINA" path="" reloadable="true" source="org.eclipse.jst.jee.server:KCG_STAMINA">
<Resource name="jdbc/wcms" auth="Container" type="javax.sql.DataSource"
              factory="org.apache.commons.dbcp.BasicDataSourceFactory"
user="dba"
password="qwe123"
driverClassName="cubrid.jdbc.driver.CUBRIDDriver"
url="jdbc:cubrid:192.168.0.81:30000:KCG_DATA:::?charset=UTF-8"
removeAbandoned="true" 
removeAbandonedTimeout="60" 
logAbandoned="true" 
maxActive="500" 
maxIdle="30" 
maxWait="180"
/>      
      </Context>



java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy29.toString(Unknown Source)
at java.lang.String.valueOf(Unknown Source)
at java.lang.StringBuffer.append(Unknown Source)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
at kr.co.hanshinit.wcms.dao.impl.SiteDaoImpl.getSite(SiteDaoImpl.java:23)
at kr.co.hanshinit.wcms.service.impl.SiteServiceImpl.getSite(SiteServiceImpl.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.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:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
at kr.co.hanshinit.wcms.aspect.LoggingAspect.logging(LoggingAspect.java:19)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.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:627)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy6.getSite(Unknown Source)
at kr.co.hanshinit.wcms.service.impl.TemplateServiceImpl.getTemplateMainData(TemplateServiceImpl.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.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:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
at kr.co.hanshinit.wcms.aspect.LoggingAspect.logging(LoggingAspect.java:19)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.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:627)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy24.getTemplateMainData(Unknown Source)
at kr.co.hanshinit.wcms.action.SiteMainAction.execute(SiteMainAction.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsExecuteFilter.doFilter(StrutsExecuteFilter.java:93)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:65)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter(StrutsPrepareFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at kr.co.hanshinit.wcms.filter.WcmsLogFilter.doFilter(WcmsLogFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Incorrect or missing password.[CAS INFO - 192.168.0.81:30000,0],[SESSION-0],[URL-jdbc:cubrid:192.168.0.81:30000:KCG_DATA::********:?charset=UTF-8].)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
... 103 more
Caused by: cubrid.jdbc.driver.CUBRIDException: Incorrect or missing password.[CAS INFO - 192.168.0.81:30000,0],[SESSION-0],[URL-jdbc:cubrid:192.168.0.81:30000:KCG_DATA::********:?charset=UTF-8].
at cubrid.jdbc.jci.UConnection.connectDB(UConnection.java:1773)
at cubrid.jdbc.jci.UConnection.reconnectWorker(UConnection.java:1730)
at cubrid.jdbc.jci.UConnection.reconnect(UConnection.java:1828)
at cubrid.jdbc.jci.UConnection.checkReconnect(UConnection.java:1999)
at cubrid.jdbc.jci.UConnection.tryConnect(UConnection.java:308)
at cubrid.jdbc.driver.CUBRIDDriver.connect(CUBRIDDriver.java:234)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 107 more

이유좀 알려주세요 ㅠㅠㅠ
위로 아래로 댓글로 가기 인쇄
에디터 선택하기
?
Comments '2'
  • ?
    김승훈 2015.07.04 01:35

    안녕하세요. 큐브리드를 이용해 주셔서 감사합니다.


    Exception 아래 부분을 보니 CUBRID JDBC url 부분에 ID 부분이 "" (empty string)으로 확인이 되네요.

    이때문에 암호가 맞아도 Incorrect or missing password 메시지가 발생할 수도 있습니다.

    DB 설정 부분에서 ID를 입력하는 속성을 확인해보시기 바랍니다.

    아니면 url 부분에 다음과 같이 ID와 PASSWORD를 넣으신 뒤 수행해 보시기 바랍니다.

    "jdbc:cubrid:192.168.0.81:30000:KCG_DATA:dba:qwe123:?charset=UTF-8"


    추가로 CUBRID 엔진 버전과 사용하시는 JDBC 드라이버 버전도 일치시키신 뒤 수행하시기 바랍니다.


    감사합니다.


    댓글
  • ?
    kty7777 2015.07.04 01:43

    아 URL 고쳐서 다시 돌려보니 돌아가네요! 감사합니다!

    하지만 새로운 오류가 발생했다는..

    DB는 접속이 된것 같습니다

    댓글
List of Articles
번호 제목 글쓴이 날짜 조회 수
공지 CUBRID 사용자를 위한 DBeaver 도구 출시 안내 21 admin 2024.04.23 143863
2208 에러 메세지에 대해서 분석좀 부탁 드리겠습니다. 1 특수요원 2015.11.03 7755
2207 ADO.NET 관련 질문 1 할리 2015.10.30 9078
2206 큐브리드 파라미터 관련 문의 1 아라천 2015.10.29 7276
2205 tibero에서 cubrid로 마이그레이션 관련 문의 1 이보학 2015.10.27 13094
2204 큐브리드 함수관련 질문드려요~~ 1 곰팅팅이 2015.10.27 7880
2203 방화벽 포트 사용 문의입니다. 2 플레이아데스 2015.10.26 7178
2202 솔라리스 사용 가능 버전 1 CUCUCUCU 2015.10.23 6964
2201 사용자 권한 회수 4 곰팅팅이 2015.10.23 7760
2200 ADO.Net 사용중입니다. 상태확인 방법을 알고 싶습니다. 1 CUCUCUCU 2015.10.22 8465
2199 한글깨짐 문의드립니다 1 곰팅팅이 2015.10.21 8335
2198 이중화 구성시 펑션 class 위치 1 secret 차차오 2015.10.19 9
2197 cubrid에서 외래키 null 허용 4 비제이판 2015.10.19 10649
2196 Cubrid JNDI 설정법 3 secret 도린아빠 2015.10.16 14
2195 cubridmanager 실행시 오류 1 이재은 2015.10.14 7408
2194 큐브리드 데이터 베이스 오류입니다. 6 소소 2015.10.14 9735
2193 엑셀 가져오기시 한글 일부 깨짐 1 file 산업일꾼 2015.10.14 10750
2192 루비 2.x 드라이버 지원 문의 1 enak 2015.10.11 7739
2191 테이블을 메뉴로 삭제한 후 같은 이름으로 테이블을 생성할 수가 없습니다. 1 secret 너랑이마녀 2015.10.09 8
2190 cubrid manager 가 start 가 되지 안습니다. 2 secret 청백-e 2015.10.07 15
2189 큐브리드 사용 중 문제가 발생하였습니다. 1 file 도린아빠 2015.10.06 9229
Board Pagination Prev 1 ... 98 99 100 101 102 103 104 105 106 107 ... 213 Next
/ 213

Contact Cubrid

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

Site Map