안녕하십니까 kenu님 (그 밖에 다른 고수님들도...^^!)

 

kenu님께서 알려 주신 대로..

C:\Tomcat 5.5\conf\Catalina\localhost\chap07.xml 의 이름으로 파일을 만들었습니다. (아래 참조1.)

그러나

http://localhost:8080/chap07/jdbc06.jsp 를 실행하면 아래와 같은 Error가 뜨는데요..

(아랫 부분 참조 2)

 

제 나름대로 콘솔에서    System.out.println("Error");  

로 확인해 본 바로는

jdbc06.jsp / stmt = conn.createStatement();

이 부분이 문제가 아닌가 하는데요...

 

혹시나 해서..

DsConn 에서 아랫 부분을 추가하여

DataSource ds = (DataSource) envContext.lookup("jdbc/myORCL");
if (ds != null) {
     System.out.println("Null 아니라네.. ");
}

null 체크를 해봐도 널이 아닌 것으로 나옵니다

움.. 뭐가 문제일까요..

 

그리고 이클립스 콘솔화면에서 이런 문구도 뜨네요...

2005. 4. 23 오후 11:13:49 org.apache.catalina.core.StandardWrapperValve invoke

 

 

요 것 때문에 꼬박 이틀 삽질 중이라서.. 흑흑흑..

고수님들의 조언 부탁드립니다...

 

경기도 박모군 드림

 

참조1

<?xml version='1.0' encoding='utf-8'?>
<!-- Tomcat chap07 Context -->
<Context path="/chap07" docBase="chap07" debug="0" reloadable="true">
    <Logger className="org.apache.catalina.logger.FileLogger"
         prefix="localhost_chap07_log." suffix=".txt" timestamp="true"/>
    <Resource name="jdbc/myORCL" auth="Container"
        type="javax.sql.DataSource"/>

    <ResourceParams name="jdbc/myORCL">
        <parameter>
            <name>factory</name>
            <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
        </parameter>
    <!-- Maximum number of dB connections in pool. Make sure you
         configure your oracle max_connections large enough to handle
         all of your db connections. Set to 0 for no limit.
         -->
        <parameter>
            <name>maxActive</name>
            <value>50</value>
        </parameter>
    <!-- Maximum number of idle dB connections to retain in pool.
         Set to 0 for no limit.
         -->
        <parameter>
            <name>maxIdle</name>
            <value>30</value>
        </parameter>
    <!-- Maximum time to wait for a dB connection to become available
         in ms, in this example 10 seconds. An Exception is thrown if
         this timeout is exceeded.  Set to -1 to wait indefinitely.
         -->
        <parameter>
            <name>maxWait</name>
            <value>10000</value>
        </parameter>

        <parameter>
          <name>removeAbandoned</name>
          <value>true</value>
        </parameter>
        <parameter>
          <name>removeAbandonedTimeout</name>
          <value>60</value>
        </parameter>
        <parameter>
          <name>logAbandoned</name>
          <value>true</value>
        </parameter>

        <parameter>
          <name>username</name>
          <value>scott</value>
        </parameter>
        <parameter>
          <name>password</name>
          <value>tiger</value>
        </parameter>
        <parameter>
          <name>driverClassName</name>
          <value>oracle.jdbc.driver.OracleDriver</value>
        </parameter>
        <parameter>
          <name>url</name>
          <value>jdbc:oracle:thin:@localhost:1521:ORCL</value>
        </parameter>
    </ResourceParams>
</Context>

 

참조2.

HTTP Status 500 -

---

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NullPointerException
	org.apache.jsp.jdbc06_jsp._jspService(org.apache.jsp.jdbc06_jsp:132)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.7 logs.

---

Apache Tomcat/5.5.7