JackRabbit workspace reached 32000 index directories

2009-03-11 Thread sbarriba
Hi all, We're using JackRabbit 1.4.5. One of workspaces is logging lots of errors as follows. The directory /var/repository/workspaces/acme/index contains 32000 directories which is presumably the problem. In what circumstances does JackRabbit create so many indexes at one level and how can this

Jackrabbit 1.5 improvements?: BundleCache vs ItemManager vs CacheManager

2009-01-27 Thread sbarriba
and the (MySql)PersistenceManager. I see the following is still a known issue. [JCR-1846] Jackrabbit thread contention issue due to fat lock Can anyone comment if there's been any significant concurrency improvements in this area? Regards, Shaun -Original Message- From: sbarriba

RE: Is using jcr:path in a query a performance bottleneck?

2009-01-26 Thread sbarriba
Thanks Ard, Marcel. RE the comments on memory usage...we're seeing some pretty aggressive heap usage with lots of these queries going on - the heap can consume 50 to 100MB every few seconds and then GC'ing back down. We've tuned the GC but are there any memory settings we should be looking at

Is using jcr:path in a query a performance bottleneck?

2009-01-23 Thread sbarriba
Hi all, I've included some background below but my question is. is using jcr:path in a query to be avoided due to performance? We have some Jackrabbit repositories which have grown to include circa 200,000 nodes of a acme:Story. The nodes have been structured in a deep hierarchy to comply

RE: JackRabbit web explorers

2008-12-18 Thread sbarriba
To: users@jackrabbit.apache.org Subject: Re: JackRabbit web explorers On Wed, Dec 3, 2008 at 10:25 AM, sbarriba sbarr...@yahoo.co.uk wrote: What are people using as generic web explorers for JCR repositories? http://dev.day.com/microsling/content/blogs/main/jcrtools.html http://wiki.apache.org

RE: JackRabbit web explorers

2008-12-16 Thread sbarriba
Perfect, thanks Alexander. We'll review those explorer options. -Original Message- From: Alexander Klimetschek [mailto:aklim...@day.com] Sent: 03 December 2008 10:47 To: users@jackrabbit.apache.org Subject: Re: JackRabbit web explorers On Wed, Dec 3, 2008 at 10:25 AM, sbarriba sbarr

JackRabbit web explorers

2008-12-03 Thread sbarriba
Hi all, What are people using as generic web explorers for JCR repositories? We're looking for web-app based solutions which can be collocated with other JCR modules (using JNDI). We've reviewed http://www.jcr-explorer.org/ but has been dormant for a while. All suggestions welcome.

SYSDATE() or NOW() concept in JCR query?

2008-11-06 Thread sbarriba
Hi all, We want to be able to query a set of nodes that have a date property which is earlier than the current date. Is there a function facility within JCR SQL or XPath which will be replaced with the current time/date? I can do it by creating a literal date in Java to achieve.

RE: JCR Query Result Caching

2008-09-22 Thread sbarriba
Hi Arid, Having read through your email and http://www.nabble.com/Explanation-and-solutions-of-some-Jackrabbit-queries-r egarding-performance-td15028655.html in more detail with respect to: * param name=respectDocumentOrder value=false/ if we have JCR types that are explicitly ordered will

JackRabbit tables on MySql - MyISAM vs InnoDB

2008-09-22 Thread sbarriba
Hi all, The DDL for MySql doesn't specify MyISAM or InnoDB. As a result it uses the default table type which is usually MyISAM I believe. Anyone have any issues / comments with using InnoDB instead with JackRabbit? Regards, Shaun

Datastore + Fault Tolerant + BundleCache settings

2008-08-05 Thread sbarriba
Hi all, We currently store BLOBs in the database and are considering migrating to file-based DataStore (for various reasons). Assuming a configuration of 2 linux servers running clustered JackRabbit instances. The datastore would be configured to reference a SAN or shared NFS. Assuming a

