어제 커넥션 풀인지 알고 한것이 JDBC였다는걸 알았습니다.
그리고 도움으로 성공해서 너무 기뻣는데..ㅜㅜ
정작 JNDI 커넥션 풀은 진행을 못하고 있습니다. ㅜㅜ
어떻게 해야 Tomcat에서 cubrid 사용하기 문서를 클리어 해볼수 잇을까요 ㅜㅜ
조금만 도와주세요
jdk 1.6 + tomcat 6.0 + cubrid 7.1
먼저 TOMCAT6\\common\\lib이 존재하지 않아서
TOMCAT6\\lib\\에 jdbc_cubrid.jar을 복사해 넣었습니다.
------------------------------ server.xml ----------------------------------------
<Resource name=\"jdbc/CUBRIDDS\" auth=\"Container\" type=\"javax.sql.DataSource\"
factory=\"org.apache.commons.dbcp.BasicDataSourceFactory\"
driverClassName=\"cubrid.jdbc.driver.CUBRIDDriver\"
url=\"jdbc:cubrid:localhost:33000:subway:::\"
username=\"dba\" password=\"qwer\"
maxActive=\"10\"
maxIdle=\"10\"
maxWait=\"-1\"
removeAbandoned=\"true\"
removeAbandonedTimeout=\"60\"
logAbandoned=\"true\"/>
어제 답변 주신 내용으로 설정하였습니다.
------------------------------ web.xml --------------------------------------
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/CUBRIDDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
문서에 나온대로 입력하였습니다.
톰캣은 에러없이 잘 스타트 됩니다.
------------------------- cubrid_query.jsp ---------------------------------
<%@ page contentType=\"text/html; charset=euc-kr\"%>
<%@ page import=\"java.util.*\" %>
<%@ page import=\"java.sql.*\" %>
<%@ page import=\"javax.sql.*\" %>
<%@ page import=\"javax.naming.*\" %>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rset = null;
ResultSetMetaData rsmd = null;
Context initContext = new InitialContext();
DataSource ds = (DataSource) initContext.lookup(\"java:comp/env/jdbc/CUBRIDDS\");
conn = ds.getConnection(); // 이부분에서 에러남
%>
------------------------- 에러내용 ---------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class \'\' for connect URL \'null\'
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
javax.servlet.ServletException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class \'\' for connect URL \'null\'
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.query_005fcubrid_jsp._jspService(query_005fcubrid_jsp.java:79)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class \'\' for connect URL \'null\'
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
org.apache.jsp.query_005fcubrid_jsp._jspService(query_005fcubrid_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
java.lang.NullPointerException
sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source)
java.sql.DriverManager.getDriver(Unknown Source)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
org.apache.jsp.query_005fcubrid_jsp._jspService(query_005fcubrid_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.
이런 에러가 나오는데..
제가 무엇을 잘못한건지 잘 모르겠습니다.ㅜㅜ
이고비만 넘기면 이제 셋팅따위는 신경안쓰고 공부 계속할수 잇을꺼 같은데..
조금만 도와주세용..
|