[jboss-user] [Datasource Configuration] New message: "Re: How to configure Oracle with my application in jboss 5.0"
Anand Kumar
do-not-reply at jboss.com
Tue Feb 16 04:24:15 EST 2010
User development,
A new message was posted in the thread "How to configure Oracle with my application in jboss 5.0":
http://community.jboss.org/message/526505#526505
Author : Anand Kumar
Profile : http://community.jboss.org/people/akstifr
Message:
--------------------------------------------------------------
Thank you once again for your reply
I am using WAR file. The contents of jboss-web.xml is
<?xml version="1.0" encoding="ISO-8859-1"?>
<jboss-web>
<security-domain>java:/jaas/datanet</security-domain>
</jboss-web>
and the contents of web.xml is:
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
version="2.5">
<security-constraint>
<display-name>Security Constraint</display-name>
<web-resource-collection>
<web-resource-name>Datanet Protected Area</web-resource-name>
<url-pattern>/personal/*</url-pattern>
.......
.......
.......
.......
<url-pattern>/index.jsp</url-pattern>
<http-method>GET</http-method>
<http-method>POST</http-method>
</web-resource-collection>
<auth-constraint>
<role-name>member</role-name>
<role-name>admin</role-name>
<role-name>nsfmember</role-name>
</auth-constraint>
<user-data-constraint><transport-guarantee>NONE</transport-guarantee></user-data-constraint>
</security-constraint>
<login-config>
<auth-method>FORM</auth-method>
<realm-name>datanet</realm-name>
<form-login-config>
<form-login-page>/login.jsp</form-login-page>
<form-error-page>/error.jsp</form-error-page>
</form-login-config>
</login-config>
<security-role>
<role-name>member</role-name>
</security-role>
...............
.............
.............
.............
.............
.............
<security-role>
<role-name>nsfmember</role-name>
</security-role>
There are some more security-constraint also.
In the login-config.xml which is present in /default/config, add the following application policy
<application-policy name="datanet">
<authentication>
<login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
flag="required">
<module-option name="connectionURL">jdbc:oracle:thin:@158.144.71.242:1521:dbatest</module-option>
............
..........
..........
<module-option name="userTable">wb_login</module-option>
<module-option name="userNameCol">username</module-option>
<module-option name="userRoleTable">user_roles</module-option>
<module-option name="roleNameCol">role_name</module-option>
</login-module>
</authentication>
</application-policy>
but still unable to connect it.....
Now what i have to do ????
--------------------------------------------------------------
To reply to this message visit the message page: http://community.jboss.org/message/526505#526505
More information about the jboss-user
mailing list