0 Replies Latest reply on Aug 5, 2002 11:36 PM by Uday Kamath

    Please help

    Uday Kamath Newbie

      I am using Jboss2.2.2 and on the server side using DatabaseLognModule. I have my auth.conf as
      //database based login
      OMSRS {
      /* A JDBC based LoginModule
      LoginModule options:
      dsJndiName: The name of the DataSource of the database containing the Principals, Roles tables
      principalsQuery: The prepared statement query equivalent to:
      "select Password from Principals where PrincipalID=?"
      rolesQuery: The prepared statement query equivalent to:
      "select Role, RoleGroup from Roles where PrincipalID=?"
      */
      org.jboss.security.auth.spi.DatabaseServerLoginModule required
      dsJndiName="java:/SQLServerPool"
      principalsQuery="select Password from Principals where PrincipalID=?"
      rolesQuery="select Role, RoleGroup from Roles where PrincipalID=?"
      ;
      };

      I have a session bean "ASecurityService" used just to verify the principals
      having a single method
      public void login() throws RemoteException;

      in the jboss.xml of this i have specified

      true
      <!-- All bean containers use this security manager by default -->
      <security-domain>java:/jaas/OMSRS</security-domain>

      <enterprise-beans>

      <ejb-name>ASecurityService</ejb-name>
      <jndi-name>AecurityService</jndi-name>

      </enterprise-beans>


      My client side has ClientLgoinModule and i see it usess the callback properly to get the username and passord, but still on the server side i get this error
      [ASecurityService] java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][S
      QLServer]The text, ntext, and image data types cannot be compared or sorted, exc
      ept when using IS NULL or LIKE operator.
      [OMSSecurityService] at com.microsoft.jdbc.base.BaseExceptions.createExceptio
      n(Unknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.base.BaseExceptions.getException(U
      nknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processEr
      rorToken(Unknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processRe
      plyToken(Unknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.proces
      sReplyToken(Unknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processRe
      ply(Unknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.ope
      nCursor(Unknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.e
      xecute(Unknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.base.BaseStatement.commonExecute(U
      nknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.base.BaseStatement.executeQueryInt
      ernal(Unknown Source)
      [OMSSecurityService] at com.microsoft.jdbc.base.BasePreparedStatement.execute
      Query(Unknown Source)
      [OMSSecurityService] at org.opentools.minerva.jdbc.PreparedStatementInPool.ex
      ecuteQuery(PreparedStatementInPool.java:71)
      [OMSSecurityService] at org.jboss.security.auth.spi.DatabaseServerLoginModule
      .getUsersPassword(DatabaseServerLoginModule.java:94)
      [OMSSecurityService] at org.jboss.security.auth.spi.UsernamePasswordLoginModu
      le.login(UsernamePasswordLoginModule.java:82)
      [OMSSecurityService] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M
      ethod)
      [OMSSecurityService] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S
      ource)
      [OMSSecurityService] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno
      wn Source)
      [OMSSecurityService] at java.lang.reflect.Method.invoke(Unknown Source)
      [OMSSecurityService] at javax.security.auth.login.LoginContext.invoke(Unknown
      Source)
      [OMSSecurityService] at javax.security.auth.login.LoginContext.access$000(Unk
      nown Source)
      [OMSSecurityService] at javax.security.auth.login.LoginContext$4.run(Unknown
      Source)
      [OMSSecurityService] at java.security.AccessController.doPrivileged(Native Me
      thod)
      [OMSSecurityService] at javax.security.auth.login.LoginContext.invokeModule(U
      nknown Source)
      [OMSSecurityService] at javax.security.auth.login.LoginContext.login(Unknown
      Source)
      [OMSSecurityService] at org.jboss.security.plugins.JaasSecurityManager.defaul
      tLogin(JaasSecurityManager.java:333)
      [OMSSecurityService] at org.jboss.security.plugins.JaasSecurityManager.authen
      ticate(JaasSecurityManager.java:301)
      [OMSSecurityService] at org.jboss.security.plugins.JaasSecurityManager.isVali
      d(JaasSecurityManager.java:193)
      [OMSSecurityService] at org.jboss.ejb.plugins.SecurityInterceptor.checkSecuri
      tyAssociation(SecurityInterceptor.java:209)
      [OMSSecurityService] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(
      SecurityInterceptor.java:144)
      [OMSSecurityService] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogIn
      terceptor.java:106)
      [OMSSecurityService] at org.jboss.ejb.StatelessSessionContainer.invokeHome(St
      atelessSessionContainer.java:253)
      [OMSSecurityService] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoke
      r.invokeHome(JRMPContainerInvoker.java:369)
      [OMSSecurityService] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M
      ethod)
      [OMSSecurityService] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S
      ource)
      [OMSSecurityService] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno
      wn Source)
      [OMSSecurityService] at java.lang.reflect.Method.invoke(Unknown Source)
      [OMSSecurityService] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Sour
      ce)
      [OMSSecurityService] at sun.rmi.transport.Transport$1.run(Unknown Source)
      [OMSSecurityService] at java.security.AccessController.doPrivileged(Native Me
      thod)
      [OMSSecurityService] at sun.rmi.transport.Transport.serviceCall(Unknown Sourc
      e)
      [OMSSecurityService] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unk
      nown Source)
      [OMSSecurityService] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.
      run(Unknown Source)
      [OMSSecurityService] at java.lang.Thread.run(Unknown Source)
      [OMSSecurityService] LoginException: java.sql.SQLException: [Microsoft][SQLServe
      r JDBC Driver][SQLServer]The text, ntext, and image data types cannot be compare
      d or sorted, except when using IS NULL or LIKE operator.
      [OMSSecurityService] Authentication exception, principal=David