RE: JackRabbit Caching: BundleCache vs ItemManager vs CacheManager

2008-07-24 Thread sbarriba
ItemManager vs CacheManager hi shaun On Sun, Jul 20, 2008 at 2:13 PM, sbarriba [EMAIL PROTECTED] wrote: Hi Stefan, So the intention is that once the session is no longer used then the ItemImpl instances are cleared up? yes, unless ItemImpl instances are still being externally refertenced by client code

RE: JackRabbit Caching: BundleCache vs ItemManager vs CacheManager

2008-07-20 Thread sbarriba
ItemManager vs CacheManager hi sean On Tue, Jul 1, 2008 at 7:11 PM, sbarriba [EMAIL PROTECTED] wrote: Hi Marcel et al, 3 suggestions come to mind from this (perhaps for the develop list): 1) the ItemManager should be using Soft References rather than Weak References otherwise a PooledSessionInView

RE: Scalability of using reference properties

2008-07-20 Thread sbarriba
a shame as references are really useful and the alternatives move the emphasis to the application to enforce node-to-node dependencies, which personally I think is wrong. Regards, Shaun From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 15 April 2008 14:14 To: users@jackrabbit.apache.org

RE: Concurrent Bottleneck within JackRabbit due to Lock Contention

2008-07-01 Thread sbarriba
contention, right? or does jackrabbit lock up completely, which would indicate a dead lock. regards marcel sbarriba wrote: Hi all, With an application which makes 'heavy' usage of JackRabbit we see its throughput throttled by JackRabbits usage of org/apache/jackrabbit/core/state

Concurrent Bottleneck within JackRabbit due to Lock Contention

2008-06-29 Thread sbarriba
. -Original Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 27 June 2008 17:30 To: users@jackrabbit.apache.org Subject: RE: Locking issues with XAItemStateManager - help appreciated Hi all, Can anyone help me understand why a JackRabbit based web-app that only reads the repository

RE: Locking issues with XAItemStateManager - help appreciated

