Network Deployment (Distributed operating systems), v8.0 > Reference > Jython script library
JDBC query scripts
The scripting library provides many script procedures to manage Java Database Connectivity (JDBC) configurations in the environment. This topic provides usage information for scripts that retrieve configuration IDs for your 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...
WAS_HOME/scriptLibraries/resources/JDBC/V70Beginning with v7, the Jython script library provides script functions for JDBC providers, JMS resources, and resource providers at the server scope. We can write your own custom scripts to configure resources at the cell, node, or cluster level. Do not edit the script procedures in the script library.
To write custom script library procedures, use the scripts in the WAS_HOME/scriptLibraries directory as Jython syntax samples. Save the custom scripts to a new subdirectory to avoid overwriting the library.
Fastpath: 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 your JDBC configuration:
listDataSources
Display a list of configuration IDs for the data sources in the configuration.
No input arguments are required for the script. However, you can specify a data source name to return a specific configuration id, as defined in the following table:
listDataSources script. Run the script to list data sources.
Argument Description dsName Optionally specifies the name of the data source of interest. Syntax
AdminJDBC.listDataSources(dsName)Example usage
AdminJDBC.listDataSources()AdminJDBC.listDataSources("myDataSource")
listDataSourceTemplates
Display a list of configuration IDs for the data source templates in the environment.
No input arguments are required for the script. However, you can specify a template name to return a specific configuration id, as defined in the following table:
listDataSourceTemplates script. Run the script to list data source templates.
Argument Description templateName Optionally specifies the name of the template of interest. Syntax
AdminJDBC.listDataSourceTemplates(templateName)Example usage
AdminJDBC.listDataSourceTemplates()AdminJDBC.listDataSourceTemplates("Derby JDBC Driver DataSource")
listJDBCProviders
Display a list of configuration IDs for the JDBC providers in the environment.
No input arguments are required for the script. However, you can specify a JDBC provider name to return a specific configuration id, as defined in the following table:
listJDBCProviders script. Run the script to list JDBC providers.
Argument Description jdbcName Optionally specifies the name of the JDBC provider of interest. Syntax
AdminJDBC.listJDBCProviders(jdbcName)Example usage
AdminJDBC.listJDBCProviders()AdminJDBC.listJDBCProviders("myJDBCProvider")
listJDBCProviderTemplates
Display a list of configuration IDs for the JDBC provider templates in the environment.
No input arguments are required for the script. However, you can specify a template name to return a specific configuration id, as defined in the following table:
listJDBCProviderTemplates script. Run the script to list JDBC provider templates.
Argument Description templateName Optionally specifies the name of the template of interest. Syntax
AdminJDBC.listJDBCProviderTemplates(templateName)Example usage
AdminJDBC.listJDBCProviderTemplates()AdminJDBC.listJDBCProviderTemplates("Derby JDBC Provider")
Use the script library to automate the application serving environment using wsadmin.sh
Automate data access resource configuration using wsadmin.sh
Related
JDBC configuration scripts
JMS query scripts
JMS configuration scripts
J2C configuration scripts
J2C query scripts