tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "red phoenix" <rodphoe...@gmail.com>
Subject Tomcat5.5.17 JNDI configure error
Date Fri, 29 Sep 2006 15:34:30 GMT
I use JDK1.6 and Tomcat5.5.17,I want to use JNDI in tomcat,so I do like
follows:
Tomcat/conf/context.xml
<Context>
<Resource name="jdbc/test"
  type="javax.sql.DataSource" auth="Container"
  driverClassName="ooracle.jdbc.driver.OracleDriver" maxActive="100"
  maxIdle="30" maxWait="10000"
  url="jdbc:oracle:thin:@localhost:1521:EDWARD"
  username="scott" password="tiger" />
   <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
 </Context>

Tomcat/conf/server.xml
......
<!-- Global JNDI resources -->
  <GlobalNamingResources>
    <!-- Test entry for demonstration purposes -->
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>

    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users -->
    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved"
           factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
          pathname="conf/tomcat-users.xml" />
  </GlobalNamingResources>
......

Tomcat/webapps/myweb/WEB-INF/web.xml
......
<resource-ref>
   <description>Oracle Datasource example</description>
  <res-ref-name>jdbc/test</res-ref-name>
   <res-type>javax.sql.DataSource</res-type>
   <res-auth>Container</res-auth>
 </resource-ref>
 </web-app>

  I call JNDI in my code,like follows:

  Context initContext = new InitialContext();
   Context envContext  = (Context)initContext.lookup("java:/comp/env");
   DataSource ds = (DataSource)envContext.lookup("jdbc/test");
   Connection conn = ds.getConnection();

 But when I run it,it raise following errors:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver
class 'oracle.jdbc.driver.OracleDriver'
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(
BasicDataSource.java:766)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(
BasicDataSource.java:540)
        at SKY.manage.loginAction.execute(test.java:35)
        at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(Execute
Action.java:53)
        at org.apache.struts.chain.commands.AbstractExecuteAction.execute(
AbstractExecuteAction.java:64)
        at org.apache.struts.chain.commands.ActionCommandBase.execute(
ActionCommandBase.java:48)
        at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java
:190)
        at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand
java:304)
        at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java
:190)

Why raise above error? Please help.

Thanks

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message