Data source minimum required settings for Apache Derby

These properties vary according to the database vendor requirements for JDBC driver implementations. Set the appropriate properties on every data source that you configure. These settings are for Apache Derby and Cloudscape™ data sources.

Configure the following types of providers:

• Derby JDBC Provider
• Derby JDBC Provider (XA)
• Derby JDBC Provider 40
• Derby JDBC Provider 40 (XA)
• Derby Network Server using Derby Client
• Derby Network Server using Derby Client (XA)
• Derby Network Server using Derby Client 40
• Derby Network Server using Derby Client 40 (XA)

• Derby JDBC Provider

  The Derby JDBC driver provides JDBC access to the Apache Derby database by using the framework that is already embedded in the appserver. We cannot use any V4.0 data sources with this provider. This provider:

  • Is configurable only in nodes at version 6.0.2 and later

  • Supports one phase data source with the following class:

    org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource
    

  • Requires the JDBC driver file:

    • derby.jar

      The full path name is ${DERBY_JDBC_DRIVER_PATH}/derby.jar. By creating a connection through the appserver, the environment variables are set automatically.

  • Requires the following DataStoreHelper class:

    com.ibm.websphere.rsadapter.DerbyDataStoreHelper
    

  • Requires the following properties:

    databaseName

    The name of the database from which the data source obtains connections. If we do not specify a fully qualified path name, the appserver uses the default location of APP_ROOT/derby or the equivalent default for AIX, HP-UX, Linux, or Solaris system environments. An example for the database path name is:

    • [AIX] [HP-UX] [Linux] [Solaris]

      /tmp/sampleDB

    • (Windows) c:\temp\sampleDB

    If no database exists for the path name to specify, append ;create=true to the path name to create a database dynamically. For example:

    c:\temp\sampleDB;create=true
    

• Derby JDBC Provider (XA)

  The Derby JDBC driver (XA) provides JDBC access to the Apache Derby database by using the framework that is already embedded in the appserver. This provider:

  • Does not support use V4.0 data sources.

  • Is configurable only in nodes at version 6.0.2 and later

  • Supports the two-phase data source with the following class:

    org.apache.derby.jdbc.EmbeddedXADataSource
    

  • Requires JDBC driver file:

    • derby.jar

      The full path name is ${DERBY_JDBC_DRIVER_PATH}/derby.jar. By creating a connection through the appserver, the environment variables are set automatically.

  • Requires the following DataStoreHelper class:

    com.ibm.websphere.rsadapter.DerbyDataStoreHelper
    

  • Does not require a valid authentication alias.

  • Requires the following properties:

    databaseName

    The name of the database from which the data source obtains connections. If we do not specify a fully qualified path name, the appserver uses the default location of APP_ROOT/derby or the equivalent default for AIX, HP-UX, Linux, or Solaris system environments. An example for the database path name is:

    • [AIX] [HP-UX] [Linux] [Solaris]

      /tmp/sampleDB

    • (Windows) c:\temp\sampleDB

    If no database exists for the path name to specify, append ;create=true to the path name to create a database dynamically. For example:

    c:\temp\sampleDB;create=true
    

• Derby JDBC Provider 40

  The Derby JDBC Provider 40 provides JDBC access to the Apache Derby database by using the framework that is already embedded in the appserver. This provider:

  • Is configurable only in nodes at version 7.0 and later.

  • Does not support V4.0 data sources.

  • Supports one phase data source with the following class:

    org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource40
    

  • Requires the JDBC driver file:

    • derby.jar

      The full path name is ${DERBY_JDBC_DRIVER_PATH}/derby.jar. By creating a connection through the appserver, the environment variables are set automatically.

  • Requires the following DataStoreHelper class:

    com.ibm.websphere.rsadapter.DerbyDataStoreHelper
    

  • Requires the following properties:

    databaseName

    The name of the database from which the data source obtains connections. If we do not specify a fully qualified path name, the appserver uses the default location of APP_ROOT/derby or the equivalent default for AIX, HP-UX, Linux, or Solaris system environments. An example for the database path name is:

    • [AIX] [HP-UX] [Linux] [Solaris]

      /tmp/sampleDB

    • (Windows) c:\temp\sampleDB

    If no database exists for the path name to specify, append ;create=true to the path name to create a database dynamically. For example:

    c:\temp\sampleDB;create=true
    

• Derby JDBC Provider 40 (XA)

  The Derby JDBC Provider 40 (XA) provides JDBC access to the Apache Derby database by using the framework that is already embedded in the appserver. This provider:

  • Is configurable only in nodes at version 7.0 and later.

  • Does not support V4.0 data sources.

  • Supports one phase data source with the following class:

    org.apache.derby.jdbc.EmbeddedXADataSource40
    

  • Requires the JDBC driver file:

    • derby.jar

      The full path name is ${DERBY_JDBC_DRIVER_PATH}/derby.jar. By creating a connection through the appserver, the environment variables are set automatically.

  • Requires the following DataStoreHelper class:

    com.ibm.websphere.rsadapter.DerbyDataStoreHelper
    

  • Requires the following properties:

    databaseName

    The name of the database from which the data source obtains connections. If we do not specify a fully qualified path name, the appserver uses the default location of APP_ROOT/derby or the equivalent default for AIX, HP-UX, Linux, or Solaris system environments. An example for the database path name is:

    • [AIX] [HP-UX] [Linux] [Solaris]

      /tmp/sampleDB

    • (Windows) c:\temp\sampleDB

    If no database exists for the path name to specify, append ;create=true to the path name to create a database dynamically. For example:

    c:\temp\sampleDB;create=true
    

