Blob Based Content Store implemented

[andre]

Hi,

I've just uploaded my imlementation of a database based content store: http://issues.alfresco.com/secure/attachment/10461/DB_Content_Store.zip

All content is streamed - so handling large files is no problem.

streaming content into and out of the db is done by the class BlobFileDAOImpl (JdbcDaoSupport) using springs AbstractLobCreatingPreparedStatementCallback and AbstractLobStreamingResultSetExtractor.

In order to get an OutputStream fromthe DAO connected to an InputStream returned by the ContentReader I use a pair of PipedStreams.
(see BlobFileContentReader.java->getDirectReadableChannel())

For uploading new Content the data is written to a TempFile first to determine the file size. (Maybe this is not necessary???)

BlobFile.hbm.xml, BlobFile.java and BlobFileImpl.java
are only used in order to get the new table created automatically.

Everything works allmost fine (tested with Oracle 10g XE - thin driver) there is only one problem:

In the the web client th file size is always displayed as 0 KB allthought my implementation of getSize provides the correct value.

I would much appreciate your feedback!

[derek]

Hi,
You can't change the content store for an existing implementation; all the content that was stored on the filesystem needs to be available to Alfresco, still.  Either start with a new system, or use the org.alfresco.repo.content.replication.ReplicatingContentStore with your blob store as the primary store, the old file content store as a secondary store, and only replicate inbound.  If you want to ditch your file store but need to pull in all the content into the blob store, use the org.alfresco.repo.content.replication.ContentStoreReplicator by activating the quartz job org.alfresco.repo.content.replication.ContentStoreReplicator$ContentStoreReplicatorJob.
Regards

[norgan]

Hi Andre,
would you mind elaborating on your arguments pro/con for choosing that approach, the options and what groew out of it in terms of implementation & experience ?  Or do/did you blog this somewhere ?

Norgan

[lamba]

Hi Andre, Hi everyone,

Iam so interested on your project Andre and I want trying it but I can't found the project neither on http://issues.alfresco.com/jira/secure/attachment/10461/DB_Content_Store.zip nor on http://forge.alfresco.com/

Thanks in advance.

[lamba]

Hi everyone,

Please if someone had the project, please share with me. I need it so urgent.

thanks.

[inocka]

Hi everyone,
I also need to have all document in DB (Oracle) because we need creating backup copies of all information (document and its metadata) and we won't have space for saving documents in file system.
I'm using last enterprise version of alfresco (trial at the moment). May be you could give me any configuration suggestions?

Thanks in advance

[krdian]

Hi,

Where i can find this project ? whether that project is still alive ?

Cheers,

Konrad

[bannu]

Hi,
This is really wonderful and much needed work.
I am unable to access the project from the given URL's ( http://issues.alfresco.com/jira/secure/ … _Store.zip nor on http://forge.alfresco.com/)
Could you please provide me the link where the project is available.

Thanks & Regards
Anil

[aliosha79]

Hi to everyone. I know i m little late (about 8 years) but i really need to know if the Andre's code is stil availabe for download. Where can i find it?
Really thanks