jboss jndi的配置

jboss设置jndi数据源

1. 把docs/examples/jca/oracle-ds.xml文件复制到/server/default/deploy目录下,改一下oracle-ds.xml.

在jndi-name后，要添加：

<use-java-context>false</use-java-context>

2.修改standardjaws.xml 或jaws.xml配置文件，并把<datasource>和<type-mapping>元素这只为下面这样：

<jaws>

<datasource>java:/OracleDS</datasource>

<type-mapping>Oracle 9i</type-mapping>

</jaws>



3.修改standardjbosscmp-jdbc.xml 或 jbosscmp-jdbc.xml配置文件,置<datasource>和 <datasource-mapping>元素使用Oracle :

<datasource-mapping>

<defaults>

<datasource>java:/OracleDS</datasource>

<datasource-mapping>Oracle 9i</datasource-mapping>

</defaults>

</datasource-mapping>

4.最后我们需要修改login-config.xml文件来使用Oracle，下面是login-config.xml文件的<application-policy>元素：

<application-policy name = "OracleDbRealm">

<authentication>

<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"

flag = "required">

<module-option name = "principal">scott</module-option>

<module-option name = "userName">scott</module-option>

<module-option name = "password">tiger</module-option>

<module-option name ="managedConnectionFactoryName">

jboss.jca:service=LocalTxCM,name=OracleDS

</module-option>

</login-module>

</authentication>

</application-policy>



//测试代码:

<%

Context initialContext = new InitialContext();

DataSource ds = (DataSource) initialContext.lookup("java:/OracleDS");

java.sql.Connection conn = null;

try {

conn = ds.getConnection();

Statement stat = conn.createStatement();

ResultSet rs = stat.executeQuery(" select t.id,t.name from stu t where t.age=21 ");

while(rs.next()) {

System.out.println("name is "+rs.getString("name"));

out.print("name is "+rs.getString("name"));

out.print("<br>");

}

} finally {

if(conn!=null) {

conn.close();

}

}



//while(rs.)

%>