portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Sean Taylor" <da...@bluesunrise.com>
Subject RE: testing the User object values
Date Sat, 04 Aug 2001 15:24:40 GMT
I believe your description is accurate.
I've also noticed that CREATED and MODIFIED dont get updated.
I guess its a bug in turbine/torque.
Haven't had the time to investigate it.

> -----Original Message-----
> From: Dave Carlson [mailto:dcarlson@ontogenics.com]
> Sent: Friday, August 03, 2001 10:49 AM
> To: jetspeed-dev@jakarta.apache.org
> Subject: testing the User object values
> As a way to understand the template mechanism in Jetspeed,
> and the database
> persistence provided by Turbine, I created a simple test JSP
> template that
> others may find helpful.
> The database tables include on OBJECTDATA field, whose
> content was a mystery
> to me.  After reviewing Turbine code, I understood that any
> attribute/value
> pairs could be assigned to a User and if the attribute did
> not match an column
> name in the database table schema, then it was serialized
> into a Hashtable in
> OBJECTDATA.  But I still did not know *what* was in that blob value.
> The following simple JSP page dumps all attributes of a User
> retrieved from
> the database, regardless of whether they are from the table columns or
> deserialized from the OBJECTDATA.  (This is not recommended
> coding style for
> production JSP!!!  Just a quick hack that is easy to modify
> and test without
> recompiling a servlet and restarting tomcat.)
> Two attributes are extracted from the blob:  _access_counter
> Now, LAST_LOGIN should be in a User table column, but it's
> not.  This test
> uncovered a SQL script error in all database variations included with
> Jetspeed.  All 6 turbine-*.sql scripts include
> they should have TURBINE_USER.LAST_LOGIN.  I checked the
> turbine tdk 2.1, and
> the sql scripts contained there are correct.
> If you modify this column name in the database, then
> subsequent accesses to
> Jetspeed will correctly populate the LAST_LOGIN column, which
> can be viewed
> via a simple DB select.
> I still have not figured out why the CREATED and MODIFIED
> columns are not
> populated in the database...
> Hope this is helpful,
>   Dave Carlson
> Browser URL:
(obviously, replace your own host:port)

User persistent data

_access_counter 7
LAST_LOGIN Fri Aug 03 09:23:34 MDT 2001
EMAIL raphael@apache.org

Save this JSP to: /WEB-INF/templates/jsp/screens/html/TestAccount.jsp

<%@ taglib uri='/WEB-INF/templates/jsp/tld/template.tld' prefix='jetspeed'

<%@ page import = "org.apache.turbine.util.RunData" %>
<%@ page import = "org.apache.turbine.om.security.User" %>

<div align="left">
  <h2>User persistent data</h2>

  <table cellpadding="2" cellspacing="0" border="1">

    User user = ((RunData)request.getAttribute("rundata")).getUser();
    java.util.Hashtable attrs = user.getPermStorage();
    java.util.Enumeration enum = attrs.keys();
    while( enum.hasMoreElements() ) {
        String name = enum.nextElement().toString();
        Object value = attrs.get(name);



To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org

To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org

View raw message