Please help
ukamath Aug 5, 2002 11:36 PMI 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