Mailing-List: contact jetspeed-dev-help@portals.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jetspeed Developers List" <jetspeed-dev@portals.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=zgYmaL4KQ6RpwYAYTfDE5MrnjvIEJwwdr8a3ptxAUuBRreu0k7aFypo5nCIbHmSyvYjfqPd81ATLWuJQGgIjf9L4SK032cVTdNWoUZGmR3hPV61fep+IGAClzRfaF8+0h85VDytaE2w/L8XTYbL6uJswjBgpA6u76MPW9P3uB88=;
Message-ID: <252069.92269.qm@web51106.mail.re2.yahoo.com>
References: <4B4D0848.5090801@wemove.com>
Date: Fri, 15 Jan 2010 07:01:03 -0800 (PST)
From: Woonsan Ko <woon_san@yahoo.com>
Subject: Re: New User/Group/Role Management Portlet
To: Jetspeed Developers List <jetspeed-dev@portals.apache.org>
In-Reply-To: <4B4D0848.5090801@wemove.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Joachim,=0A=0APlease see my comments below.=0A=0A=0A=0A----- Original Me=
ssage ----=0A> From: Joachim M=FCller <joachim@wemove.com>=0A> To: Jetspeed=
 Developers List <jetspeed-dev@portals.apache.org>=0A> Sent: Wed, January 1=
3, 2010 12:39:52 AM=0A> Subject: New User/Group/Role Management Portlet=0A>=
 =0A> Hi,=0A> =0A> I want to create new User/Group/Role Management portlets=
 that are easier=0A> to use/understand. The main requirements are:=0A> =0A>=
 - easy to understand UI=0A> - simple but powerful query interface=0A> - pa=
ging for the principal results list=0A> - be able to work with 10.000+ user=
s in terms of memory/performance=0A> =0A> To accomplish the requirements I =
would like to introduce a=0A> JetspeedPrincipalLookupManager with the metho=
d:=0A> =0A> JetspeedPrincipalResultList getPrincipals(JetspeedPrincipalQuer=
yContext=0A> queryContext);=0A> =0A> The JetspeedPrincipalQueryContext hold=
s all possible query parameters=0A> (principal name, attributes, asscoiated=
Roles, asscoiatedGroups,=0A> asscoiatedUsers, sort order, paging parameters=
, etc.).=0A> =0A> The JetspeedPrincipalResultList encapsulates the actual l=
ist of detached=0A> JetspeedPrincipals and the total number of results.=0A>=
 =0A> The JetspeedPrincipalLookupManager will be implemented using plain JD=
BC=0A> because paging the result set is not/poorly supported by OJB. Databa=
se=0A> specific LookupManager implementations can be plugged in via Spring =
and=0A> can handle database supported paging (like MySqls LIMIT) but there =
is a=0A> default implementation that uses plain JDBC for paging the result =
set.=0A> The DB platform is derived from OJB, there is no extra config para=
meter=0A> to take care of.=0A=0AI tried to search any framework level suppo=
rt for the DBMS-side pagination queries.=0AOJB seems now ready to support t=
hat feature since 1.0.5. It has been added with this issue: http://issues.a=
pache.org/jira/browse/OJB-131=0AAlso, I had a look at some source codes suc=
h as PlatformOracleImpl [1], PlatformMySQLImpl and PlatformPostgreSQLImpl (=
in the package, org.apache.ojb.broker.platforms). Each one seems to use its=
 own platform specific ones: rownum/rnum for oracle, LIMIT for MySQL, etc.=
=0AYou could have a look at those in addLimitSql() method and addPagingSql(=
) method in each class.=0AI think we can ask OJB team to make a release of =
1.0.5 and we'd better use new OJB or any other framework having same featur=
es.=0A=0A[1] https://svn.eu.apache.org/repos/asf/db/ojb/branches/OJB_1_0_RE=
LEASE/src/java/org/apache/ojb/broker/platforms/PlatformOracleImpl.java=0A=
=0AKind regards,=0A=0AWoonsan=0A=0A> =0A> I am planing to plug the Jetspeed=
PrincipalLookupManager into the=0A> JetspeedSecurityPersistenceManager via =
Spring.=0A> =0A> Any comments on that plan? Anything I have to be aware of?=
=0A> =0A> Thanks for any comment,=0A> Joachim=0A> =0A> =0A> ---------------=
------------------------------------------------------=0A> To unsubscribe, =
e-mail: jetspeed-dev-unsubscribe@portals.apache.org=0A> For additional comm=
ands, e-mail: jetspeed-dev-help@portals.apache.org=0A=0A=0A=0A      

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