[JBoss Portal] - Re: DatabaseServerLoginModule
by georgy
Hi 'bdaw'
You are wright, i made a mistake: it should be table 'roles' instead of 'UserRoles', but it doesn't solve the problem anyway. I read portal documentation once more to make sure i didn't forget anything and in the documentation it is said that 'The JBoss Application Server documentation is certainly the best reference ' for authentication configuration, so i read a part of chapter 8.
http://docs.jboss.org/jbossas/jboss4guide/r5/html/ch8.chapter.html#ch8.da...
I tried the dabaseserverloginmodule exemple:
i created 2 tables Users and UserRoles (copy/paste of the exemple)
| CREATE TABLE Users(username VARCHAR(64) PRIMARY KEY, passwd VARCHAR(64))
| CREATE TABLE UserRoles(username VARCHAR(64), userRoles VARCHAR(32))
|
i inserted data
| insert into UserRoles values('g.mahop','Authenticated')
| insert into UserRoles values('g.mahop','Admin')
| insert into Users values('g.mahop','toto')
|
I reconfigured the jboss-portal.sar/conf/login-config.xml file:
| <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
| flag="required">
| <module-option name="dsJndiName">java:/PortalDS</module-option>
| <module-option name="principalsQuery">
| select passwd from Users username where username=?</module-option>
| <module-option name="rolesQuery">
| select userRoles, 'Roles' from UserRoles where username=?</module-option>
| </login-module>
|
|
This is what happends after i try to authenticate
http://users.telenet.be/mistageorges/portalSnapshot/afterSubmit.JPG
Obviously i am missing something but i can't find what. Do you see anything that seems not to be wright?
I use JBOSS Portal 2.6GA (bundle version) with a mysql 4.1 database
Thank for your help
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060892#4060892
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4060892
19Â years
[JBoss Seam] - Seam2.0B1: nested conversations and StaleStateException
by hstang
When using nested conversations and editting my entities, I would encounter org.hibernate.StaleStateException, and it keeps throwing these exceptions infinitely it seems. Here's my stack trace. This was working in 1.3.0a
| org.hibernate.StaleStateException: current database version number does not match passivated version number
| at org.jboss.seam.persistence.HibernatePersistenceProvider.checkVersion(HibernatePersistenceProvider.java:166)
| at org.jboss.seam.persistence.HibernatePersistenceProvider.checkVersion(HibernatePersistenceProvider.java:126)
| at org.jboss.seam.contexts.PassivatedEntity.checkVersion(PassivatedEntity.java:133)
| at org.jboss.seam.contexts.PassivatedEntity.getEntityFromEntityManager(PassivatedEntity.java:118)
| at org.jboss.seam.contexts.PassivatedEntity.toEntityReference(PassivatedEntity.java:73)
| at org.jboss.seam.contexts.EntityBean.activate(EntityBean.java:67)
| at org.jboss.seam.contexts.ServerConversationContext.unflush(ServerConversationContext.java:234)
| at org.jboss.seam.contexts.FacesLifecycle.resumeConversation(FacesLifecycle.java:129)
| at org.jboss.seam.jsf.SeamPhaseListener.afterRestoreView(SeamPhaseListener.java:373)
| at org.jboss.seam.jsf.SeamPhaseListener.afterServletPhase(SeamPhaseListener.java:211)
| at org.jboss.seam.jsf.SeamPhaseListener.afterPhase(SeamPhaseListener.java:184)
| at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:280)
| at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
| at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
| at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:87)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:63)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:127)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:277)
| at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:40)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:63)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:140)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
| at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
| at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
| at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
| at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
| at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060887#4060887
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4060887
19Â years
[JBoss jBPM] - null index column for collection: org.jbpm.context.exe.Token
by mikes124
hi all,
I have this error on my web application that i use jboss to add a work flow module api in it.This error is lunched only on oracle9i data base,on hsql and sqlserver it work. I am using tomcat 5.0.28 and jbpm3.1.4 and my test are on several database.
the exception is a hibernate exception i had got it when i used the hbm2ddl.auto property to create the data base schema.
Thank you for any help.
this is the exception:
org.hibernate.HibernateException: null index column for collection: org.jbpm.context.exe.TokenVariableMap.variableInstances
at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(AbstractCollectionPersister.java:652)
at org.hibernate.collection.PersistentMap.readFrom(PersistentMap.java:222)
at org.hibernate.loader.Loader.readCollectionElement(Loader.java:994)
at org.hibernate.loader.Loader.readCollectionElements(Loader.java:635)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:71)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1693)
at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
at org.hibernate.collection.AbstractPersistentCollection.readIndexExistence(AbstractPersistentCollection.java:125)
at org.hibernate.collection.PersistentMap.containsKey(PersistentMap.java:109)
at org.jbpm.context.exe.VariableContainer.hasVariableLocally(VariableContainer.java:119)
at org.jbpm.context.exe.VariableContainer.setVariable(VariableContainer.java:42)
at org.jbpm.context.exe.VariableContainer.setVariable(VariableContainer.java:49)
at org.jbpm.context.exe.VariableContainer$$FastClassByCGLIB$$56c4a5bb.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
at org.jbpm.taskmgmt.exe.TaskInstance$$EnhancerByCGLIB$$177bf4ef.setVariable()
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060882#4060882
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4060882
19Â years