• Derby Network Server using Derby Client

  Use this provider to access only Apache Derby databases that run on the same node as the appserver. This provider:

  • Does not support V4.0 data sources.

  • Is configurable only in nodes at version 6.1 and later

  • Uses the following one phase data source for the Derby Network Server using Derby Client provider:

    org.apache.derby.jdbc.ClientConnectionPoolDataSource
    

  • Requires the following JDBC driver file:

    • derbyclient.jar

  • Requires DataStoreHelper class:

    com.ibm.websphere.rsadapter.DerbyNetworkServerDataStoreHelper
    

  • Requires the following property:

    databaseName

    The name of the database from which the data source obtains connections. If we do not specify a fully qualified path name, the appserver uses the default location of APP_ROOT/derby or the equivalent default for AIX, HP-UX, Linux, or Solaris system environments. An example for the database path name is:

    • [AIX] [HP-UX] [Linux] [Solaris]

      /tmp/sampleDB

    • (Windows) c:\temp\sampleDB

    If no database exists for the path name to specify, append ;create=true to the path name to create a database dynamically. For example:

    c:\temp\sampleDB;create=true
    

• Derby Network Server using Derby Client (XA)

  Use this provider to access only Apache Derby databases that run on the same node as the appserver. This provider:

  • Does not support V4.0 data sources.

  • Is configurable only in nodes at version 6.1 and later

  • Uses the following XA data source for this Derby Network Server using Derby Client provider:

    org.apache.derby.jdbc.ClientXADataSource
    

  • Requires the following JDBC driver file:

    • derbyclient.jar

  • Requires the DataStoreHelper class:

    com.ibm.websphere.rsadapter.DerbyNetworkServerDataStoreHelper
    

  • Requires the following property:

    databaseName

    The name of the database from which the data source obtains connections. If we do not specify a fully qualified path name, the appserver uses the default location of APP_ROOT/derby or the equivalent default for AIX, HP-UX, Linux, or Solaris system environments. An example for the database path name is:

    • [AIX] [HP-UX] [Linux] [Solaris]

      /tmp/sampleDB

    • (Windows) c:\temp\sampleDB

    If no database exists for the path name to specify, append ;create=true to the path name to create a database dynamically. For example:

    c:\temp\sampleDB;create=true
    

• Derby Network Server using Derby Client 40

  Use this provider to access only Apache Derby databases that run on the same node as the appserver. This provider:

  • Is configurable only in nodes at version 7.0 and later

  • Does not support V4.0 data sources.

  • Uses the following one phase data source for the Derby Network Server using Derby Client provider:

    org.apache.derby.jdbc.ClientConnectionPoolDataSource40
    

  • Requires the following JDBC driver file:

    • derbyclient.jar

  • Requires DataStoreHelper class:

    com.ibm.websphere.rsadapter.DerbyNetworkServerDataStoreHelper
    

  • Requires the following property:

    databaseName

    The name of the database from which the data source obtains connections. If we do not specify a fully qualified path name, the appserver uses the default location of APP_ROOT/derby or the equivalent default for AIX, HP-UX, Linux, or Solaris system environments. An example for the database path name is:

    • [AIX] [HP-UX] [Linux] [Solaris]

      /tmp/sampleDB

    • (Windows) c:\temp\sampleDB

    If no database exists for the path name to specify, append ;create=true to the path name to create a database dynamically. For example:

    c:\temp\sampleDB;create=true
    

• Derby Network Server using Derby Client 40 (XA)

  Use this provider to access only Apache Derby databases that run on the same node as the appserver. This provider:

  • Is configurable only in nodes at version 7.0 and later

  • Does not support V4.0 data sources.

  • Uses the following one phase data source for the Derby Network Server using Derby Client provider:

    org.apache.derby.jdbc.ClientXADataSource40
    

  • Requires the following JDBC driver file:

    • derbyclient.jar

  • Requires DataStoreHelper class:

    com.ibm.websphere.rsadapter.DerbyNetworkServerDataStoreHelper
    

  • Requires the following property:

    databaseName

    The name of the database from which the data source obtains connections. If we do not specify a fully qualified path name, the appserver uses the default location of APP_ROOT/derby or the equivalent default for AIX, HP-UX, Linux, or Solaris system environments. An example for the database path name is:

    • [AIX] [HP-UX] [Linux] [Solaris]

      /tmp/sampleDB

    • (Windows) c:\temp\sampleDB

    If no database exists for the path name to specify, append ;create=true to the path name to create a database dynamically. For example:

    c:\temp\sampleDB;create=true
    

---

 

Related tasks

Set a JDBC provider and data source
Set a JDBC provider
Set a data source
Create and configuring a JDBC provider and data source using the Java Management Extensions API

 

Related information

http://publib.boulder.ibm.com/infocenter/cscv/v10r1/index.jsp