Re: [xwiki-devs] [gsoc] Re: Problems creating a query using the QueryManager

Sorry for the late answer but I had problems with my installation after the SVN update. Now I don't get any exception anymore - but also no result. I tried both, creating a named query by adding the following code to queries.hbm.xml and creating the query directly. <query name="getUserDocByOpenIdIdentifier"> select doc.fullName from XWikiDocument as doc, BaseObject as obj, StringProperty as prop where doc.fullName=obj.name and obj.className='XWiki.OpenIdIdentifier' and obj.id=prop.id.id and prop.id.name='identifier' and prop.value=:identifier </query> This sets the statement member in the returned query qm.getNamedQuery("getUserDocByOpenIdIdentifier") to "getUserDocByOpenIdIdentifier". Is that right!? I tried also to create the query directly (also including "select doc.fullName"): Query search_user2 = qm.getNamedQuery("getUserDocByOpenIdIdentifier"); search_user2 = qm.createQuery("from XWikiDocument as doc, BaseObject as obj, StringProperty as prop where doc.fullName = obj.name and obj.className = 'XWiki.OpenIdIdentifier' and obj.id=prop.id.id and prop.id.name='identifier' and prop.value = :identifier", Query.HQL); search_user2.bindValue("identifier", openid_identifier); List<XWikiDocument> found_users2 = search_user2.setLimit(1).execute(); if (found_users2.size() > 0) { return found_users2.get(0).getFullName(); } Both queries returned empty lists. I checked the DB with the MySQL Query Browser and saw that there are the right entries in xwikistrings, xwikiobjects and xwikidoc so they are saved in the right way. Are the table names converted automatically? There is no table XWikiDocument in my DB but just xwikidoc for instance.

...