Jackrabbit DLFile content extraction

[kamal ramesh, modifié il y a 14 années.]

Hi,
I am working on a search application and we need to extract the (liferay) data directly from the database and index it.

I also need to index the contents of the file uploaded via the Document Library. I have configured jackrabbit to store the document library file in the database.

However i dont find any links between the DL tables and the newly created Jackrabbit tables

The DL File related data are in DLFileEntry and DLFolder etc tables.

And the newly created table J_PM_Liferay_BINVal has the uploaded filecontent.

But the BINVAL_ID in the J_PM_Liferay_BINVAL is not referenced in any of the tables. So i am NOT able to associate the file content to a file entry.

I don't see an exposed/soap service in liferay to retreive the file contents either.

Except the DL File contents i am successfull in gathering the rest of the data from the liferay db.

Has anybody worked on extracting the uploaded-file contents from jackrabbit or from the db?

Any advice or suggestion will be helpful.

Thanks
Kamal