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
> and LAST_LOGIN.
> 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
> TURBINE_USER.LASTLOGIN, where
> 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:
http://192.168.1.5/jetspeed/portal/template/TestAccount.jsp
(obviously, replace your own host:port)

Results:
--------------------------------
User persistent data

LOGIN_NAME admin
PASSWORD_VALUE jetspeed
_access_counter 7
FIRST_NAME Raphael
LAST_LOGIN Fri Aug 03 09:23:34 MDT 2001
CONFIRM_VALUE CONFIRMED
LAST_NAME Admin
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);

        %>
            <tr>
              <td><%=name%></td><td><%=value%></td>
            </tr>
        <%
    }
%>

  </table>
</div>
--------------------------------


---------------------------------------------------------------------
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