2008-06-27 Thread sbarriba
into deadlock. Have you tested the patched DefaultISMLocking Class ? -Ursprüngliche Nachricht- Von: sbarriba [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 25. Juni 2008 12:52 An: users@jackrabbit.apache.org Betreff: RE: Locking issues with XAItemStateManager - help appreciated Apologies

XA usage having an impact on locking disabling XA

2008-06-27 Thread sbarriba
, Regards, Shaun -Original Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 25 June 2008 11:35 To: users@jackrabbit.apache.org Subject: RE: Locking issues with XAItemStateManager - help appreciated Hi Claus, Thanks for the quick response. We're not intentionally using an XA

Locking issues with XAItemStateManager - help appreciated

2008-06-25 Thread sbarriba
Hi all, As follow up to a previous thread we're seeing lots and lots of contention around the following lock. We're using Weblogic 9.1 / JRocket 27.4.0 (1.5). Even with very little load on the app a thread dump shows active threads at exactly this point. As the concurrent load increases the

RE: Locking issues with XAItemStateManager - help appreciated

2008-06-25 Thread sbarriba
...and as an aside I note from http://g.oswego.edu/dl/classes/EDU/oswego/cs/dl/util/concurrent/intro.html That concurrent 1.3.4 is now in maintenance mode. Is there a plan to move to java.util.concurrent within the JDK? Regards, Shaun -Original Message- From: sbarriba [mailto:[EMAIL

RE: Locking issues with XAItemStateManager - help appreciated

2008-06-25 Thread sbarriba
a xa transaction ? take a look @ https://issues.apache.org/jira/browse/JCR-1334 i see in your stack that the lock comes from acquireReadLock() this was also in my issue feel free do test the PatchedDefaultISMLocking.java by Marcel BR, claus -Ursprüngliche Nachricht- Von: sbarriba [mailto

RE: Locking issues with XAItemStateManager - help appreciated

2008-06-25 Thread sbarriba
Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 25 June 2008 11:35 To: users@jackrabbit.apache.org Subject: RE: Locking issues with XAItemStateManager - help appreciated Hi Claus, Thanks for the quick response. We're not intentionally using an XA transaction. We're using Spring

RE: Intermittent JackRabbit dead lock with concurrent QueryImpl.execute() and NodeImpl.getProperty()

2008-06-24 Thread sbarriba
: Intermittent JackRabbit dead lock with concurrent QueryImpl.execute() and NodeImpl.getProperty() Hi Shaun, can you please provide the complete thread dump? thanks regards marcel sbarriba wrote: Hi Marcel et al, Just had another occurrence of the deadlock issue within JackRabbit 1.4. Perhaps

RE: Controlling the cache size to reduce BLOB property eviction

2008-06-24 Thread sbarriba
June 2008 19:57 To: users@jackrabbit.apache.org Subject: Re: Controlling the cache size to reduce BLOB property eviction On Fri, Jun 13, 2008 at 3:37 PM, sbarriba [EMAIL PROTECTED] wrote: To summarise my question - is there a way to increase the number of InternalValue (and I guess nodes

RE: Logging/Detecting slow JCR queries with Lucene

2008-06-24 Thread sbarriba
@jackrabbit.apache.org Subject: Re: Logging/Detecting slow JCR queries with Lucene Hi, sbarriba wrote: Hi all, Our application makes quite heavy use of JCR queries. We're seeing some scenarios where the IO utilisation is very high for a period of time. A thread dump of Tomcat shows lots

Controlling the cache size to reduce BLOB property eviction

2008-06-13 Thread sbarriba
Hi all, To summarise my question - is there a way to increase the number of InternalValue (and I guess nodes) that are cached by JackRabbit? I see a hard reference to an upper limit of 10,000 in CachingHierarchyManager. The issue is... ..We're using BLOBs in the database (to

Business Rules JackRabbit

2008-05-30 Thread sbarriba
Hi all, Can anyone comment on using a business rules engine and JackRabbit for storing the underlying structured data? I'm interested to hear about any working examples. I found 1 post referring to drools JackRabbit. (http://www.nabble.com/BRMS-locks-jackrabbit-td15018752.html). All

RE: Intermittent JackRabbit dead lock with concurrent QueryImpl.execute() and NodeImpl.getProperty()

2008-05-14 Thread sbarriba
Reutegger [mailto:[EMAIL PROTECTED] Sent: 09 May 2008 13:56 To: users@jackrabbit.apache.org Subject: Re: Intermittent JackRabbit dead lock with concurrent QueryImpl.execute() and NodeImpl.getProperty() Hi, sbarriba wrote: I just noticed http://www.nabble.com/-jira--Created:-(JCR-1334)-Deadlock

RE: Intermittent JackRabbit dead lock with concurrent QueryImpl.execute() and NodeImpl.getProperty()

2008-05-08 Thread sbarriba
I just noticed http://www.nabble.com/-jira--Created:-(JCR-1334)-Deadlock-with-XA-enabled-td 14997630.html. Could that be related given we've deployed JackRabbit as a RAR module within Weblogic? Regards, Shaun -Original Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 08 May 2008

Scalability of using reference properties

2008-04-15 Thread sbarriba
Hi all, Last year David Nuescheler provided some very useful data modelling rules - 1 of which related to the use of reference properties. We had various, reasonable, use cases for which we felt references were appropriate e.g. to ensure referential integrity. While semantically they've

Migrating to DataStore - large memory usage of importxml

2008-04-15 Thread sbarriba
Hi all, Firstly worth saying how good the DataStore solution is - well done to the team. We're considering migrating some pretty large repositories over to a DataStore implementation but are limited by the memory usage of the importxml command. We can run exportSysView to produce a 3GB XML

JackRabbit 1.4 overwriting PathMap.Element WARN

2008-01-28 Thread sbarriba
Hi all, First to say a big well done to the JackRabbit team for the 1.4 release - it's been stable to date and has resolved our main challenges (auto connection restore). The performance under load also seems up with the concurrency improvements. The only issue we've picked up post-migration

Anyone using JackRabbit clustering with external BLOBs?

2008-01-22 Thread sbarriba
Hi all, I believe the intention is that JackRabbit clustering is usually combined with externalBlobs false to ensure all binaries are available for all cluster nodes. We're hitting some performance issues when storing blobs in Oracle. Is anyone else successfully using clustering with

Performance issue due to blocking on Oracle9PersistenceManager

2008-01-17 Thread sbarriba
Hi all, Under a reasonable load we're seeing lots (100's per day) of occurrences of the following exception. This appears to be due to the synchronised nature of the exists method. Any recommendations on how to avoid this significant bottleneck with JackRabbit? We're using Weblogic 9.2 with

RE: Jackrabbit MySQL

2008-01-05 Thread sbarriba
Hi Esteban, We've been using both MySql 5 and Oracle as a backend for our Jackrabbit 1.3 deployment for over a year without major issue. MySql has been fast and reliable plus its replication facilities work well with Jackrabbits clustering features to provide a fault-tolerant architecture. The

FW: MySql 5.0 JackRabbit: Connection issue

2008-01-05 Thread sbarriba
Hi JackRabbit team, Any ideas on when JackRabbit 1.4 will be released? We're eagerly awaiting a fix for JCR-940. Regards, Shaun -Original Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 12 October 2007 15:31 To: users@jackrabbit.apache.org Subject: RE: MySql 5.0 JackRabbit

RE: JackRabbit Journal table growing very large - archive strategy?

2008-01-05 Thread sbarriba
, Shaun -Original Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 17 December 2007 22:13 To: users@jackrabbit.apache.org Subject: RE: JackRabbit Journal table growing very large - archive strategy? Thanks for this Dominique. RE ..after having verified that every node in the cluster

RE: Shared session pool

2008-01-05 Thread sbarriba
Hi Andrea, We use an Open Session In View pattern with Jackrabbit and org.apache.commons.pool.KeyedObjectPool. Within a Filter: * we determine the context workspace name from the request (based on the URL) * retrieve a JCR session from the pool * bind it to the thread for the duration of the

RE: JackRabbit Journal table growing very large - archive strategy?

2007-12-17 Thread sbarriba
read all outstanding changes, you may delete all entries in the revision table JOURNAL (when using the DatabaseJournal) or delete all journal.log files in the journal directory (when using the FileJournal). Kind regards Dominique On 16/12/2007, sbarriba [EMAIL PROTECTED] wrote: Hi Dominique et al

JackRabbit Journal table growing very large - archive strategy?

2007-12-16 Thread sbarriba
Hi Dominique et al, We've been running a 2 node clustered JackRabbit for a few months. The journal table has grown to 1.1GB. Any guidance on how the admin procedure to delete old data from this table? Regards, Shaun

RE: Cluster Backup

2007-11-16 Thread sbarriba
) is available. Greetings, Jacco van Weert On 10/5/07, sbarriba [EMAIL PROTECTED] wrote: Hi all, During a recent thread Hot Backup Tools were discussed - see http://www.mail-archive.com/users@jackrabbit.apache.org/msg04255.html. As an outcome of that we're doing 2 things: 1

RE: MySql 5.0 JackRabbit: Connection issue

2007-10-12 Thread sbarriba
, sbarriba [EMAIL PROTECTED] wrote: I notice that https://issues.apache.org/jira/browse/JCR-940 (JCR-940: add db connection autoConnect for BundleDbPersistenceManager.) is not included in the 1.3.3 release notes and does not have a fix version in JIRA. However it is fixed. Will this fix

RE: MySql 5.0 JackRabbit: Connection issues

2007-10-10 Thread sbarriba
Hi all, I notice that https://issues.apache.org/jira/browse/JCR-940 (JCR-940: add db connection autoConnect for BundleDbPersistenceManager.) is not included in the 1.3.3 release notes and does not have a fix version in JIRA. However it is fixed. Will this fix to included in the next JackRabbit

Memory usage issues of importml/exportsysview

2007-10-05 Thread sbarriba
Hi all, During a recent thread Hot Backup Tools were discussed - see http://www.mail-archive.com/users@jackrabbit.apache.org/msg04255.html. As an outcome of that we're doing 2 things: 1) Low-level backup o Backing up the database o Backing up the repository file system 2)

JackRabbit 1.3.2 timelines?

2007-09-09 Thread sbarriba
Hi all, Any idea when JackRabbit 1.3.2 will be released and if it will include JCR-940 https://issues.apache.org/jira/browse/JCR-940 autoConnect? Regards, Shaun.

RE: How to manage JCR Types with JackRabbit? - a contrast with DDL

2007-09-05 Thread sbarriba
: sbarriba [mailto:[EMAIL PROTECTED] Sent: 27 August 2007 10:29 To: users@jackrabbit.apache.org Subject: How to manage JCR Types with JackRabbit? - a contrast with DDL Hi all, I agree with recent threads on why not to modify the custom_nodetypes.xml directly. I personally have not yet found a good resource

RE: reporting

2007-09-03 Thread sbarriba
Hi Mark, We are using a mixed setup of a) JackRabbit for all content management and b) relational database for all non-content related data e.g. transactions. The transaction data includes content IDs. To allow us to cross-reference the IDs to properties (title, price etc) in the content model

