THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Common Vendors
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>
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>
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>
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>
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>
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>
Information
Internally, OpenEJB relies on Apache Commons DBCP to manage DataSources. To get the full list of available configuration properties, have a look to Apache Commons DBCP configuration.