search

yuva2achieve / solidbase

Automatically exported from code.google.com/p/solidbase
Apache License 2.0
0 stars 0 forks source link

connection properties #152

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
Make connection properties configurable.

Critical to analyze if it is possible to add this later without impact on the 
Ant, Maven and commandline versions of SolidBase.

Original issue reported on code.google.com by rene.de....@gmail.com on 20 Dec 2011 at 8:33

GoogleCodeExporter commented 8 years ago 
Ant:

    <upgradedb upgradefile="upgrade-hsqldb-example.sql" target="1.0.*">
        <connection-properties>
            prop1 = value1
        </connection-properties>
        <connection driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:mem:testant" username="sa" password="">
            <properties>
                prop2 = value2
            </properties>
        </connection>
        <secondary name="queues" url="jdbc:hsqldb:mem:queues" username="sa" password="">
            <properties>
                prop3 = value3
            </properties>
        </secondary>
    </upgradedb>

Maven:

    <configuration>
        <upgradefile>upgrade-hsqldb-example.sql</upgradefile>
        <target>1.0.*</target>
        <connection-properties>
            prop1 = value1
        </connection-properties>
        <connections>
            <connection>
                <url>jdbc:hsqldb:mem:testplugin</url>
                <username>sa</username>
                <password></password>
                <properties>
                    prop2 = value2
                </properties>
            </connection>
            <secondary>
                <name>queues</name>
                <url>jdbc:hsqldb:mem:queues</url>
                <username>sa</username>
                <password></password>
                <properties>
                    prop3 = value3
                </properties>
            </secondary>
        </connections>
    </configuration>

properties:

    # Default connection property
    connection.property.prop1 = value1

    # primary connection named 'default'
    connection.driver = org.hsqldb.jdbcDriver
    connection.url = jdbc:hsqldb:mem:test1
    connection.username = sa
    connection.default.property.prop2 = value2

    # secondary connection named 'queues'
    # connection.queues.driver & connection.queues.url can also be used if
    # you need a driver or url that is different from the primary connection
    connection.queues.username = sa
    connection.queues.property.prop3 = value3

Original comment by rene.de....@gmail.com on 10 Jun 2012 at 8:25