Posted by:returner
Posted on:2004-11-09 22:42
tomcat5配置jndi的問題;斑竹高手們來看看啊，情況緊急！！！！！！！！10萬分感謝
這個問題我是搜索出來的，我也遇到了同樣的問題，希望高手給于關注：
http://www.cjsdn.net/post/view?bid=7&id=95089&tpg=1&ppg=1&sty=1&age=0#95089
本人的環境是Eclipse2.1.2+tomcat5.0+lomboz+mysql
$tomcat_home$/comm/lib下加入jndi.jar,mysql+jdbc驅動。
在tomcat的Sever.xml中的〈/Engine>前加入以下內容：
factory
org.apache.commons.dbcp.BasicDataSourceFactory
url
jdbc:mysql://localhost:3306/shop
driverclassname
com.mysql.jdbc.Driver
username
root
password
root
maxWait
3000
maxIdle
10
maxActive
100
在Webapps的Web.xml中加入以下內容：
connectDB test
jdbc/hibernate
javax.sql.DataSource
Container
測試代碼如下：
package com.yzs.test.hibernate;
import java.io.IOException;
import java.io.PrintWriter;
import javax.naming.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.*;
import java.sql.*;
/**
* @author yzs
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class testservlet extends HttpServlet {
protected void doGet(
HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
//TODO Method stub generated by Lomboz
Context initctx=null;
Context ctx=null;
DataSource ds=null;
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
response.setContentType("text/html");
PrintWriter out=response.getWriter();
try {
initctx=new InitialContext();
ctx= (Context) initctx.lookup("jdbc:comp/env");
ds=(DataSource)ctx.lookup("jdbc/hibernate");
if(ds==null) throw new NamingException("no database");
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn=ds.getConnection();
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from brand");
rs.next();
out.println("");
out.println("
out.println("
test jndi");out.println("");
out.println("
");out.println(rs.getString("name"));
} catch (SQLException e4) {
// TODO Auto-generated catch block
e4.printStackTrace();
}
}
}
出現了Name jdbc:comp is not bound in this Context的問題，請各位大俠
幫忙看一下問題出在哪里。
...)
