Aggregating Search Scores

Hi all, I was wondering if it is possible to aggregate the scores for joined columns in an SQL-2 query. We want to order the nodes found according to scores produced by matches on joined descendant nodes. For example, let's assume we have some file nodes that have a property called tags. We want

Re: Jackrabbit-jca JNDI for testing

Hi Thank you so much for your reply. I've just checked the testing techs from the link you sent, but I don't know what are the required information or parameters for jackrabbit-jca! I am quite new to all of that. Please if you know how to do it, would you send me the java code? I'm afraid I

Session.copy

Hi All Out of curiosity, where is there no Session.copy method in JCR specification? There's a Workspace.move and a Session.move but only a Workspace.copy. Cheers, Philipp

Re: BindVariables in SQL-2 Contains

sorry about the delay and thanks for the patch. it looks good to me. though, could you please attach an updated version with the correct license header for the new test class? thanks. Oops.. I blame my IDE settings... :-) I've now updated the header with the Apache License. Thanks, Philipp

mix:etag

Hi Is mix:etag implemented in 2.0.0? JCR-2116 suggests it should be, but I always receive an empty string () as the etag. Thanks and kind regards, Philipp

Re: mix:etag

no, it's not implemented - i.e. it's not auto computed by the repository, yet. Ah, okay. Thanks for the quick reply! Philipp.

BindVariables in SQL-2 Contains

Hi! It seems that BindVariables still can not be used within SQL-2 Contains expressions in Jackrabbit 2.0.0: https://issues.apache.org/jira/browse/JCR-2417 I know you probably have plenty of work on your hands, but is this scheduled to be fixed any time? Thanks for all your hard work, I really

Re: Fulltext indexing of binary property

Hi Alex Thanks for your reply. Binary properties are indexed with the help of full text extractors. The recent Jackrabbit versions use Apache Tika for that. You can provide your custom extractors. Does that mean Jackrabbit can text extract binary properties on arbitrary nodes? How do you

Fulltext indexing of binary property

Hi, we have a custom node that is not extending nt:resource it looks like this (originally there is also a subnode and other inherited types): [doc:dokument] nt:base, mix:mimeType - filename (string) - original (binary) primary According to the Spec (3.7.11.10 mix:mimeType) this should

Re: JCR-SQL2 subtree query

Hi Wes I have a bit of a dilemma. I'm working with Jackrabbit 2.0b3 and trying to migrate to JCR2.0. However, since the XPATH query syntax is deprecated, I'm investigating how to go about writing queries in JCR-SQL2. Unfortunately, I haven't come up with many examples or tutorials for the

Re: Jackrabbit support (paid or otherwise)

Hi Samuel We're creating a decent-sized dependency on a functioning JSR-170 implementation (Jackrabbit).  As such, we're curious about the level of support we can get. I'm unaware of anything outside of what is published from the Jackrabbit site (this mailing list).  Does anyone else know

State of JCR-SQL2

Hi all I'm curious on the state of the JCR-SQL2 implementation in Jackrabbit, if it is complete and whether it will undergo further testing until a Jackrabbit 2.0 final is released (and a CRX 2.0 for that matter). It seems to me, that not many people are currently using the new syntax as I find a

Re: State of JCR-SQL2

Hi Thomas! Thanks for the quick reply! state of the JCR-SQL2 implementation in Jackrabbit Some features that are available in XPath are not yet available when using SQL-2. I don't know exactly what those feature are however. And testing of QOM/SQL2 before a Jackrabbit 2.0 final release? It

Re: Strategy to register new node types.

Hi All It would be cool if we could specify a list of CNDs in the repository.xml configuration file. Then Jackrabbit could ensure that the specified node types are registered on startup of the repository. Just my 2 cents... Cheers, Philipp

Re: Strategy to register new node types.

Without any configuration, jackrabbit 2.0 will load the nodetypes defination from following file by default: ${repo_home}repository/nodetypes/custom_nodetypes.xml Ah cool! I did not know that! Thanks Guo!

BindVariable in JCR-SQL2 CONTAINS

Hi I'm trying to use the following FullTextSearch query in Jackrabbit 2.0 beta1: Query query = qm.createQuery(SELECT * FROM [my:document] AS document WHERE CONTAINS(document.original, $x), Query.JCR_SQL2); But the following fails with a java.lang.IllegalArgumentException: not a valid variable in

Re: BindVariable in JCR-SQL2 CONTAINS

Hi Thomas! I'm not sure, but it looks like a bug in Jackrabbit. The statement seems to be parsed correctly, but extracting the bind variables doesn't pick it up. Could you file a Jira bug report please? Just copy paste the example code below, that's enough to reproduce the issue. Thanks for

PropertyValue constraint fails with implicit selectorName using SQL2

Hi All I'm not sure if this is a bug or if I'm not reading the spec right. The following query works: SELECT * FROM [my:thing] AS thing WHERE thing.[my:property] = 'abc' the following doesn't: SELECT * FROM [my:thing] AS thing WHERE [my:property] = 'abc' (the AS thing is unecessary here, I

Missing JCR_ETAG constant in JCR 2.0

Hi All Sorry for misusing this list, but I just noticed that the current pre-release of the JCR 2.0 API lacks the constants for the etag mixin and type. Concretely these should be: javax.jcr.nodetype.NodeType#MIX_ETAG = {http://www.jcp.org/mix/1.0}etag; javax.jcr.nodetype.Property#JCR_ETAG =

Re: Missing JCR_ETAG constant in JCR 2.0

javax.jcr.nodetype.Property#JCR_ETAG = {http://www.jcp.org/jcr/1.0}etag; Copy-paste error... that should be: javax.jcr.Property#JCR_ETAG = {http://www.jcp.org/jcr/1.0}etag;

Re: Missing JCR_ETAG constant in JCR 2.0

Hi Jukka The missing constants were noticed too late and will unfortunately not be included in JCR 2.0. Ah, okay. That's to bad. Thanks for your quick reply! Philipp.

Re: bug in Item.getPath?

Hi Rodrigo, see 4.3.1 Index Notation (JCR 1.0 Spec): quote However, as opposed to the semantics of XPath, a name in a content repository path that does not explicitly specify an index implies an index of 1. For example, /a/b/c is equivalent to /a[1]/b[1]/c[1]. /quote Also take a look at