syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Fullbright (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SYNCOPE-1308) Exception getting users with orderBy on SyncopeClient API with Postgres 10.3
Date Thu, 03 May 2018 15:01:00 GMT
Paul Fullbright created SYNCOPE-1308:
----------------------------------------

             Summary: Exception getting users with orderBy on SyncopeClient API with Postgres
10.3
                 Key: SYNCOPE-1308
                 URL: https://issues.apache.org/jira/browse/SYNCOPE-1308
             Project: Syncope
          Issue Type: Bug
          Components: client
    Affects Versions: 2.0.8
         Environment: Windows Server 2012 R2 64
Java 8
Tomcat 8
Syncope 2.0.8
JDBC Driver 42.2.2
Postgres 10.3

            Reporter: Paul Fullbright


To reproduce, I used the following code:

{{    UserService service = client.getService(UserService.class); }}
{{    AnyQuery query = new AnyQuery.Builder() }}
{{        .page(1) }}
{{        .size(1) }}
{{        .orderBy("email ASC") }}
{{        .realm("/") }}
{{        .build(); }}
{{                }}
{{    return service.search(query);}}

And then I received the following exception stack:

{{org.apache.syncope.common.lib.SyncopeClientException: DataIntegrityViolation }}
{{[ERROR: UNION types integer and text cannot be matched }}
{{   Position: 158 {prepstmnt 1156037144 SELECT u.any_id,sva.stringvalue AS }}
{{email FROM (SELECT DISTINCT any_id FROM user_search WHERE id IS NOT NULL) u, }}
{{(SELECT * FROM user_search_attr UNION SELECT * FROM user_search_null_attr) }}
{{sva WHERE u.any_id=sva.any_id AND sva.schema_id='email' AND u.any_id IN }}
{{(SELECT any_id FROM user_search WHERE realm_id IN (SELECT id AS realm_id }}
{{FROM Realm WHERE id=?)) ORDER BY email ASC} [code=0, state=42804]] }}
{{    at }}
{{org.apache.syncope.common.lib.SyncopeClientException.build(SyncopeClientException.java:37) }}
{{    at }}
{{org.apache.syncope.client.lib.RestClientExceptionMapper.checkSyncopeClientCompositeException(RestClientExceptionMapper.java:143) }}
{{    at }}
{{org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:53) }}
{{    at }}
{{org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:42) }}
{{    at }}
{{org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:313) }}
{{    at }}
{{org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:876) }}
{{    at }}
{{org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:789) }}
{{    at }}
{{org.apache.cxf.jaxrs.client.ClientProxyImpl.invoke(ClientProxyImpl.java:235) }}
{{    at com.sun.proxy.$Proxy64.search(Unknown Source) }}
{{    at com.gal.ums.services.UsersService.getUsers(UsersService.java:65) }}

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message