我配置好了TOMCAT 数据库等全部搞定,现在用一个测试页面来测试我的配置是否出现问题。以下是测试代码:
<%@ page language="java" contentType="text/html; charset=gb2312" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="javax.naming.InitialContext" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<html>
<head> </head> <body> <%
DataSource ds = null;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("JDBC/sql");
if(ds!=null){
out.println("Connection is OK!");
Connection cn=ds.getConnection(); if(cn!=null){
out.println("cn is Ok!");
Statement stmt = cn.createStatement(); ResultSet rst = stmt.executeQuery("select * from book"); out.println("rst is Ok!"+"<br>");
while(rst.next()){
out.println(rst.getString(1));
out.println(rst.getString(2));
out.println("<br>");
} cn.close();
} else {
out.println("rst Fail!");
}
} else {
out.println("Fail!");
}
}catch(Exception ne){
out.println(ne);
}
%>
</body>
</html> 问题是:
javax.naming.NameNotFoundException: Name JDBC is not bound in this Context 现在不知道应该怎么处理 请给与帮助呀!也可留下MSN ,QQ等 在线聊天工具,直接帮我在线解答,高手请进来啊!小弟在此先谢了!
<%@ page language="java" contentType="text/html; charset=gb2312" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="javax.naming.InitialContext" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<html>
<head> </head> <body> <%
DataSource ds = null;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("JDBC/sql");
if(ds!=null){
out.println("Connection is OK!");
Connection cn=ds.getConnection(); if(cn!=null){
out.println("cn is Ok!");
Statement stmt = cn.createStatement(); ResultSet rst = stmt.executeQuery("select * from book"); out.println("rst is Ok!"+"<br>");
while(rst.next()){
out.println(rst.getString(1));
out.println(rst.getString(2));
out.println("<br>");
} cn.close();
} else {
out.println("rst Fail!");
}
} else {
out.println("Fail!");
}
}catch(Exception ne){
out.println(ne);
}
%>
</body>
</html> 问题是:
javax.naming.NameNotFoundException: Name JDBC is not bound in this Context 现在不知道应该怎么处理 请给与帮助呀!也可留下MSN ,QQ等 在线聊天工具,直接帮我在线解答,高手请进来啊!小弟在此先谢了!
<Resource name="JDBC/sql" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="JDBC/sql">
http://www.7880.com/info/Article-37f05fa0.html
<resource-ref>
<description>sqlserverDB Connection</description>
<res-ref-name>jdbc/******</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
你是用JDBC來做連接橋的
Sql2000中需要開1433的通信端口。chs_sql2ksp3.exe,這個程序就是用來開啟端口的。
只要開啟端口 一切問題就解決了。
開啟後你可以通過Bean來封裝連接數據庫,之後useBean就可以了
DOS下 netstat -an察看。
chs_sql2ksp3.exe遮個微軟的網站有下載
ds = (DataSource)envCtx.lookup("JDBC/sql");
配置错误
ds = (DataSource)envCtx.lookup("JDBC/sql");
可能少了个“/”,
应该是Context envCtx = (Context) initCtx.lookup("java:comp/env/");