JNDI oracle解决思路-Oracle教程-爱易网页

JNDI oracle解决思路

日期：2014-05-17　浏览次数：20777 次

JNDI oracle
我就是想测试下jndi 遇到问题
jsp文件

HTML code


<%@ page contentType="text/html;charset=gb2312"%>   
<%@ page import="java.sql.*"%> 
<html>   
    <body>   
        <%
        /*
        Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();   
        String url="jdbc:oracle:thin:@localhost:1521:orcl"; 
        String user="scott"; 
        String password="tiger"; 
        Connection conn= DriverManager.getConnection(url,user,password);   
        */
        String JNDI_STR = "java:comp/env/FirstJNDI";
        Context ctx= new InitialContext();
        DataSource ds = (Datasource) ctx.lookup(JNDI_STR);
        connection conn = ds.getConnection();
        Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   
        String sql="select * from emp";   
        ResultSet rs=stmt.executeQuery(sql);   
        while(rs.next()) {%>   
        <%=rs.getString(1)%>   
        <%=rs.getString(2)%>   
        <%out.print("<br>");%>
        <%}%>   
        <%out.print("数据库操作成功，恭喜你");%>   
        <%rs.close();   
        stmt.close();   
        conn.close();   
        %>   
    </body>   
</html>

server.xml中增加

HTML code


<Context path="/TestJNDI" docBase="Tomcat 5.5\webapps\TestJNDI" debug="5" reloadable="true" crossContext="true" workDir="">
    <Resource name="FirstJNDI" auth="Container"
        type ="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username = "scott" password="tiger"
        dirverClassName ="oracle.jdbc.OracleDriver"
        url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL"/>
</Context>

但是启动Tomcat 时报错

Assembly code

 
 2011-5-29 22:49:08 org.apache.catalina.core.AprLifecycleListener init 
 信息: Loaded APR based Apache Tomcat Native library 1.1.20. 
 2011-5-29 22:49:08 org.apache.catalina.core.AprLifecycleListener init 
 信息: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], ra 
 ndom [true]. 
 2011-5-29 22:49:08 org.apache.coyote.http11.Http11AprProtocol init 
 信息: Initializing Coyote HTTP/1.1 on http-8081 
 2011-5-29 22:49:08 org.apache.coyote.ajp.AjpAprProtocol init 
 信息: Initializing Coyote AJP/1.3 on ajp-8009 
 2011-5-29 22:49:08 org.apache.catalina.startup.Catalina load 
 信息: Initialization processed in 922 ms 
 2011-5-29 22:49:08 org.apache.catalina.core.StandardService start 
 信息: Starting service Catalina 
 2011-5-29 22:49:08 org.apache.catalina.core.StandardEngine start 
 信息: Starting Servlet Engine: Apache Tomcat/5.5.33 
 2011-5-29 22:49:08 org.apache.catalina.core.StandardHost start 
 信息: XML validation disabled 
 2011-5-29 22:49:08 org.apache.catalina.core.StandardContext resourcesStart 
 严重: Error starting static Resources 
 java.lang.IllegalArgumentException: Document base C:\Program Files\Apache Softwa 
 re Foundation\Tomcat 5.5\webapps\Tomcat 5.5\webapps\TestJNDI does not exist or i 
 s not a readable directory 
         at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext. 
 java:141) 
         at org.apache.catalina.core.StandardContext.resourcesStart(StandardConte 
 xt.java:3895)

免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。

JNDI oracle解决思路

相关资料更多>

推荐阅读更多>