how to insert one more field in jboss database..

[purna_cherukuri]

Hi,

I am using JBoss-portal-2.4.0. As per my requirements, we are supposed to have one more field in jbp_user_prop table. And i want to update that field along with last last visit date. what code i have to modify. I tried to understand but it may take some time... So can anyone help me out in this... As this is a high priority requirement for me...

Thanks in advance...

[bdaw]

You can easily place any property value for a user there. Just use User.getProfile() which gives you the Map object that is mapped by hibernate to this table.

user.getProfile().get(User.INFO_USER_SIGNATURE)
user.getProfile().put(User.INFO_USER_TIME_ZONE_OFFSET, timezoneoffset.toString())

just use your own key value. Look at UserPortlet class for examples of use.

[bdaw]

for last visit date use User.INFO_USER_LAST_LOGIN_DATE key value

[purna_cherukuri]

Thanks for quick reply...

Actually my requirement is,

When any user logs in, i have to set a flag like LoggedIn to true, And when the user logs out or on session invalidation, I have to set back that flag to false. This is to avoid the user to create 2 sessions at the same time...

For Session invalidation case, we are supposed to implement HttpSessionListener, and we have update that flag to false...

Can you suggest me the detailed solution for this...

Thank you...

[bdaw]

You can look at:

org.jboss.portal.core.aspects.server.UserInterceptor
and org.jboss.portal.core.aspects.server.UserInterceptor.UserFinalizer
That's where last login date is actually set.

The user authentication process occurs in org.jboss.portal.identity.auth.IdentityLoginModule

[purna_cherukuri]

Thank you very much...
I will look it and update u after i suceed...