헤르메스 LIFE

[Exception] org.apache.tomcat.dbcp.dbcp.SQLNestedException 본문

Exception

[Exception] org.apache.tomcat.dbcp.dbcp.SQLNestedException

헤르메스의날개 2010. 8. 9. 14:30
728x90

DBCP 테스트 중 아래와 같은 에러발생시...

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '
' for connect URL 'null'

<Context path="" docBase="ROOT" debug="0" reloadable="true" />  <==
이 루트 컨텍스트를 정의한 컨텍스트 엘레먼트의 태그가 닫혀있을 경우 에러가 발생한다.

정상적인 예 ...
========================================================================================

  <Host name="localhost" debug="0" appBase="/"
    unpackWARs="true" autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false">

   <Context path="/" docBase="D:/publicclass" debug="1" reloadable="true" crossContext="true" > <== 여기가 닫혀 있으면 안된다.

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

    <ResourceParams name="jdbc/OracleDB">

     <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
     </parameter>

     <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
     </parameter>

     <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@192.168.1.126:1521:ORA9</value>
     </parameter>

     <parameter>
      <name>username</name>
      <value>SCOTT</value>
     </parameter>

     <parameter>
      <name>password</name>
      <value>TIGER</value>
     </parameter>

     <parameter>
      <name>maxActive</name>
      <value>20</value>
     </parameter>

     <parameter>
      <name>maxIdle</name>
      <value>10</value>
     </parameter>

     <parameter>
      <name>maxWait</name>
      <value>-1</value>
     </parameter>

    </ResourceParams>
   </Context> <== 여기서 닫혀야 한다.

<Logger className="org.apache.catalina.logger.FileLogger"
       directory="logs"  prefix="localhost_log." suffix=".txt"
       timestamp="true"/>

</Host>


728x90