Title: Common DataSource Configurations See the [DataSource Configuration](datasource-config.html) for details on all configuration options for DataSources. ## HSQLDB The drivers are included with OpenEJB 3.0 and HSQLDB is the default database. JdbcDriver org.hsqldb.jdbcDriver JdbcUrl jdbc:hsqldb:file:hsqldb UserName sa Password ## Derby (Embedded) #Embedded Derby example JdbcDriver org.apache.derby.jdbc.EmbeddedDriver JdbcUrl jdbc:derby:derbyDB;create=true UserName admin Password pass ## MySQL # 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 ## Oracle # 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 ## OracleXA # 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 ## PosgreSQL # 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 ## InstantDB # InstantDB example # JdbcDriver org.enhydra.instantdb.jdbc.idbDriver JdbcUrl jdbc:idb:conf/instantdb.properties UserName Admin Password pass 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).