Administration Guide

Local Navigation

Configuring a BlackBerry MDS Integration Service to support a JDBC driver

Developers in your organization can design BlackBerry® MDS Runtime Applications that communicate with database servers. For example, a developer can create a BlackBerry MDS Runtime Application that retrieves sales data from an organization's database server. Before you install a BlackBerry MDS Runtime Application on BlackBerry devices, you must configure the BlackBerry MDS Integration Service to support the JDBC driver that the application uses to access the database server. If the application communicates with IBM® DB2® UDB or Microsoft® SQL Server® 2005, JDBC driver support is preconfigured for the BlackBerry MDS Integration Service during the BlackBerry® Enterprise Server installation. If the application communicates with another database server, you must specify the JDBC driver information for the BlackBerry MDS Integration Service, or you must add support for a new JDBC driver to the BlackBerry MDS Integration Service.

For more information about creating a BlackBerry MDS Runtime Application that communicates with a database server, see the BlackBerry MDS Studio Plug-in for Eclipse Developer Guide.

Specify JDBC driver information for a BlackBerry MDS Integration Service

  1. In the BlackBerry® Administration Service, on the Servers and components menu, expand BlackBerry Solution topology > BlackBerry Domain > Component view > MDS Integration Service.
  2. Click the instance that you want specify JDBC driver information for.
  3. Click Edit instance.
  4. On the JDBC drivers tab, click the Edit icon for the appropriate JDBC driver.
  5. In the File path field, type the file path of the JDBC driver .jar files (for example, D:\sample\jdbcdrivers). In a high availability environment, type the network path that is accessible to all BlackBerry MDS Integration Service instances (for example, X:\driver).
  6. In the Driver jar name field, type the names of the JDBC driver .jar files and separate the names using semicolons (;) (for example, file1.jar;file2.jar;file3.jar).
  7. Click the Update icon.
  8. Click Save all.

Add support for a JDBC driver to a BlackBerry MDS Integration Service

  1. In the BlackBerry® Administration Service, on the Servers and components menu, expand BlackBerry Solution topology > BlackBerry Domain > Component view > MDS Integration Service.
  2. Click an instance.
  3. Click Edit instance.
  4. On the JDBC drivers tab, in the Driver identifier field, type the name of the JDBC driver. The name must match the driver identifier name that the developer specified in the development tool when the developer created the application.
  5. In the JDBC driver data section, in the Class name field, type the Java® class name for the JDBC driver (for example, sample.jdbc.driver.SampleDriver).
  6. In the File path field, type the file path of the JDBC driver .jar files (for example, D:\sample\jdbcdrivers). In a high availability environment, type the network path that is accessible to all BlackBerry MDS Integration Service instances (for example, X:\driver).
  7. In the Type drop-down list, click the appropriate JDBC driver type.
  8. In the Driver jar name field, type the names of the JDBC driver .jar files and separate the names using semicolons (;) (for example, file1.jar;file2.jar;file3.jar).
  9. Click the Add icon.
  10. Click Save all.

Was this information helpful? Send us your comments.