Java开发网 - 急问:在eclipse下启动jboss发布oracle数据源失败?何解?

Java开发网

您没有登录

» Java开发网 » Application Server

打印话题 寄给朋友 订阅主题

作者

急问:在eclipse下启动jboss发布oracle数据源失败?何解?

nikoko

发贴: 3
积分: 0

于 2005-07-09 12:35

利用jboss(jboss.3.2.1)下的bin/run.bat启动jboss后,jboss下发布的oracle数据源可以正常访问,但在eclipse(2.1.1)下启动jboss(用EASIE JBOSS1.0插件)后访问那个数据源就失败?而且是同样的访问代码,何故?访问代码是:<%@
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:/OracleDS");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') FROM DUAL");
while ( rs.next() ) {
out.println( rs.getString(1) + "＜br＞");
out.println( "My name is Justinchen＜br＞");
}
conn.close();
%>
oralce数据源的配置文件是:
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin Angry

169.10.132.222:1521:oradb2222</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>111</user-name>
<password>222</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<connection-property name="autoReconnect">true</connection-property>

<min-pool-size>5</min-pool-size>
<max-pool-size>10</max-pool-size>
<prepared-statement-cache-size>100</prepared-statement-cache-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-enabled>true</idle-timeout-enabled>
<idle-timeout-minutes>10</idle-timeout-minutes>
</local-tx-datasource>
</datasources>
望高人指点

nikoko edited on 2005-07-09 12:38

已读帖子

新的帖子

被删除的帖子