WebLogic7.0数据源问题
古月书斋 2004-05-03 02:15:09
我在WebLogic7.0下把SQL数据源配置好了.我想用一个JSP测试一下:<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%>
<%
DataSource ds = null;
String url = "t3://localhost:7001";
String user ="hudashi";
String password ="xiaohong";
Properties properties = null;
properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY,
"weblogic.jndi.WLInitialContextFactory");
properties.put(Context.PROVIDER_URL, url);
properties.put(Context.SECURITY_PRINCIPAL, user);
properties.put(Context.SECURITY_CREDENTIALS, password);
try{
Context ctx = InitialContext(properties);
ds = (javax.sql.DataSource)ctx.lookup("test");
if(ds!=null)
{
out.println("已经获得DataSource!");
out.println("<br>");
Connection conn = ds.getConnection();
Statement stmt=conn.createStatement();
ResultSet rst=stmt.executeQuery("select * from testtable");
out.println("以下是从数据库中读取出来的数据");
while(rst.next())
{
out.println("username"+rst.getString("username"));
out.println("<br>");
}
}
else {
out.println("连接失败!");
}
}
catch(Exception ne)
{
out.println(ne);
}
%>
我把它部署成功后,访问提示错误如下:
Compilation of 'C:\bea\user_projects\mydomain\myserver\.wlnotdelete\sql_sql_3376524\jsp_servlet\__sqljsp.java' failed:
--------------------------------------------------------------------------------
C:\bea\user_projects\mydomain\myserver\.wlnotdelete\sql_sql_3376524\jsp_servlet\__sqljsp.java:112: cannot resolve symbol
probably occurred due to an error in /sqljsp.jsp line 22:
Context ctx = InitialContext(properties);
--------------------------------------------------------------------------------
Full compiler error(s):
C:\bea\user_projects\mydomain\myserver\.wlnotdelete\sql_sql_3376524\jsp_servlet\__sqljsp.java:112: cannot resolve symbol
symbol : method InitialContext (java.util.Properties)
location: class jsp_servlet.__sqljsp
Context ctx = InitialContext(properties); //[ /sqljsp.jsp; Line: 22]
^
1 error
我不知道为什么.请那个高手帮帮小弟.小弟不胜感激.我的内存256是不是太小.?