找到这个路经jboss\docs\examples\jca下有二个XML文件oracle-ds.xml,oracle-xa-ds.xml
COPY JBOSS\server\default\deploy下修改
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@youroraclehost:1521:yoursid</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>x</user-name>
<password>y</password><xa-datasource-property name="URL">jdbc:oracle:oci8:@tc</xa-datasource-property>上面是3.2以上版本3.08就是文件名字不一样修改方法一样的
COPY JBOSS\server\default\deploy下修改
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@youroraclehost:1521:yoursid</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>x</user-name>
<password>y</password><xa-datasource-property name="URL">jdbc:oracle:oci8:@tc</xa-datasource-property>上面是3.2以上版本3.08就是文件名字不一样修改方法一样的
<%@page import="java.sql.*,
javax.sql.DataSource,javax.naming.InitialContext"%>
<h3>Test MYSQL Database</h3>
<%
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:/OracleDS");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM LB_FORUM");
while ( rs.next() ) {
out.println( rs.getString(1) + "<br>");
}
conn.close();
%>