jbuilder9+Tomcat4.1.24+oracle9 用连接池,就是报错,各位看看有没有配错.急啊.

[hiphis]

下面是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)

帮忙看看怎么回事.

[Morgan_ma]

dsName="java:comp/env/jdbc/ABCPool;<-怎么只有半个双引号？
ds=(DataSource)ctx.lookup(dsName);<-问题就是出在dsName上，检查。。。

[hiphis]

"半个双引号" 是我发帖时的笔误,我用的是jbuilder,不会出这种错的.:-)