How to manage JCR Types with JackRabbit? - a contrast with DDL

2007-08-27 Thread sbarriba
Hi all, I agree with recent threads on why not to modify the custom_nodetypes.xml directly. I personally have not yet found a good resource describing best practises for managing JCR types with JackRabbit - for example I know there are some limitations on what reRegisterNodeTypes() can achieve. So

Queries with where clause referencing other properties

2007-08-27 Thread sbarriba
Hi all, We have the following use case. .[acme:Category] mix:referenceable o acme:name o acme:subCategories (reference) multiple COPY o 'acme:Category' .[acme:CategorisedObject] o acme:categories (reference) multiple COPY 'acme:Category

RE: Node corruption - simple testcase - UUID-to-binary issue?

2007-08-27 Thread sbarriba
] Sent: 27 August 2007 17:31 To: users@jackrabbit.apache.org Subject: Re: Node corruption - simple testcase - UUID-to-binary issue? hi shaun On 8/26/07, sbarriba [EMAIL PROTECTED] wrote: Testing shows this issue highlights a problem with the Bundle persistence manager and MySqls method of handling

RE: Node corruption - simple testcase - UUID-to-binary issue?

2007-08-26 Thread sbarriba
| NO | | | | +-+---+--+-+-+---+ 2 rows in set (0.00 sec) mysql alter table test3_bundle modify NODE_ID varbinary(16); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 -Original Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 25 August 2007 18:31 To: 'users@jackrabbit.apache.org

