jbuilder9+Tomcat4.1.24+oracle9 用连接池,就是报错,各位看看有没有配错.急啊.
下面是server.xml中我配的contex:
<Context debug="0" docBase="C:\abc" path="/myweb" reloadable="true" workDir="C:\abc\Tomcat\work\emrj2ee">
<Resource name="jdbc/ABCPool" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/ABCPool">
<parameter>
<name>user</name>
<value>abc</value>
</parameter>
<parameter>
<name>password</name>
<value>abc</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:oracle:thin:@192.168.0.110:1521:oradb</value>
</parameter>
</ResourceParams>
</Context>
相关程序是这样写的:
try {
Context ctx=null;
DataSource ds=null;
String dsName=null;
ctx=new InitialContext();
dsName="java:comp/env/jdbc/ABCPool;
ds=(DataSource)ctx.lookup(dsName);
conn = ds.getConnection();
System.out.println("conn:"+conn.toString());
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
运行时在后台报一大堆错:
javax.naming.NamingException: Cannot create resource instance
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:189)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301)
at org.apache.naming.NamingContext.lookup(NamingContext.java:834)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:183)
at javax.naming.InitialContext.lookup(InitialContext.java:347)
帮忙看看怎么回事.