+

Search Tips   |   Advanced Search

JDBC query scripts

The scripting library provides many script procedures to manage Java Database Connectivity (JDBC) configurations in the environment. See the usage information for scripts that retrieve configuration IDs for the JDBC configuration. We can run each script individually or combine many procedures to create custom automation scripts for the environment.

Each AdminJDBC script procedure is located in the app_server_root/scriptLibraries/resources/JDBC/V70 directory.

Beginning with Version 7, the Jython script library provides script functions for JDBC providers, JMS resources, and resource providers at the server scope. We can write our own custom scripts to configure resources at the cell, node, or cluster level.

Avoid trouble: Do not edit the script procedures in the script library. To write custom script library procedures, use the scripts in the app_server_root/scriptLibraries directory as Jython syntax samples. Save the custom scripts to a new subdirectory to avoid overwriting the library.gotcha

Fast path: Beginning with Fix Pack 5, the Jython script library provides script functions for JDBC providers, JMS resources, and resource providers at the cell, node, server, or cluster scope. Resource providers include mail providers, URL providers, and resource environment providers. You do not have to write custom scripts to configure resources at a particular scope.

Use the following script procedures to query the JDBC configuration:


listDataSources

This script displays a list of configuration IDs for the data sources in our configuration.

No input arguments are required for the script. However, we can specify a data source name to return a specific configuration id, as defined in the following table:

Argument Description
dsName Optionally specifies the name of the data source of interest.

Syntax

Example usage


listDataSourceTemplates

This script displays a list of configuration IDs for the data source templates in the environment.

No input arguments are required for the script. However, we can specify a template name to return a specific configuration id, as defined in the following table:

Argument Description
templateName Optionally specifies the name of the template of interest.

Syntax

Example usage


listJDBCProviders

This script displays a list of configuration IDs for the JDBC providers in the environment.

No input arguments are required for the script. However, we can specify a JDBC provider name to return a specific configuration id, as defined in the following table:

Argument Description
jdbcName Optionally specifies the name of the JDBC provider of interest.

Syntax

Example usage


listJDBCProviderTemplates

This script displays a list of configuration IDs for the JDBC provider templates in the environment.

No input arguments are required for the script. However, we can specify a template name to return a specific configuration id, as defined in the following table:

Argument Description
templateName Optionally specifies the name of the template of interest.

Syntax

Example usage


Related tasks

  • Use the script library to automate the application serving environment
  • Automating data access resource configuration

  • JDBC configuration scripts
  • JMS query scripts
  • JMS configuration scripts
  • J2C configuration scripts
  • J2C query scripts