RE: Node corruption - simple testcase - UUID-to-binary issue?

2007-08-25 Thread sbarriba
:[EMAIL PROTECTED] Sent: 20 August 2007 15:20 To: users@jackrabbit.apache.org Subject: Re: Node corruption - simple testcase hi shaun, On 8/20/07, sbarriba [EMAIL PROTECTED] wrote: Hi all, After much investigation we have a simple reproducible testcase to illustrate an example of corruption using

RE: Node corruption - simple testcase

2007-08-20 Thread sbarriba
exception: javax.jcr.ItemNotFoundException message: a55f3f6b-a909-4e8d-b65a-93002ced0920 Regards, Shaun -Original Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 17 August 2007 15:15 To: users@jackrabbit.apache.org Subject: RE: Node corruption using Jackrabbit 1.3.1? Hi Stefan et

RE: Node corruption using Jackrabbit 1.3.1?

2007-08-17 Thread sbarriba
Guggisberg [mailto:[EMAIL PROTECTED] Sent: 17 August 2007 11:26 To: users@jackrabbit.apache.org Subject: Re: Node corruption using Jackrabbit 1.3.1? hi shaun, On 8/16/07, sbarriba [EMAIL PROTECTED] wrote: Hi all, We upgraded to JackRabbit 1.3.1 a few days ago. We have since seen a couple

RE: Node corruption using Jackrabbit 1.3.1?

2007-08-17 Thread sbarriba
using 1.3.1: http://www.nabble.com/Strange-%22ignoring-nonexistent-item%22-and-removeitem -fails-tf4169086.html On 8/17/07, sbarriba [EMAIL PROTECTED] wrote: Hi Stefan et al, Further update on this, plus some answers to your questions. The consistency check and fix logic in JackRabbit 1.3.1 solved

RE: New workspaces are not clustered with LocalFileSystem

2007-08-15 Thread sbarriba
with LocalFileSystem hi shaun, please create a jira bug issue. cheers stefan On 8/7/07, sbarriba [EMAIL PROTECTED] wrote: I'm hoping to come up with a solution for the following clustering show stopper - no responses thus far. Does anyone have any suggestions? Thanks in advance, Shaun. -Original

RE: Model 2 Deployment Problems

2007-08-13 Thread sbarriba
* Can you post your server config? * Worth setting up log4j at the app server level to debug out JackRabbit logging. For Tomcat 5 this is achieved by putting a log4j.xml in [Tomcat]/common/classes. * Is anything getting created in the configured repHomeDir (the repository directory)? Regards,

RE: New workspaces are not clustered with LocalFileSystem

2007-08-07 Thread sbarriba
I'm hoping to come up with a solution for the following clustering show stopper - no responses thus far. Does anyone have any suggestions? Thanks in advance, Shaun. -Original Message- From: sbarriba [mailto:[EMAIL PROTECTED] Sent: 01 August 2007 21:28 To: users@jackrabbit.apache.org

RE: ObjectPersistenceManager vs SimpleDbPersistenceManager

2007-08-07 Thread sbarriba
Hi Phillip, Have you tried the new org.apache.jackrabbit.core.persistence.bundle.*PersistenceManagers? e.g. org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager Regards, Shaun. -Original Message- From: Phillip Rhodes [mailto:[EMAIL PROTECTED] Sent: 07 August 2007 16:51

RE: Easy way to migrate to externalBlobs?

2007-08-01 Thread sbarriba
Out of interest Bram. Why are you migrating from internal to external? Regards, Shaun. -Original Message- From: Bram de Kruijff [mailto:[EMAIL PROTECTED] Sent: 01 August 2007 13:36 To: users@jackrabbit.apache.org Subject: Easy way to migrate to externalBlobs? Hi, we need to convert a

New workspaces are not clustered with LocalFileSystem

2007-08-01 Thread sbarriba
Hi all, We’re continuing to tune our fault tolerant JackRabbit environment. Thus far we have: ·2 machines ·Each running Tomcat 5.0.30 with JackRabbit 1.3 as a model 2 shared resource ·JackRabbit is configured with MySqlPersistenceManager, LocalFileSystem and Database

RE: Strange ignoring nonexistent item and removeitem fails

2007-07-31 Thread sbarriba
: Strange ignoring nonexistent item and removeitem fails hi shaun, On 7/30/07, sbarriba [EMAIL PROTECTED] wrote: Hi Stefan, what persistence manager are you using? We're using MySql 5.0.27, mysql-connector-java-5.0.6-bin.jar and PersistenceManager class

Strange ignoring nonexistent item and removeitem fails

2007-07-30 Thread sbarriba
Hi all, We have a fairly complex structured node - Node A. Node A contains various child nodes that have references. When attempting to delete the Node A using removeitem in the command line: exception: javax.jcr.ItemNotFoundException message: eb76dc5d-4d56-4ceb-9586-fdcedd53a2e7 No

Locking within a clustered environment

2007-07-27 Thread sbarriba
Hi all, We're testing clustering with 2 JackRabbit 1.3 instances - Instance 1 and Instance 2 using the DatabaseJournal with MySql. I've able to lock node /home/nodeA in instance 1. My expectation is that attempting to lock this in instance 2 would yield a Node already locked error. Instead

Accessing Node.getName() within a query - no jcr:name psuedo property?

2007-07-27 Thread sbarriba
Hi all, We want to use the name of the node within a JCR query - for example within an ORDER BY. You can get at the path using the pseudo property jcr:path but there is no equivalent jcr:name. Are there any ways of doing this that I've missed? Regards, Shaun.

Export ignores type definition in CND file

2007-07-17 Thread sbarriba
Hi all, We came across the following issue when migrating between versions of a our CND file. Assume version 1 of an application has: [acme:TestType] nt:Base - acme:foo (long) protected COPY - acme:bar (long) protected COPY You then create various

RE: MySql 5.0 JackRabbit: Connection issues

2007-07-15 Thread sbarriba
timouts caused by inactivity. There Cheers, Marcel sbarriba wrote: Hi all, We're testing our application using JackRabbit 1.3 with MySql 5.0.27 and mysql-connector-java-5.0.6-bin.jar. After the application has been running for a period of time we start getting various persistence failures

MySql 5.0 JackRabbit: Connection issues

2007-07-13 Thread sbarriba
Hi all, We're testing our application using JackRabbit 1.3 with MySql 5.0.27 and mysql-connector-java-5.0.6-bin.jar. After the application has been running for a period of time we start getting various persistence failures within JCR mainly referencing Connection.close() has already been called.

RE: DM Rule #4: Beware of Same Name Siblings.

2007-07-10 Thread sbarriba
Hi David et al, (...definite opportunity for a book here David :)) People use SNS mostly for large, unordered collections, which it is definitely not what they are designed for. When mapping our object model to JCR I used SNS for almost all composition relationships, both ordered and unordered.

Achieving DRAFT published to LIVE concepts - separate workspaces?

2007-07-10 Thread sbarriba
The 3 questions below are prompted by David's rules on Workspaces and References. [Scenario] .JCR used to hold web pages. .Pages are served straight from JCR. .Site structure e.g. page links is modelled as references in JCR to ensure referential integrity. This

RE: Hot backup solutions?

2007-07-09 Thread sbarriba
Hi Thomas et al, Has anyone considered writing an schedulable process (e.g. using Spring) which iterates through all workspaces performing an exportsysview() on each workspace generating an XML file backup? Anyone come up with negatives for doing? Negatives I can think of include: * the backup

RE: DM Rule #7: ID's are evil.

2007-07-07 Thread sbarriba
Hi David, [Very useful set of DM Rules by the way!] so there really is no need to come up with an additional means of identifying a node in a stable fashion We had one requirement that prompted us to introduce an instance of a numeric 'id' field that is managed using the Sequence node solution.

RE: DM Rule #4: Beware of Same Name Siblings.

2007-07-07 Thread sbarriba
Hi David et al, Interesting comment on SNS. Our model includes various SNS and while 'yes' I agree that [1],[2] etc aspect can cause problems how else would you model anonymous composition where Object A contains multiple instances of Object B, where Object B has no unique distinguishing concept

Hot backup solutions?

2007-07-06 Thread sbarriba
Hi all, What are people using to hot backup their JackRabbit repositories? Our requirements are: 1) The repository needs to be 100% available - so no downtime permitted 2) It's sufficient to backup the data only - we can separately backup the NodeTypes and Repository config etc.

RE: Hot backup solutions?

2007-07-06 Thread sbarriba
Hi Thomas et al, We've using hot backups of the file system and database right now. That's ok but I really want to be able to backup and restore individual workspaces (our system has a distinct workspace for each customer). Imagine the scenario where a particular workspace was corrupted or we