1 Reply Latest reply on Mar 29, 2010 3:10 PM by Robert Sullivan

    JBoss 5.0.0.GA datasource security-domain and login-config.xml

    Joshua Caito Newbie

      Running into an issue where our datasources for two different DBMS (MS-SQLServer and Informix) are not picking up the security-domain configuration in the login-config.xml file.


      Our datasource looks like this:


               <type-mapping>MS SQLSERVER2000</type-mapping>


      And an entry in login-config.xml:



        <application-policy name="MSSQLDS">
            <login-module code="org.jboss.resource.security.SecureIdentityLoginModule" flag="required">
              <module-option name="userName">uismca1w</module-option>
              <module-option name="password">55de9efb3f6068b88187c12a3970df95</module-option>
              <module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=cvars</module-option>


      and I keep receiving this error:


      13:25:23,053 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.)


      Now if, we comment out the security-domain element in the *-ds.xml file and replace it with a simple user name and a clear text password the datasource works. We're using the 'all' server configuration in JBoss. We've made sure that login-config.xml is getting loaded on start-up. And the hqsqldb-ds.xml using the security-domain element works. But using our added application-policy to the login-config.xml, it seems that the datasource does not get the values when establishing a new connection.


      Anyone have any ideas?