[gatein-issues] [JBoss JIRA] (GTNPORTAL-3014) OrganizationService.getUserHandler().findUsersByGroupId(groupid) not working with H2 database

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/GTNPORTAL-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12799443#comment-12799443 ] 

RH Bugzilla Integration commented on GTNPORTAL-3014:
----------------------------------------------------

Dominik Pospisil <dpospisi at redhat.com> made a comment on [bug 915766|https://bugzilla.redhat.com/show_bug.cgi?id=915766]

Verified (ER4).
                
> OrganizationService.getUserHandler().findUsersByGroupId(groupid) not working with H2 database
> ---------------------------------------------------------------------------------------------
>
>                 Key: GTNPORTAL-3014
>                 URL: https://issues.jboss.org/browse/GTNPORTAL-3014
>             Project: GateIn Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Identity integration
>    Affects Versions: 3.6.0.Beta01
>            Reporter: Marek Posolda
>            Assignee: Marek Posolda
>             Fix For: 3.6.0.Beta02
>
>
> Description of problem:
> Using default setup with H2 database, calling  OrganizationService.getUserHandler().findUsersByGroupId(groupid) raises an exception.
> Executing the following code:
> 30    users = organizationService.getUserHandler().findUsersByGroupId("/platform/users");
> 31
> 32    if (users.getSize() > 0)
> 33    {
> results in the following exception:
> 11:01:30,352 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/127.0.0.1:8080-2) SQL Error: 90068, SQLState: 90068
> 11:01:30,352 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/127.0.0.1:8080-2) Order by expression "HIBERNATEI2_.NAME" must be in the result list in this case; SQL statement:
> select distinct hibernatei1_.ID as ID4_, hibernatei1_.IDENTITY_TYPE as IDENTITY2_4_, hibernatei1_.NAME as NAME4_, hibernatei1_.REALM as REALM4_ from jbid_io_rel hibernatei0_ inner join jbid_io hibernatei1_ on hibernatei0_.TO_IDENTITY=hibernatei1_.ID cross join jbid_io hibernatei2_ cross join jbid_io hibernatei3_ where hibernatei0_.TO_IDENTITY=hibernatei2_.ID and hibernatei0_.FROM_IDENTITY=hibernatei3_.ID and hibernatei2_.REALM=? and hibernatei3_.REALM=? and (hibernatei2_.NAME like ?) and hibernatei0_.FROM_IDENTITY=? order by hibernatei2_.NAME asc [90068-168]
> 11:01:30,355 ERROR [stderr] (http-/127.0.0.1:8080-2) org.picketlink.idm.api.query.QueryException: Failed to execute query
> 11:01:30,356 ERROR [stderr] (http-/127.0.0.1:8080-2)         at org.picketlink.idm.impl.api.query.UserQueryExecutorImpl.execute(UserQueryExecutorImpl.java:220)
> 11:01:30,356 ERROR [stderr] (http-/127.0.0.1:8080-2)         at org.picketlink.idm.impl.api.query.UserQueryExecutorImpl.list(UserQueryExecutorImpl.java:245)
> 11:01:30,356 ERROR [stderr] (http-/127.0.0.1:8080-2)         at org.picketlink.idm.impl.api.session.IdentitySessionImpl.list(IdentitySessionImpl.java:364)
> 11:01:30,356 ERROR [stderr] (http-/127.0.0.1:8080-2)         at org.exoplatform.services.organization.idm.IDMUserListAccess.getSize(IDMUserListAccess.java:123)
> 11:01:30,356 ERROR [stderr] (http-/127.0.0.1:8080-2)         at org.exoplatform.demo.portlet.portletOrganization.doView(portletOrganization.java:32)
> The same issue does not show up with other databases, such as MySQL.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira