OK, I updated the jdbc driver (had to do it by writing a wget download
command rather than using apt-get) and Syncope to 2.0.8, and I'm still
getting the error.
I should note that I am ordering by a schema attribute (which works on the
Syncope REST endpoint.)
Here's the full stack trace:
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)
-----
Paul Fullbright
--
Sent from: http://syncope-user.1051894.n5.nabble.com/
