我是用的jbuilder7自带的tomcat4.0 在一个test工程里,工程是建立在E:\project\J_project\ga下的。
javabean是放在e:\test下的。
在E:\JBuilder7\jakarta-tomcat-4.0.3\conf\server.xml里加入了
1<resource auth="Container" name="jdbc/oracle" type="javax.sql.DataSource"></resource>
1<resourceparams name="jdbc/oracle">
2<parameter>
3<name>removeAbandoned</name>
4<value>true</value>
5</parameter>
6<parameter>
7<name>removeAbandonedTimeout</name>
8<value>60</value>
9</parameter>
10<parameter>
11<name>driverClassName</name>
12<value>oracle.jdbc.OracleDriver</value>
13</parameter>
14<parameter>
15<name>driverName</name>
16<value>jdbc:oracle:thin:@126.202.202.1:1521:pegasus</value>
17</parameter>
18<parameter>
19<name>user</name>
20<value>ideal_oa</value>
21</parameter>
22<parameter>
23<name>password</name>
24<value>oa</value>
25</parameter>
26<!-- Maximum number of DB connections in pool. Make sure you
27configure your postmaster max_connections large enough
28to handle all of your db connections. Set to 0 for no limit.
29\-->
30<parameter>
31<name>maxActive</name>
32<value>10</value>
33</parameter>
34<!-- Maximum number of idle DB connections to retain in pool.
35Set to 0 for no limit.
36\-->
37<parameter>
38<name>maxIdle</name>
39<value>3</value>
40</parameter>
41<!-- Maximum time to wait for a DB connection to become available
42in ms, in this example 20 seconds. An Exception is thrown if
43this timeout is exceeded. Set to -1 to wait indefinitely.
44\-->
45<parameter>
46<name>maxWait</name>
47<value>20000</value>
48</parameter>
49</resourceparams>
并在E:\JBuilder7\jakarta-tomcat-4.0.3\conf\web.xml 里加如了
1<description>oracle Test App</description>
1<resource-ref>
2<description>DB Connection</description>
3<res-ref-name>jdbc/oracle</res-ref-name>
4<res-type>javax.sql.DataSource</res-type>
5<res-auth>Container</res-auth>
6</resource-ref>
我为了保险,把server.xml 和web.xml都拷贝到了
E:\project\J_project\ga\WEB-INF
e:\test\WEB-INF 下了
程序里的代码是:
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource database = (DataSource) envCtx.lookup("oracle");
cn = database.getConnection();
可是一运行就报错误:Mon Dec 16 22:20:46 CST 2002: javax.naming.NameNotFoundException: Name java: is not bound in this Context
---------------------------------------------------------------
DataSource database = (DataSource) envCtx.lookup("oracle");
应改为:
DataSource database = (DataSource) envCtx.lookup("java/oracle");
---------------------------------------------------------------
http://expert.csdn.net/Expert/topic/1190/1190848.xml?temp=.3414881