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
毛进
