How to retrieve a hierarchy from a repositorty

[singhl1]

I have the following scenario:

A modshape 3.2.0 Final repository, with a single workspace, called myWorkspace. Running in tomcat 6 with spring 3.1 and Java 6

The workspace will be use to soley store files (word docs, excel, images etc.... so oly folders and binary content) under a folder structure (that the user can define), so file(s) can be under a tree of folders, I have implemented the creation fo folders and files as per https://docs.jboss.org/author/display/MODE/Storing+files+and+folders.

So what I now need to do is to represent this in a pictorial form in my application, so I need to retrieve the directory structure and any jcr:content in those folders in a tree structure (similar to a file explorer window in windows) from the root folder

eg

FIRST FOLDER

     SECOND FOLDER

          file1.doc

          file2.xls

          THIRD FOLDER

               image1.jpeg

FORTH FOLDER

     file3.xls

Also ordering of the data will be important, so either by date or by name (aplhabetic).

Need to do this in a java class, by interogating repository, I cannot work out the most efficient way to get the data? Do i get the root node and then find nodes under that, or by SQL or any other method?

The workspace will only contain folders and files, nothing else.

Any help appreciated.

[hchiorean]

Hi,

Since you're basically interested in all the content of the repository, querying would not be optimal. That is because queries need to be parsed, optimized, ran against the indexes and then data loaded into memory.

IMO the easiest and most performant way is to use the standard JCR API, starting from the root of the workspace and go through each file/folder (similar to the way you would read a file hierarchy via java.util.File). Ordering is something which you can easily implement using ordered java.util collections.

We already have a utility class, which walks a node hierarchy and prints out results, so you can see pretty much what the code looks like: https://github.com/ModeShape/modeshape/blob/master/modeshape-jcr-api/src/main/java/org/modeshape/jcr/api/JcrTools.java#L527

[singhl1]

Thanks for the quick reply, and clear answer, will try that now.