郁闷,Weblogic 8.1 sp1数据库连接问题
naxin 2003-10-16 10:47:08
建的JDBC data source 名为"ejbPool",就是连不上.测试用的testdb.jsp如下:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.* " %>
<%@ page import= "javax.sql.* " %>
<%@ page import= "javax.naming.* "%>
<%
Hashtable env = new Hashtable();
env.put(InitialContext.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
env.put(InitialContext.PROVIDER_URL,"t3://localhost:7001");
InitialContext ctx = new InitialContext(env);
DataSource ds = (DataSource)ctx.lookup("ejbPool");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " select 1 ";
ResultSet rs = stmt.executeQuery(strSql);
while(rs.next()){
out.println(rs.getString(1));
// out.println(rs.getString(2)+"<BR>");
conn.close();
%>
<hr>