[Opensource] Deploying Expresso without a "default" database

[Larry Hamel]

yes, expresso-config lets you assign the db context named "default" to attach to any DB name you like, e.g.

for mysql, make a DB named "myfavoritedbname" and then (replacing server name, potentially--I assume localhost)

   <context name="default">
                <description>mysql Database</description>
        <jdbc
            driver="org.gjt.mm.mysql.Driver"
            url="jdbc:mysql://localhost/myfavoritedbname"
            connectFormat="1"
            cache="y"
            login="padi_admin"
            password="padi_admin2"
            createTableIndicies="true"
            hasBooleanType="false"
            limitationPosition="LIMITATION_AFTER_ORDER_BY"
            limitationSyntax="LIMIT %offset% , %maxrecords%"
            escapeHandler="com.jcorporate.expresso.core.db.MySQLEscapeHandler"
        />
        <type-mapping>
            <java-type>LONGVARCHAR</java-type>
            <db-type>text</db-type>
        </type-mapping>
        <type-mapping>
            <java-type>BIT</java-type>
            <db-type>CHAR</db-type>
        </type-mapping>
        <type-mapping>
            <java-type>VARCHAR</java-type>
            <db-type>varchar</db-type>
        </type-mapping>
        <images>%context%/%expresso-dir%/images</images>
        <startJobHandler>y</startJobHandler>
        <showStackTrace>y</showStackTrace>
        <mailDebug>n</mailDebug>
        </context>

tell us how you like eapp in two months--we should keep tabs on the best hosting outfits!

larry

At 12:50 PM 1/8/2004, maxxam at inetfreemail.co.za wrote:
>I've just got a hosting plan for my expresso application and am almost
>ready to deploy it. Like most hosting providers, mine (eapps.com) uses a
>shared mysql server. They do not allow me to set-up a database by the name
>of "default". I have tried before to use expresso with a different
>database name but have always come unglued. It seems that expresso needs a
>"default" database to start up initially. AFter that it then allowed me to
>use a different database name.
>
>Is this the case, or am I doing something wrong. Can one deploy an
>expresso app to a server without a default database?
>
>Thanks for the help,
>Max

Larry Hamel
----------------------
Free link-test tool (special handling for Expresso sites): http://morebot.org
Custom web site development: http://codeguild.com