[Opensource] New EDG Coverage, multiple databases

[Peter A. J. Pilgrim]

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.

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/" />