You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Stefan Burkard <sb...@previon.ch> on 2004/07/12 14:37:05 UTC
is a "mixed" store (jdbc/filesystem) possible?
hi slide-users
can i define ONE store that has a jdbc-store for the nodestore, a
filesystem-store for the content-store and a reference to the jdbc-store
on all other substores?
i've seen some examples using jdbc OR filesystem for all substores of
ONE store, but no mixed example (just mixed in the term of using two
stores - one with all substores as filesystem, one with all substores as
jdbc)
thanks and greetings
stefan
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: is a "mixed" store (jdbc/filesystem) possible?
Posted by Luke Noel-Storr <lu...@dsl.pipex.com>.
Umm, that's a good question actually. I based this domain.xml on
someone elses so am not actually all that sure.
I'll try and investiagte for you if I get a moment (I'm quite bust
today), and nobody else has answered by then.
Cheers
Luke.
-----
Stefan Burkard wrote:
> great - that's exactly what i meant!
>
> may i ask what you're doing for the revision-stores? if i understand
> this config right you store it into the database, but with a class
> that uses/generates xml-files???
>
> that looks interesting because i will receive xml-files each
> containing metadata to a pdf-file
>
> greetings
> stefan
>
>
>
> Luke Noel-Storr wrote:
>
>> If I understand you correctly - then yes, as this is what I have set
>> up. With my set-up all the content is stored in files, everything
>> else is stored in a database.
>>
>> Here is the relevant part of my domain.xml:
>>
>> <definition>
>> <store name="MySqlStore">
>> <nodestore
>> classname="org.apache.slide.store.impl.rdbms.JDBCStore">
>> <parameter
>> name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</parameter>
>>
>> <parameter
>> name="driver">com.mysql.jdbc.Driver</parameter>
>> <parameter
>> name="url">jdbc:mysql://localhost/slide</parameter>
>> <parameter name="user">admin</parameter>
>> <parameter name="dbcpPooling">false</parameter>
>> <parameter name="maxPooledConnections">10</parameter>
>> <parameter name="isolation">SERIALIZABLE</parameter>
>> <parameter name="compress">false</parameter>
>> </nodestore>
>> <contentstore
>> classname="org.apache.slide.store.txfile.TxFileContentStore">
>> <parameter name="rootpath">store2/content</parameter>
>> <parameter name="workpath">work2/content</parameter>
>> <!--<reference store="nodestore" />-->
>> </contentstore>
>> <securitystore>
>> <reference store="nodestore" />
>> </securitystore>
>> <lockstore>
>> <reference store="nodestore" />
>> </lockstore>
>> <revisiondescriptorsstore
>> classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
>> <reference store="nodestore" />
>> </revisiondescriptorsstore>
>> <revisiondescriptorstore
>> classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
>> <reference store="nodestore" />
>> </revisiondescriptorstore>
>> </store>
>> <scope match="/" store="MySqlStore"/>
>> </definition>
>>
>>
>>
>> Stefan Burkard wrote:
>>
>>> hi slide-users
>>>
>>> can i define ONE store that has a jdbc-store for the nodestore, a
>>> filesystem-store for the content-store and a reference to the
>>> jdbc-store on all other substores?
>>>
>>> i've seen some examples using jdbc OR filesystem for all substores
>>> of ONE store, but no mixed example (just mixed in the term of using
>>> two stores - one with all substores as filesystem, one with all
>>> substores as jdbc)
>>>
>>> thanks and greetings
>>> stefan
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>>
>>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: is a "mixed" store (jdbc/filesystem) possible?
Posted by Stefan Lützkendorf <lu...@apache.org>.
In a configuration like this
<revisiondescriptorsstore classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
<reference store="nodestore" />
</revisiondescriptorsstore>
the classname attribute is ignored and the referenced store is used
so Lukes configuration does the following:
- it stores information about the directory structure ("Nodes"),
about locks and about permissions in the JDBC store (in its MySQL DB)
- it stores the content of all resources in a file store for content
- it stores information about properties i.e. meta data in the same
store as the nodes (a revision descriptore is simply a container of
the meta data of a single revision)
- and it stores information about the structure of the version tree, labels
etc. in the same store too, stored as revision descriptorS (notice the plural)
hope this helps, Stefan L.
Stefan Burkard wrote:
> great - that's exactly what i meant!
>
> may i ask what you're doing for the revision-stores? if i understand
> this config right you store it into the database, but with a class that
> uses/generates xml-files???
>
> that looks interesting because i will receive xml-files each containing
> metadata to a pdf-file
>
> greetings
> stefan
>
>
>
> Luke Noel-Storr wrote:
>
>> If I understand you correctly - then yes, as this is what I have set
>> up. With my set-up all the content is stored in files, everything
>> else is stored in a database.
>>
>> Here is the relevant part of my domain.xml:
>>
>> <definition>
>> <store name="MySqlStore">
>> <nodestore
>> classname="org.apache.slide.store.impl.rdbms.JDBCStore">
>> <parameter
>> name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</parameter>
>>
>> <parameter
>> name="driver">com.mysql.jdbc.Driver</parameter>
>> <parameter
>> name="url">jdbc:mysql://localhost/slide</parameter>
>> <parameter name="user">admin</parameter>
>> <parameter name="dbcpPooling">false</parameter>
>> <parameter name="maxPooledConnections">10</parameter>
>> <parameter name="isolation">SERIALIZABLE</parameter>
>> <parameter name="compress">false</parameter>
>> </nodestore>
>> <contentstore
>> classname="org.apache.slide.store.txfile.TxFileContentStore">
>> <parameter name="rootpath">store2/content</parameter>
>> <parameter name="workpath">work2/content</parameter>
>> <!--<reference store="nodestore" />-->
>> </contentstore>
>> <securitystore>
>> <reference store="nodestore" />
>> </securitystore>
>> <lockstore>
>> <reference store="nodestore" />
>> </lockstore>
>> <revisiondescriptorsstore
>> classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
>> <reference store="nodestore" />
>> </revisiondescriptorsstore>
>> <revisiondescriptorstore
>> classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
>> <reference store="nodestore" />
>> </revisiondescriptorstore>
>> </store>
>> <scope match="/" store="MySqlStore"/>
>> </definition>
>>
>>
>>
>> Stefan Burkard wrote:
>>
>>> hi slide-users
>>>
>>> can i define ONE store that has a jdbc-store for the nodestore, a
>>> filesystem-store for the content-store and a reference to the
>>> jdbc-store on all other substores?
>>>
>>> i've seen some examples using jdbc OR filesystem for all substores of
>>> ONE store, but no mixed example (just mixed in the term of using two
>>> stores - one with all substores as filesystem, one with all substores
>>> as jdbc)
>>>
>>> thanks and greetings
>>> stefan
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>>
>>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: is a "mixed" store (jdbc/filesystem) possible?
Posted by Stefan Burkard <sb...@previon.ch>.
great - that's exactly what i meant!
may i ask what you're doing for the revision-stores? if i understand
this config right you store it into the database, but with a class that
uses/generates xml-files???
that looks interesting because i will receive xml-files each containing
metadata to a pdf-file
greetings
stefan
Luke Noel-Storr wrote:
> If I understand you correctly - then yes, as this is what I have set
> up. With my set-up all the content is stored in files, everything else
> is stored in a database.
>
> Here is the relevant part of my domain.xml:
>
> <definition>
> <store name="MySqlStore">
> <nodestore
> classname="org.apache.slide.store.impl.rdbms.JDBCStore">
> <parameter
> name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</parameter>
>
> <parameter
> name="driver">com.mysql.jdbc.Driver</parameter>
> <parameter
> name="url">jdbc:mysql://localhost/slide</parameter>
> <parameter name="user">admin</parameter>
> <parameter name="dbcpPooling">false</parameter>
> <parameter name="maxPooledConnections">10</parameter>
> <parameter name="isolation">SERIALIZABLE</parameter>
> <parameter name="compress">false</parameter>
> </nodestore>
> <contentstore
> classname="org.apache.slide.store.txfile.TxFileContentStore">
> <parameter name="rootpath">store2/content</parameter>
> <parameter name="workpath">work2/content</parameter>
> <!--<reference store="nodestore" />-->
> </contentstore>
> <securitystore>
> <reference store="nodestore" />
> </securitystore>
> <lockstore>
> <reference store="nodestore" />
> </lockstore>
> <revisiondescriptorsstore
> classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
> <reference store="nodestore" />
> </revisiondescriptorsstore>
> <revisiondescriptorstore
> classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
> <reference store="nodestore" />
> </revisiondescriptorstore>
> </store>
> <scope match="/" store="MySqlStore"/>
> </definition>
>
>
>
> Stefan Burkard wrote:
>
>> hi slide-users
>>
>> can i define ONE store that has a jdbc-store for the nodestore, a
>> filesystem-store for the content-store and a reference to the
>> jdbc-store on all other substores?
>>
>> i've seen some examples using jdbc OR filesystem for all substores of
>> ONE store, but no mixed example (just mixed in the term of using two
>> stores - one with all substores as filesystem, one with all substores
>> as jdbc)
>>
>> thanks and greetings
>> stefan
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: is a "mixed" store (jdbc/filesystem) possible?
Posted by Luke Noel-Storr <lu...@dsl.pipex.com>.
If I understand you correctly - then yes, as this is what I have set
up. With my set-up all the content is stored in files, everything else
is stored in a database.
Here is the relevant part of my domain.xml:
<definition>
<store name="MySqlStore">
<nodestore
classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter
name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</parameter>
<parameter
name="driver">com.mysql.jdbc.Driver</parameter>
<parameter
name="url">jdbc:mysql://localhost/slide</parameter>
<parameter name="user">admin</parameter>
<parameter name="dbcpPooling">false</parameter>
<parameter name="maxPooledConnections">10</parameter>
<parameter name="isolation">SERIALIZABLE</parameter>
<parameter name="compress">false</parameter>
</nodestore>
<contentstore
classname="org.apache.slide.store.txfile.TxFileContentStore">
<parameter name="rootpath">store2/content</parameter>
<parameter name="workpath">work2/content</parameter>
<!--<reference store="nodestore" />-->
</contentstore>
<securitystore>
<reference store="nodestore" />
</securitystore>
<lockstore>
<reference store="nodestore" />
</lockstore>
<revisiondescriptorsstore
classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
<reference store="nodestore" />
</revisiondescriptorsstore>
<revisiondescriptorstore
classname="org.apache.slide.store.txfile.TxXMLFileDescriptorsStore">
<reference store="nodestore" />
</revisiondescriptorstore>
</store>
<scope match="/" store="MySqlStore"/>
</definition>
Stefan Burkard wrote:
> hi slide-users
>
> can i define ONE store that has a jdbc-store for the nodestore, a
> filesystem-store for the content-store and a reference to the
> jdbc-store on all other substores?
>
> i've seen some examples using jdbc OR filesystem for all substores of
> ONE store, but no mixed example (just mixed in the term of using two
> stores - one with all substores as filesystem, one with all substores
> as jdbc)
>
> thanks and greetings
> stefan
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
RE: is a "mixed" store (jdbc/filesystem) possible?
Posted by Michael Oliver <ol...@matrix-media.com>.
Yes, indeed you can have content in the filesystem using the default
TxFileContentStores and the metadata in a JDBC Descriptor Store and even
break it down further with custom stores you can put exactly what you
want, where you want/need it and through setting of scope you can even
have some content managed one way and other content managed another way.
Michael Oliver
CTO
Matrix Intermedia Inc.
3325 N. Nellis Blvd, #1
Las Vegas, NV 89115
Phone:(702)643-7425
Fax:(520)844-1036
-----Original Message-----
From: news [mailto:news@sea.gmane.org] On Behalf Of Stefan Burkard
Sent: Monday, July 12, 2004 5:37 AM
To: slide-user@jakarta.apache.org
Subject: is a "mixed" store (jdbc/filesystem) possible?
hi slide-users
can i define ONE store that has a jdbc-store for the nodestore, a
filesystem-store for the content-store and a reference to the jdbc-store
on all other substores?
i've seen some examples using jdbc OR filesystem for all substores of
ONE store, but no mixed example (just mixed in the term of using two
stores - one with all substores as filesystem, one with all substores as
jdbc)
thanks and greetings
stefan
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org