急求解tomcat6.0 oracle10g数据源
server.xml中
<Context path="01" docBase="${tomcat6}/webapps/01" reloadable="true" crossContext="true">
<Resource name="jdbc/STAR"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="scott"
password="scott"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:STAR"
/>
</Context>
项目名为01,数据库名为STAR。
jsp中:
<%! DataSource ds = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
%>
<%
try {
Context ictx = new InitialContext();
Context ectx = (Context) ictx.lookup("jdbc:comp/env");
ds = (DataSource) ectx.lookup("STAR");
conn = ds.getConnection();
stmt = conn.createStatement();
stmt.executeQuery("select * from dept");
while(rs.next()){
System.out.println(rs.getString("dname"));
}
} catch (NamingException e) {
e.printStackTrace();
} catch (SQLException e1){
e1.printStackTrace();
}
%>
后台输出:javax.naming.NameNotFoundException: Name jdbc:comp is not bound in this Context
请大侠赐教,彻底蒙了