jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "毛进" <danv...@163.com>
Subject How to add the same node to many path?
Date Fri, 12 Aug 2011 10:31:49 GMT

Hello everyone:
Question One:
 i have a need: add one picture node to many categories. The category system is stored within
Jackrabbit. And i want to add one picuture node to more than one categories so that this picture
node is distinct in the whole repository.   It is different from many picture nodes with the
same metadata. Because, in this case, if i modify one picture node , others are not modified,
which is not i want.
    cata--->Pnode
    catb--->Pnode
 and the Pnode is unique node, not two.

Question Two:
Now, i use the reference to add a ref node under different categories, which can implement
this requirement. However, i need to implement full-text search with category. So, my solution
now is USE SQL-2 to join the ref node and the unique node. BUT, it cost too much time to feedback
the results.
eg:
SELECT * FROM [resref] as ref left outer join  [nt:unstructured] as res on ref.resRef=res.[jcr:uuid]
where  ....


Can anyone give me some suggestion?



2011-08-12 



毛进 
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message