Martin Holz wrote:
"Jacob Lund" <[EMAIL PROTECTED]> writes:
Have any of you successfully configured multiple JDBC stores in domain.xml?
Have a look at the attached domain.xml file. I have defined multiple stores using TxFileStore and JDBCStore (both MySQL and SQLSever).
However it runs into a deadlock when the domain.xml definition tries to create
the objectnodes for the history and files uri's.
IIRC this was reported before for MySQL See http://thread.gmane.org/gmane.comp.jakarta.slide.user/3865
Not sure if was ever solved. It works for me with Postgres.
Hello Martin:
Do you mind to share your Domain.xml that work with Postgres. I was not able to resolve this issue yet. Here is what I have tried:
<scope match="/" store='tx" /> (Tx FileDescriptorsStore)
<scope match="/files/pmo" store="pmo" /> (PMO database in MySql instance) <scope match="/history/pmo" store="pmo" /> <scope match="/workspace/pmo" store="pmo" /> <scope match="/workingresource/pmo" store="pmo" />
This works fine. But when i introduce store testCom that connects to a separate database TESTCOM in the same MySql instance, i get a deadlock. The idea is to isolate each project in separate database. When the project is finished, all we need is a backup of the database and takes it out of the service.
<scope match="/files/testCom" store="testCom" /> (TESTCOM database in the same MySql instance)
<scope match="/history/testCom" store="testCom" />
<scope match="/workspace/testCom" store="testCom" />
<scope match="/workingresource/testCom" store="testCom" />
I have tried with both MySql 4.0.18 and 4.1.1. At this current status, i have not tried with different MySql instances or different RDBMS.
Thanks.
BaTien DBGROUPS
Martin
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
