[Opensource] New EDG Coverage, multiple databases

[Michael Rimov]

At 08:05 PM 9/6/2002 +0100, you wrote:
>Michael Rimov wrote:
>>Peter, and all others struggling with multiple db stuff
>>I wrote some into EDG regarding this and your problems... I've omitted 
>>screenshots and the formatting is a bit messed up thanks to email 
>>clients, but it should help.  The biggest confusion is that when dealing 
>>with multiple databases, you either have two completely independent 
>>databases in which case you want Expresso also created in the other 
>>database, or you have to program in the Schema to have OtherDBMap work 
>>properly to map just a few tables to the other db context.  It probably 
>>could be improved, but at least it's sort of documented now.  Text from 
>>the new sections included below.
>>HTH and sorry it took so long to reply.
>>                                                 -Mike
>>
>>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
>Hi Mike
>
>I looked at the DTD in CVS and figured out the EDG may be still
>wrong. Your example does not mention <hasSetupTables> tags.

Hi Peter!
I just checked the source code, and it lists <hasSetupTables> in the 
following description:  [It's part 2 of the multiple database connection 
section]

         <context name="test">
                 <description>A sample test database</description>
                 <hasSetupTables>false</hasSetupTables>


I wonder if I just mis-copied it......  <shrug>

Anyway, the short answer is that what you're trying to do Expresso isn't 
currently capable of doing.  Either you have to program a schema to look in 
otherDBMap, or you have two completely independent Expresso installations. 
(In your case, context eContent would first have Expresso, and then add the 
eContent installation to that)

Of course, I'm sure it could be added, I don't see any reason why it 
couldn't... [A later release, of course! ;) ]

HTH!
                                                 -Mike





>I looked at the DTD and found you need to set
>
><hasSetupTables>n</hasSetupTables>
>
>after the <description> tag!!
>
><context name="econtent"  >
>        <description>MYSQL eContent Testing</description>
>        <hasSetupTables>n</hasSetupTables>
>        <jdbc
>            driver="org.gjt.mm.mysql.Driver"
>            url="jdbc:mysql://localhost:3306/econtent"
>            connectFormat="1"
>            login="please"
>            password="workforme"
>            cache="y"
>            checkZeroUpdate="false"
>            limitationPosition="LIMITATION_AFTER_ORDER_BY"
>            limitationSyntax="LIMIT %offset% , %maxrecords%" />
>
>...
></context>
>
>I still cant figure how to set up econtent to load in another
>database from the admin web pages though. Oh bug. I replace
>2-01 with the early access one and it did compile with against
>the latest CVS EF 4-1.
>
>It's the weekend
>
>--
>Peter Pilgrim         +-----\ +-++----++----+
>Java Technologist     |     | | ||    ||    | 'n' Shine
>                       |  O  | | ||  --+| ---+
>         /\            | ._  / | | \  \ |    |
>        /  \           | | \ \ | |+--  || ---+ A new day
>       /_  _\  "Up"    | | | | | ||    ||    | is coming
>         ||            +-+ +-+ +-++----++----+
><home page="http://www.xenonsoft.demon.co.uk/" />
>
>_______________________________________________
>Opensource mailing list
>Opensource at jcorporate.com
>http://mail.jcorporate.com/mailman/listinfo/opensource
>Archives: http://mail.jcorporate.com/pipermail/opensource/