ResinEE3.01 下ORACLE数据源配置?文档中有两种,各为何意???
LK007 2003-10-15 11:33:19 在Resin3.01里的帮助文档里http://localhost:8080/doc/db/thirdparty.xtp#Oracle 对JDBC的配置格式为:
Oracle JDBC configuration
<database>
<name>jdbc/oracle</name>
<driver-class>oracle.jdbc.pool.OracleConnectionPoolDataSource</driver-class>
<driver-url>jdbc:oracle:thin:@localhost:1521:dbname</driver-url>
<user>username</user>
<password>password</password>
...
</database>
而在文档里的:http://localhost:8080/doc/db/scrapbook.xtp#What-is-the-class-I-get-as-a-DataSource? 处又有有关JDBC配置的格式:
Oracle Configuration for Resin 3.0 - ConnectionPoolDataSource
<database name="jdbc/oracle"
driver-class="oracle.jdbc.pool.OracleConnectionPoolDataSource">
<driver-init url="jdbc:oracle:thin:@gryffindor:1521:ferg"
user=""
password=""/>
</database>
两种配置都可以成功的启动RESIN3 ,但是在JAVA中用如下程式连数据库时,只有后者可以连接成功.使用前者时,总是提示无效的ORACLE URL:
try{
Context ic = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)ic.lookup("java:comp/env/jdbc/oracle");
myConnection=ds.getConnection();
} catch (Exception e)
{
System.out.println(e.getMessage());
}
if (myConnection ==null)
{
System.out.println("testsadfasdfasdfasdfasdfasdfasdf-----------------------");
}
return myConnection ;