[jboss-user] [Datasource Configuration] New message: "Re: How to configure Oracle with my application in jboss 5.0"

[Anand Kumar]

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/526690#526690

Author  : Anand Kumar
Profile : http://community.jboss.org/people/akstifr

Message:
--------------------------------------------------------------
Thank you once again for your reply 
 
Even after changing the entries in the application policy in the file login-config.xml, *still i am unable to connect to the database * and
 
contents of that file after changing are:
 
<application-policy name="datanet">
    <authentication>
      <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
        flag="required">
          <module-option name = "dsJndiName">java:/OracleDS</module-option>
          <module-option name = "principalsQuery">SELECT PASSWD FROM WB_LOGIN WHERE USERNAME=?</module-option>
        <module-option name = "rolesQuery">SELECT ROLE_NAME, 'Roles' FROM USER_ROLES WHERE USERNAME=?</module-option>
      </login-module>
    </authentication>
  </application-policy>

 
It is give the same old error as i stated previously:
 
10:10:54,234 INFO  [STDOUT] java.lang.RuntimeException: Unable to aquire data source
10:10:54,234 INFO  [STDOUT] Setting details for the user is::nihita
10:10:54,234 INFO  [STDOUT] null
10:10:54,234 INFO  [STDOUT] null
 
Now still what i have to do to connect it and run the application??

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/526690#526690