[Geronimo Wiki] Update of "Database Configuration" by JohnSisson

[Apache Wiki]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Geronimo Wiki" for 
change notification.

The following page has been changed by JohnSisson:
http://wiki.apache.org/geronimo/Database_Configuration

New page:
'''Contents'''
[[TableOfContents]]

= Geronimo's Embedded Derby System =

Geronimo's `org/apache/geronimo/!SystemDatabase` configuraton starts the 
["DerbySystem GBean"], ["DerbyNetwork GBean"], 
["JDBCTransactionalThreadPooledTimer GBean"], 
["JDBCNonTransactionalThreadPooledTimer GBean"], and defines the 
["SystemDatasource"] that is intended for use by Geronimo and associated 
components (e.g. ActiveMQ).  The SystemDatasource is not intended for direct 
use by J2EE applications. 

Refer to the ["DerbySystem GBean"] and ["DerbyNetwork GBean"] topics for 
further information on configuring the embedded Derby system.

== Configuring a Server-Wide Datasource under the Embedded Derby System ==

The following command deploys the database plan file shown below using the 
Derby connector.

{{{
java -jar bin/deployer.jar deploy mydatabase-plan.xml \
               
repository/geronimo/rars/geronimo-derby-connector-1.0-SNAPSHOT.rar
}}}

Sample database plan file:
{{{
<?xml version="1.0" encoding="UTF-8"?>

<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector";
    version="1.5"
    configId="com/mycompany/MyDatabase"
    parentId="org/apache/geronimo/SystemDatabase"
>

    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
                
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>jdbc/MYDB</name>
                    <config-property-setting 
name="UserName">applicationUsername</config-property-setting>
                    <config-property-setting 
name="Password">password</config-property-setting>
                    <config-property-setting 
name="DatabaseName">MYDB</config-property-setting>
                    <config-property-setting 
name="CreateDatabase">create</config-property-setting>
                    <connectionmanager>
                        <xa-transaction>
                            <transaction-caching/>
                        </xa-transaction>
                        <single-pool>
                            <max-size>10</max-size>
                            
<blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                    <global-jndi-name>MYDB</global-jndi-name>
                </connectiondefinition-instance>
             </connection-definition>
        </outbound-resourceadapter>
        
    </resourceadapter>

</connector>
}}}