On 27/04/2018 18:09, PeeDub wrote:
It doesn't look like my "raw" text is being posted. This is the code:
UserService service = client.getService(UserService.class);
AnyQuery query = new AnyQuery.Builder()
.page(page)
.size(pageSize)
.orderBy(orderBy)
.realm("/")
.build();
return service.search(query);
And this is the exception:
org.apache.syncope.common.lib.SyncopeClientException: DataIntegrityViolation
[ERROR: UNION types integer and text cannot be matched
Position: 158 {prepstmnt 58276975 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]]
Hi,
I could not replicate your problem.
Are you using PostgreSQL? I tried with latest PostgreSQL 9.6 + latest
JDBC driver (42.2.2 at the moment) and all went fine.
Regards.
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
