29 Jul
2008
29 Jul
'08
6:39 p.m.
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.
----- Original Message -----
From: "Artem Melentyev" <amelentev(a)gmail.com>
To: "XWiki Developers" <devs(a)xwiki.org>
Sent: Monday, July 28, 2008 3:47 PM
Subject: [gsoc] Re: [xwiki-devs] Problems creating a query using the
QueryManager
Hi, Markus.
Markus Lanthaler wrote:
...
if (qm.hasLanguage(Query.HQL)) {
search_user =
qm.createQuery(", 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);
query statement should be full HQL statement (not such as in
store#search* methods), so it should be
"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);"
} else if (qm.hasLanguage(Query.XPATH))
{
search_user =
qm.createQuery("/*/*[obj/XWiki/OpenIdIdentifier/@xp:identifier =
':identifier'] ", Query.XPATH);
} else
throw new RuntimeException();
Query.XPATH parameters should be with braces: ":{identifier}".
(It is difficult to use ":identifier" because of ambiguous with xml
namespaces (ex: "xwiki:document", "xp:property") in XPath language.
There is no xpath parameters in JCR v1 standard, so I implement it by
self.)
search_user.bindValue("identifier", openid_identifier);
List<XWikiDocument> found_users =
search_user.setLimit(1).execute();
if (found_users.size() > 0) {
if (log.isDebugEnabled()) {
log.debug("OpenID " + openid_identifier + " already
registered.");
}
return found_users.get(0).getFullName();
}
return null;
}
I recommend you to use named queries. See
http://xwiki.markmail.org/message/tui6w6d5d27tirda
You need to move hql statements to queries.hbm.xml, xpath statements to
JcrQueries.properties, and use queryManager.getNamedQuery(qname).
Don't worry about XPath queries, I'll add them by self after JcrStore
will work fine. So you can write only hql queries.
but all I get is a NullPointerException when
qm.createQuery(...,
Query.HQL)
is called. What's wrong with my code?
This should work after Vincent fix.
--
Artem Melentyev
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs