Normally, you can simply work with the interfaces for javax.sql.DataSource, javax.sql.ConnectionPoolDataSource, and javax.sql.XADataSource, as shown in the following examples.
import org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource; import org.apache.derby.jdbc.EmbeddedDataSource; import org.apache.derby.jdbc.EmbeddedXADataSource; javax.sql.ConnectionPoolDataSource cpds = new EmbeddedConnectionPoolDataSource(); javax.sql.DataSource ds = new EmbeddedDataSource(); javax.sql.XADataSource xads = new EmbeddedXADataSource();
Derby provides six properties for a DataSource. These properties are in org.apache.derby.jdbc.EmbeddedDataSource. They are:
This mandatory property must be set. It identifies which database to access. If a database named wombat located at /local1/db/wombat is to be accessed, then one should call setDatabaseName("/local1/db/wombat") on the data source object.
Optional. Sets a property to create a database the next time the XADataSource.getXAConection() method is called. The string createString is always "create" (or possibly null). (Use the method setDatabaseName() to define the name of the database.)
Optional. Sets a property to shut down a database. The string shutDownString is always "shutdown" (or possibly null). Shuts down the database the next time XADataSource.getXAConnection().getConnection() method is called.
Optional. Name for ConnectionPooledDataSource or XADataSource. Not used by the data source object. Used for informational purpose only.
Optional. Description of the data source. Not used by the data source object. Used for informational purpose only.
Optional. Connection attributes specific to Derby. See the Derby Reference Manual for a more information about the attributes.