topic Re: Blob Based Content Store implemented in Alfresco Archive

Blob Based Content Store implemented

andre — Mon, 21 May 2007 15:37:15 GMT

Hi,I've just uploaded my imlementation of a database based content store: http://issues.alfresco.com/secure/attachment/10461/DB_Content_Store.zipAll content is streamed - so handling large files is no problem.streaming content into and out of the db is done by the class BlobFileDAOImpl (JdbcDaoSuppo

Re: Blob Based Content Store implemented

steve — Tue, 22 May 2007 10:21:35 GMT

Hi,
I have made your post sticky because there have been several other community members who are after this functionality!

Great work, by the way.

Steve

Re: Blob Based Content Store implemented

paulhh — Tue, 22 May 2007 15:57:11 GMT

Hi Andre

Nice work - good to see you busy again!

Is it dependent on any specific database implementation - or will it work on other DBs than Oracle?

Cheers
Paul.

Re: Blob Based Content Store implemented

andre — Wed, 23 May 2007 16:37:35 GMT

Thanks Steve and Paul,

Basicly it should be no problem to use other DBs if they support the streaming of blobs.

The current DAO-implementation is dependent on Oracle's JDBC driver because of the class org.springframework.jdbc.support.lob.OracleLobHandler. For othter DBs spring's DefaultLobHandler should be the right choise.

Re: Blob Based Content Store implemented

andre — Thu, 12 Jul 2007 15:24:11 GMT

I have just uploaded a new improved version that seems to work with alfresco 2.1. The project can be found here:

http://issues.alfresco.com/browse/AR-195

maybe a forge project at http://forge.alfresco.com/ would be good if anybody is interested in a collaboration on this issue…

Re: Blob Based Content Store implemented

olivanja — Mon, 17 Mar 2008 14:55:16 GMT

Hi Andre, sorry for my English.

I`ve tried your source code in my Alfreso and it's runned without problems.

I have a Tomcat 5.5 with JVM 1.5.0.15 in my computer, and a remote DB2 V9.5 database on Open Suse 10.2.
I use db2jcc.jar and db2jcc_license_cu.jar, as JDBC drivers, to connect with the database.
I've added your code such as jar file in my WEB-INF/lib
I've only had to change some properties in BlobFile.hbm.xml file:

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE hibernate-mapping PUBLIC
    '-//Hibernate/Hibernate Mapping DTD 3.0//EN'
    'http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd'>

<hibernate-mapping>

   <class
         name="de.juwimm.blobfilestore.BlobFileImpl"
         proxy="de.juwimm.blobfilestore.BlobFile"
         table="alf_blob_file"
         dynamic-update="false"
         dynamic-insert="false"
         select-before-update="false"
         optimistic-lock="version" >
      <!– <id name="contentUrl" column="content_url" type="string" length="1024" /> I can't create a primary key with 1024 –>
      <id name="contentUrl" column="content_url" type="string" length="500" />
      <!– <property name="contentBlob" column="content" type="blob"/> I've had to add length property because by defect blob's size isn't so longer. This is max. size for Blob type of DB2 (2GB) –>
      <property name="contentBlob" column="content" type="blob" length="214743647"/>
      <!– <property name="size" column="content_length" type="int" /> –>
      <property name="size" column="content_length" type="integer" />
      <property name="date" column="created_date" type="java.sql.Date" />

   </class>

</hibernate-mapping>

Now I'm going to try this source code with a DB2 database on iSeries (AS400 V5R4), I expect running without problems.

Well, thanks very much. Good job Andre.

Re: Blob Based Content Store implemented

golemwashere — Thu, 01 May 2008 14:12:15 GMT

Thanks
that's what was keeping back alfresco adoption in my company….
(My boss is an Oracle DBA and would not trust sticking files in anything else)
please support the project and make it grow!
G.

Re: Blob Based Content Store implemented

joechavez — Thu, 03 Jul 2008 15:21:36 GMT

Very interesting. Have you done some benchmarking against the filesystem content store?

Re: Blob Based Content Store implemented

pmonks — Thu, 03 Jul 2008 20:43:04 GMT

If anyone does perform some benchmarking, it would be ideal if manipulation of content via CIFS was included. CIFS can generate far more I/O churn on the binary content of files than the other means for manipulating files (APIs, Web Client, WebDAV, FTP, etc.).

In fact this is one of the primary reasons that Alfresco (by default) uses the disk for storing file content rather than BLOBs in the RDBMS (see http://newton.typepad.com/content/2006/09/content_storage.html for a comprehensive treatment of this topic).

Cheers,
Peter

Re: Blob Based Content Store implemented

glendesouza — Tue, 30 Dec 2008 14:50:04 GMT

We were planning on using the blob based content store in a production environment. Has anyone used the blob content store and if so - were there any issues observed.

Re: Blob Based Content Store implemented

derek — Tue, 21 Apr 2009 10:17:57 GMT

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

Re: Blob Based Content Store implemented

norgan — Tue, 29 Sep 2009 13:58:23 GMT

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

Re: Blob Based Content Store implemented

lamba — Fri, 02 Apr 2010 11:37:59 GMT

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.

Re: Blob Based Content Store implemented

lamba — Mon, 05 Apr 2010 09:30:58 GMT

Hi everyone,

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

thanks.

Re: Blob Based Content Store implemented

inocka — Mon, 19 Jul 2010 08:44:30 GMT

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

Re: Blob Based Content Store implemented

krdian — Tue, 05 Jun 2012 11:53:37 GMT

Hi,

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

Cheers,

Konrad

Re: Blob Based Content Store implemented

bannu — Tue, 30 Oct 2012 05:01:57 GMT

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

Re: Blob Based Content Store implemented

aliosha79 — Sat, 21 Feb 2015 10:07:33 GMT

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