톰캣과 호스팅서버 큐브리드 연동법 질문합니다. (JDBC)

by ditatiic posted May 23, 2013

* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.
OS
OSX
CUBRID Ver.
2008 R2.1
CUBRID TOOL Ver.

CUBRID Manager


버전:2008 R3.1

빌드 번호:8.3.1.0151

응용 환경(API)
java, jsp, jdbc

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


-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------



cubrid_jdbc.jar 추가 후

톰캣과 큐브리드 연결시..

윈도우에서 로컬로 사용하다가 이번에 처음 카페24를 통해 서버호스팅을 받았는데요.


<Resource name="jdbc/CUBRIDDS" auth="Container" type="javax.sql.DataSource"

username="아이디" password="비번" driverClassName="cubrid.jdbc.driver.CUBRIDDriver"

url="jdbc:cubrid:아이디.cafe24.com:30000:db명:::" maxActive="10" maxIdle="4" />


이렇게 설정하는 게 아닌가요? 계속 아래와 같은 에러가 발생합니다.


어디가 잘못된 것인지요ㅠㅠ


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

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)

at java.net.Socket.connect(Socket.java:529)

at java.net.Socket.connect(Socket.java:478)

at cubrid.jdbc.net.BrokerHandler.connectBroker(BrokerHandler.java:29)

at cubrid.jdbc.jci.UConnection.reconnectWorker(UConnection.java:1572)

at cubrid.jdbc.jci.UConnection.reconnect(UConnection.java:1657)

at cubrid.jdbc.jci.UConnection.checkReconnect(UConnection.java:1813)

at cubrid.jdbc.jci.UConnection.tryConnect(UConnection.java:258)

at cubrid.jdbc.driver.CUBRIDDriver.connect(CUBRIDDriver.java:230)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580)

at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222)

at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)

at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)

at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)

at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82)

at dao.UserDAO.getUserCode(UserDAO.java:84)

at service.TnxService.getUserCode(TnxService.java:107)

at controller.UserAction.login(UserAction.java:54)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

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

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

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:859)

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

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

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)

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

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

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

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:127)

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

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:861)

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

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

at java.lang.Thread.run(Thread.java:680)




Articles