Tomcat 6 JNDI配置及测试

来源：互联网发布：网络统考英语编辑：程序博客网时间：2024/06/06 17:18

（1）配置：

D:/apache-tomcat-6.0.30/conf/Catalina/localhost 文件夹下添加：TestWorkFlow.xml，其中TestWorkFlow为项目的context-root

<?xml version="1.0" encoding="UTF-8"?><Context path="/HaierTestWorkFlow" reloadable="true" docBase="D:/Java/HaierTestWorkFlow/WebRoot"><Loader delegate="true"/><Resource name="jdbc/oracle73" auth="Container" type="javax.sql.DataSource" username="auth" password="ouccs" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@222.195.151.73:1521:orcl" maxActive="8" maxIdle="4"/></Context>

（2）新建Jndi类

2.1 Jndi.java

package org.ouc.webNewTech.JNDI;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.naming.Context;import javax.naming.InitialContext;import javax.naming.NamingException;import javax.sql.DataSource;import oracle.jdbc.pool.OracleDataSource;public class Jndi {/** * @param args */public static void testConnection() {// TODO Auto-generated method stubString message = "Not Connected";Connection conn=null;ResultSet rst = null;Statement stmt = null;Context ctx;try {ctx = new InitialContext();Context envContext = (Context) ctx.lookup("java:comp/env");Object datasourceRef=envContext.lookup("jdbc/oracle73");DataSource ds=(DataSource)datasourceRef;conn=ds.getConnection();if (conn != null) { message = "Got Connection " + conn.toString() + ", "; stmt = conn.createStatement(); rst = stmt.executeQuery("SELECT 'Success obtaining connection' FROM DUAL"); System.out.println("Jndi Test Succeed!"); }} catch (NamingException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{if(conn!=null){try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}}

（3）测试：index.jsp

http://wiki.apache.org/tomcat/FAQ/Miscellaneous#Q22

Can I access Tomcat's JNDI provider from outside tomcat?

Not at this time.

所以，必须在tomcat容器中才能使用JNDI

如果通过main函数获取jndi

public static void main(String[] args) {testConnection();}

会出现如下错误：

javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initialat javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:645)at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:325)at javax.naming.InitialContext.lookup(InitialContext.java:392)at org.ouc.webNewTech.JNDI.Jndi.testConnection(Jndi.java:29)at org.ouc.webNewTech.JNDI.Jndi.main(Jndi.java:57)