content/common-datasource-configurations.mdtext

Title: Common DataSource Configurations

See the [DataSource Configuration](datasource-config.html) for details on all configuration options for DataSources.

<a name="CommonDataSourceConfigurations-HSQLDB"></a>
## HSQLDB

The drivers are included with OpenEJB 3.0 and HSQLDB is the default
database.

    <Resource id="HSQLDB Database" type="DataSource">
        JdbcDriver org.hsqldb.jdbcDriver
        JdbcUrl jdbc:hsqldb:file:hsqldb
        UserName sa
        Password
    </Resource>


<a name="CommonDataSourceConfigurations-Derby(Embedded)"></a>
## Derby (Embedded)


    <Resource id="Derby Database" type="DataSource">
        #Embedded Derby example
    
        JdbcDriver org.apache.derby.jdbc.EmbeddedDriver
        JdbcUrl jdbc:derby:derbyDB;create=true
        UserName admin
        Password pass
    </Resource>


<a name="CommonDataSourceConfigurations-MySQL"></a>
## MySQL


    <Resource id="MySQL Database" type="DataSource">
        #  MySQL example
        #
        #  This connector will not work until you download the driver at:
        #  http://www.mysql.com/downloads/api-jdbc-stable.html
    
        JdbcDriver	com.mysql.jdbc.Driver
        JdbcUrl	jdbc:mysql://localhost/test
        UserName	test
    </Resource>


<a name="CommonDataSourceConfigurations-Oracle"></a>
## Oracle


    <Resource id="Oracle Database" type="DataSource">
        #  Oracle example
        #
        #  This connector will not work until you download the driver at:
        #  http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
        JdbcDriver	oracle.jdbc.OracleDriver
        JdbcUrl	jdbc:oracle:thin:@localhost:1521:orcl
        UserName	scott
        Password	tiger
    </Resource>

<a name="CommonDataSourceConfigurations-OracleXA"></a>
## OracleXA


    <Resource id="OracleXA Database" type="DataSource">
        #  OracleXA example
        #
        #  This connector will not work until you download the driver at:
        #  http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
        JdbcDriver	oracle.jdbc.xa.client.OracleXADataSource
        JdbcUrl	jdbc:oracle:thin:@localhost:1521:orcl
        UserName	scott
        Password	tiger
    </Resource>

<a name="CommonDataSourceConfigurations-PosgreSQL"></a>
## PosgreSQL


    <Resource id="PostgreSQL Database" type="DataSource">
        #  PostgreSQL example
        #
        #  This connector will not work until you download the driver at:
        #  http://jdbc.postgresql.org/download.html
        JdbcDriver	 org.postgresql.Driver
        JdbcUrl	 jdbc:postgresql://localhost/test
        UserName	 postgres
        Password	 pass
    </Resource>


<a name="CommonDataSourceConfigurations-InstantDB"></a>
## InstantDB


    <Resource id="InstantDB Database" type="DataSource">
        #  InstantDB example
        #
        JdbcDriver	 org.enhydra.instantdb.jdbc.idbDriver
        JdbcUrl	 jdbc:idb:conf/instantdb.properties
        UserName	 Admin
        Password	 pass
    </Resource>



Internally, from TomEE 1.5.0, JDBC pools are managed via Tomcat-pool. You can still switch back to Apache Commons DBCP by adding the following property: DataSourceCreator dbcp.  To
get the full list of available configuration properties, have a look to [Apache Commons DBCP configuration](http://commons.apache.org/dbcp/configuration.html).