高手请指点：Servlet与Oracle 8i 的联接问题
最近写了一个测试JDBC的Servlet。布置了以后，通过访问并不出错，可什么也不显示。不知是什么在做怪。请高手指点指点。
源程序如下：
package testservlet;
import java.io.*;
import java.sql.*;
import javax.sql.*;
import java.text.*;
import java.util.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.ibm.db.*;
import com.ibm.ejs.dbm.jdbcext.*;
/**
* Insert the type's description here.
* Creation date: (2003-8-1 9:38:48)
* @author:
*/
public class TestJDBC extends HttpServlet {
private static DataSource ds=null;
/**
* Process incoming HTTP GET requests
*
* @param request Object that encapsulates the request to the servlet
* @param response Object that encapsulates the response from the servlet
*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
performTask(request, response);
}
/**
* Insert the method's description here.
* Creation date: (2003-8-1 10:26:55)
* @param js com.ibm.websphere.xmlconfig.ServletConfig
* @exception javax.servlet.ServletException The exception description.
*/
public void init(ServletConfig js) throws ServletException{
super.init(js);
}
/**
* Process incoming requests for information
*
* @param request Object that encapsulates the request to the servlet
* @param response Object that encapsulates the response from the servlet
*/
public void performTask(HttpServletRequest request, HttpServletResponse response) {
try
{
response.setContentType("text/html");
PrintWriter out=new PrintWriter(response.getOutputStream());
out.println("<html>");
out.println("<head><title>JDBC test</title></head>");
out.println("<body>");
Properties env=new Properties();
env.put(Context.INITIAL_CONTEXT_FACTORY,
"com.ibm.websphere.naming.WsnInitialContextFactory");
Context ctx=new InitialContext(env);
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/OraTest");
Connection con=ds.getConnection();
String sql="select * from rooms";
PreparedStatement stmt=con.prepareStatement(sql);
ResultSet rs=stmt.executeQuery();
while (rs.next()){
out.println(rs.getString(1)+","+rs.getString(2)+"<br>");
}
stmt.close();
con.close();
out.println("</body></html>");
out.close();
}
catch(Throwable theException)
{
// uncomment the following line when unexpected exceptions
// are occuring to aid in debugging the problem.
theException.printStackTrace();
}
}
}
运行环境为：WebSphere Application Server 4.0;
Oracle 8i
不知是什么原因。请多多指教，小弟先谢了！
问题点数：0、回复次数：1Top
1 楼Angeller（天使姐姐）回复于 2003-08-03 13:30:42 得分 0
可能是数据源没有配置对啦
你catch（Exception e）
『
System.err.println(e.getMessage());
』
看看？Top
