+

Search Tips   |   Advanced Search

Configure new data sources using wsadmin

We can configure new data sources using wsdmin.sh.

Before starting this task, wsadmin.sh must be running. See the topic Starting the wsadmin scripting client for more information.

In WebSphere Application Server, any JDBC driver properties required by the database vendor must be set as data source properties. Consult the article Data source minimum required settings, by vendor to see a list of these properties and setting options, ordered by JDBC provider type. Consult the database vendor documentation to learn about available optional data source properties. Script them as custom properties after we create the data source. In the Related links section of this article, click the Configure new data source custom properties link for more information.

(zos) We can also learn about optional data source properties in the Application Programming Guide and Reference for Java for the version of DB2 for z/OS , if you use one of the following JDBC providers:

There are two ways to perform this task; use either of the following wsadmin scripting objects:

AdminConfig gives you more configuration control than the AdminTask object. When creating a data source using AdminTask, you supply universally required properties only, such as a JNDI name for the data source. (Consult the article JDBCProviderManagement command group (AdminTask) for more information.) Other properties required by the JDBC driver are assigned default values by Application Server. We cannot use AdminTask commands to set or edit these properties; use AdminConfig commands.


What to do next

To set additional properties that are supported by the JDBC driver, script them as data source custom properties.


Related tasks

  • Configure new data source custom properties using wsadmin
  • Create configuration objects using wsdmin.sh
  • Use the wsadmin scripting AdminConfig object for scripted administration
  • Synchronize nodes using wsdmin.sh
  • Start the wsadmin scripting client
  • Saving configuration changes with wsadmin.sh

  • Data source minimum required settings, by vendor
  • Commands for the AdminConfig object
  • WebSphere Application Server data source properties
  • JDBCProviderManagement command group for AdminTask object